ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData ODBC Driver for Oracle Fusion Cloud SCM ビュー


Name	Description
Finders	Lists the findername along with the attributes for a particular view.
FlexFndDffDescriptiveFlexfieldContexts	Get Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndDffDescriptiveFlexfieldContexts/{FlexFndDffDescriptiveFlexfieldContexts_Id} Get all Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndDffDescriptiveFlexfieldContexts
FlexFndPvsCharacterIdCharacterValues	Get Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsCharacterIdCharacterValues/{FlexFndPvsCharacterIdCharacterValues_Id} Get Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsCharacterValues/{FlexFndPvsCharacterValues_Id} Get Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsNumberIdCharacterValues/{FlexFndPvsNumberIdCharacterValues_Id} Get all Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsCharacterIdCharacterValues Get all Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsCharacterValues Get all Method: get Path: /fscmRestApi/resources/11.13.18.05/FlexFndPvsNumberIdCharacterValues
FlexFndPvsCharacterValues	FlexFndPvsCharacterValues
FlexFndPvsNumberIdCharacterValues	FlexFndPvsNumberIdCharacterValues
Ideas	The Ideas resource gets the details about an idea. An idea represents a suggestion to improve a product or a process, or it could represent a suggestion to launch a new product or a new process.
IdeasAttachments	The Idea Attachments resource manages the attachments for an idea.
IdeasIdeaComment	The Idea Comments resource manages the comments for an idea.
IdeasIdeaTeam	The Idea Team Members resource manages the users who are authorized to access the idea.
IdeasIdeaVote	The Idea Votes resource manages the votes for an idea. The values are Like or Dislike.
ItemCatalogs	The Item Catalogs resource manages catalog details. A catalog is a collection of categories that are arranged in a hierarchy.
ItemCatalogsattachments	The Attachments resource manages the catalog attachments.
ItemCatalogsattachmentsattachmentDFF	The Descriptive Flexfields for Attachments resource manages the contextual descriptive flexfields of the item catalog attachments.
ItemCatalogscategoryHierarchies	The Category Hierarchies resource organizes the categories of an item catalog in a hierarchy.
ItemCatalogscategoryHierarchiescategoryHierarchies	The Category Hierarchies resource organizes the categories of an item catalog in a hierarchy.
ItemCatalogsDFF	The operations from the Product Lifecycle Management/Item Catalogs/Descriptive Flexfields for Item Catalogs category.
ItemCatalogsfunctionalAreaAssignments	The Functional Area Catalog Mappings resource gets the catalogs assigned to a functional area and the functional areas assigned to a catalog.
ItemCatalogstranslatableAttributes	The Translatable Attributes resource manages the translatable attributes of item catalog.
ItemCategories	The Item Categories resource manages the category details. A category is used to manage the catalog hierarchy. Items are assigned to categories in the catalog.
ItemCategoriesattachments	The Attachments resource manages the catalog attachments.
ItemCategoriesattachmentsattachmentDFF	The Descriptive Flexfields for Attachments resource manages the contextual descriptive flexfields of the category attachments.
ItemCategoriesDFF	The operations from the Product Lifecycle Management/Item Categories/Descriptive Flexfields for Item Categories category.
ItemCategoriestranslatableAttributes	The Translatable Attributes resource manages the translatable attributes of categories.
ItemCategoryAssignments	The Item Category Assignments resource manages the relationship between an item and the category it's assigned to.
ItemsV2	The Items Version 2 resource manages the item details. An item is any part, material, product, or service that is unique when compared to the attributes of any other item.
ItemsV2ItemAttachment	The Item Attachments resource manages the attachments associated with an item.
ItemsV2ItemAttachmentAttachedDocumentsDFF	The Flexfields for Item Attachments resource manages the descriptive flexfields for item attachments.
ItemsV2ItemCategory	The Item-Category Assignments resource manages the item catalog category associations.
ItemsV2ItemDFF	The Descriptive Flexfields for Items resource manages the contextual descriptive flexfields of item.
ItemsV2ItemEffCategory	The Extensible Flexfields for Items resource manages the user-specified set of fields that are used to capture a characteristic of a item such as, color or size.
ItemsV2ItemGlobalDFF	The Global Descriptive Flexfields for Items resource manages the global descriptive flexfields for an item.
ItemsV2ItemRevision	The Item Revisions resource manages item revision details.
ItemsV2ItemRevisionItemRevisionDFF	The Descriptive Flexfields for Item Revisions resource manages the descriptive flexfields of item revision.
ItemsV2ItemRevisionItemRevisionEffCategory	The Extensible Flexfields for Item Revisions resource manages the values for item extensible flexfields. Item flexfields are user-defined attributes.
ItemsV2ItemRevisionItemRevisionTranslation	The Item Revision Translatable Attributes resource manages the translatable attributes of item revision.
ItemsV2ItemRevisionRevisionAttachment	The Item Revision Attachments resource manages attachments associated with item revisions.
ItemsV2ItemSupplierAssociation	The Item-Supplier Associations resource manages the item-supplier associations. Supplier association is the association of an item with a supplier who provides that item; for examples, the association of item CAR with supplier Seven Corporation.
ItemsV2ItemSupplierAssociationItemSupplierEffCategory	The Extensible Flexfields for Item-Supplier Associations resource manages the values for item supplier association extensible flexfields. Item flexfields are user-defined attributes.
ItemsV2ItemTranslation	The Extensible Flexfields for Item Supplier Associations resource gets the translatable fields for the item; for example, the item description is translatable.
ItemTemplates	The Item Templates resource manages item templates. An item template is a defined set of item attributes that enables quick creation of items with standard attributes. When you apply a template to an item, you overlay or default in the set of attribute values to the item definition.
ItemTemplatesitemDFFs	The Descriptive Flexfields resource manages the item contextual descriptive flexfields in an item template.
ItemTemplatesitemEFFs	The Extensible Flexfields resource manages the item extensible descriptive flexfields in an item template. Extensible flexfields are user-specified set of fields that are used to capture a characteristic of a item revision such as, color or size.
ItemTemplatesitemGlobalDFFs	The Global Descriptive Flexfields resource manages item global descriptive flexfields in an item template.
ItemTemplatesitemRevisions	The Item Revisions resource manages item revision details in an item template.
ItemTemplatesitemRevisionsDFFs	The Descriptive Flexfields for Item Revisions resource manages the item revision contextual descriptive flexfields in an item template.
ItemTemplatesitemRevisionsEFFs	The Extensible Flexfields for Item Revisions resource manages item revision extensible descriptive flexfields in an item template. Extensible flexfields are user-specified set of fields that are used to capture a characteristic of a item revision such as, color or size.
ItemTemplatesitemTranslations	The Item Translatable Attributes resource manages the translatable attributes in an item template.
StandardLookupsLOV	The standard lookups list of values resource is used to query the list of values of standard lookups, which list the available codes and translated meanings. Standard lookups are defined in the standard lookups view and store lookup codes that support reference data sharing.
TradingPartnerItemRelationships	The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
TradingPartnerItemRelationshipsDFF	The operations from the Product Lifecycle Management/Trading Partner Item Relationships/Descriptive Flexfields category.
TradingPartnerItemRelationshipstranslatableAttributes	The Translatable Attributes resource manages the translatable attributes for item relationships.