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 Excel Add-In for Oracle Fusion Cloud SCM Views
Name | Description |
Debriefs | The Debriefs resource manages additional information for a source document, technician, business unit, customer party, customer account, bill-to site, item number, serial number, asset number, and debrief status. |
DebriefsdebriefsDFF | The Flexfields for Debriefs resource manages the flexfields for a debrief. |
Debriefslines | The Debrief Lines resource manages additional information for service activity, labor item, start time, end time, material item, quantity, unit of measure, expense item, amount, and currency code. |
DebriefslineslinesDFF | The Flexfields for Debrief Lines resource manages the flexfields for a debrief line. |
DebriefsprojectDetailsDFF | The Flexfields for Project Details resource manages the flexfields that contain details about the project. |
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 |
InstalledBaseAssets | The Installed Base Assets resource manages the customer and maintainable assets. |
InstalledBaseAssetsassetDFF | The Flexfields for Assets resource manages the descriptive flexfields that contain additional details about the assets. |
InstalledBaseAssetscharges | The Charges resource manages the asset charges. The asset charge provides pricing details that are used for a flow such as billing or contract renewal. |
InstalledBaseAssetsfixedAssetAssociations | The FixedAssetAssociations resource manages the relationships between installed base and fixed assets. You can add new relationships or end date the existing ones. |
InstalledBaseAssetsmeters | The Meters resource gets the details of the meters associated with the assets. |
InstalledBaseAssetsnotes | The Notes resource manages the asset notes that provide additional details about the asset. You can add, edit and delete the notes. |
InstalledBaseAssetspartsListComponents | The Parts resource manages the asset parts list used for maintaining the asset. You can add, remove, and view the list of the asset part components. |
InstalledBaseAssetsrelationships | The Relationships resource manages the asset structure relationships. You can add, remove, or get the assets of the structure. |
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. |
StockingLocations | Service that's used to create stocking-location records in the RCL_STOCK_LOCATION table to store additional attributes for inventory organizations and subinventories. |
StockingLocationssiteDedicatedLocations | Service that's used to create site-dedicated, stocking-location addresses in the RCL_SITE_DEDICATED_LOCATIONS table to define which customer sites the parts in the associated service logistics stocking location can be used. |
TrunkStocks | The Trunk Stocks resource gets trunk stock sub-inventory quantities and serial numbers. |