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 JDBC Driver 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.