Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData SSIS Components for Oracle Fusion Cloud SCM Views
| 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. |