Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Oracle SCM Views
Name | Description |
ActiveLocators | The Active Locators resource manages inventory locators that the warehouse can use to fulfill the item and meet transaction type requirements. |
ActiveSubinventories | The Active Subinventories resource manages subinventories that the warehouse can use to fulfill the item and meet the transaction type requirements. |
AsnLinesForReceiving | The ASN Lines for Receiving resource manages the lines of the advanced shipment notice that are available to receive. |
AsnsForReceiving | The ASNs for Receiving resource manages the advanced shipment notices that are available to receive. |
CycleCountDefinitions | The Cycle Count Definitions resource manages the cycle count definitions. |
CycleCountDefinitionscountCategories | The Categories resource manages the item categories that the warehouse can use in the cycle count. |
CycleCountDefinitionscountCategoryItems | The Category Items resource manages the category items that the warehouse can use in the cycle count. |
CycleCountDefinitionscountClasses | The Classes resource manages the count classes that the warehouse can use in the cycle count. |
CycleCountDefinitionscountItems | The Items resource manages the items that the warehouse can use in the cycle count. |
CycleCountDefinitionscountSubinventories | The Subinventories resource manages the subinventories that the warehouse can use with the cycle count. |
CycleCountDefinitionsDFF | The Flexfields for Cycle Count Definitions resource manages the details about cycle counts. |
CycleCountSchedules | The Cycle Count Schedules resource manages the cycle count schedules. |
CycleCountSequenceDetails | The Cycle Count Sequence Details resource manages details for the cycle count sequences. |
CycleCountSequenceDetailsDFF | The Flexfields for Cycle Count Sequence Details manages details of the descriptive flexfields that reference the cycle count sequence. |
CycleCountSequenceDetailshistory | The History resource manages details for the history of cycle count sequences. |
CycleCountSequenceDetailshistoryhistorySerials | The History Serials resource manages details for the history serials of cycle count sequences. |
CycleCountSequenceDetailsinventoryAttributesDFF | The Flexfields for Tracking Attributes resource manages details of the descriptive flexfields that reference the cycle count sequence. |
CycleCountSequenceDetailsserials | The Serials resource manages details for the serials of cycle count sequences. |
FlexFndDffDescriptiveFlexfieldContexts | Descriptive Flexfield Contexts |
FlexFndPvsCharacterIdCharacterValues | FlexFndPvsCharacterIdCharacterValues |
FlexFndPvsCharacterValues | FlexFndPvsCharacterValues |
FlexFndPvsNumberIdCharacterValues | FlexFndPvsNumberIdCharacterValues |
InspectionStatuses | The Inspection Statuses resource manages the inspection status values. |
InTransitReceiptLots | The In-transit Receipt Lots resource manages the lot numbers for items while receiving shipment lines are in transit. |
InTransitReceiptSerials | The In-transit Receipt Serials resource manages the serial numbers that reference items when receiving shipment lines that are in transit. |
InTransitShipmentLines | The In-transit Shipment Lines resource manages the shipment lines that are in transit and that are available to receive. |
InTransitShipments | The In-transit Shipments resource manages the shipments that are in transit and that are available to receive. |
InventoryAccountAliases | The Inventory Account Aliases resource manages the aliases for the active inventory account. An account alias is an alternate name for the account number that the general ledger references. You can use it to more easily identify an account when performing a transaction. |
InventoryAttributeTransactionRequests | The Inventory Attribute Transaction Requests resource allows you to transfer material from one project to another. |
InventoryAttributeTransactionRequestslines | Value that identifies the inventory attribute transaction request line number. |
InventoryBusinessEventConfigurations | The Inventory Business Event Configurations resource manages how the various business events are configured for an inventory organization or at the site level. For each event type, you can configure the name of the business event that is to be raised. |
InventoryCompletedTransactions | The Completed Transactions in Inventory resource allows the warehouse manager to view inventory transactions that the application successfully processed. |
InventoryCompletedTransactionsdFFs | The Flexfields resource manages the descriptive flexfields for the transaction. |
InventoryCompletedTransactionslots | The Lots in Completed Transactions resource gets lot details for inventory transactions when the item is under lot control. The details include lot, parent lot, quantity, grade, expiration action, maturity date, and so on. |
InventoryCompletedTransactionslotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages the descriptive flexfields that modifies lot attributes. Use this resource only when the item is under lot control. |
InventoryCompletedTransactionslotslotSerials | The Serials in Lots in Completed Transactions resource gets serial details for inventory transactions when the item is under both lot and serial control. The details include serial number, and so on. |
InventoryCompletedTransactionslotslotSerialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages the descriptive flexfields that modifies serial attributes. Use this resource only when the item is under serial control. |
InventoryCompletedTransactionslotslotSerialsserialStandardDFFs | The Flexfields for Serials resource manages the descriptive flexfields that modifies serials. Use this resource only when the item is under serial control. |
InventoryCompletedTransactionslotslotStandardDFFs | The Flexfields for Lots resource manages the descriptive flexfields that modifies lots. Use this resource only when the item is under lot control. |
InventoryCompletedTransactionsprojectCostDFFs | The Flexfields for Project Costing resource manages the descriptive flexfields that modify the project costing attributes. |
InventoryCompletedTransactionsserials | The Serials in Completed Transactions resource gets serial details for inventory transactions when the item is under serial control. The details include serial number, and so on. |
InventoryCompletedTransactionsserialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages the descriptive flexfields that modifies serial attributes. Use this resource only when the item is under serial control. |
InventoryCompletedTransactionsserialsserialStandardDFFs | The Flexfields for Serials resource manages the descriptive flexfields that modifies serials. Use this resource only when the item is under serial control. |
InventoryConsumptionAdvices | The Inventory Consumption Advices resource gets the existing consumption advice details for a supplier, or a legal entity. |
InventoryConsumptionAdvicesconsumptionAdviceLines | The Consumption Advice Lines resource gets the line level details like item, organization, and purchase order details for a consumption advice. |
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots | The Consumption Advice Lots resource gets the lot-level details like lot number and transaction quantity for items in the consumption advice line. |
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials | The Consumption Advice Lots And Serials resource gets the lot-serial details for items in the consumption advice line. |
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceSerials | The Consumption Advice Serials resource gets the serial numbers for items in the consumption advice line. |
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions | The Consumption Advice Transactions resource gets the transaction details like transaction quantity and transaction type at the line level. |
InventoryCountTasks | The Inventory Count Tasks resource manages the count tasks. Oracle Supply Chain for Healthcare Cloud publishes the quantity details for a recalled item to Oracle Inventory Management Cloud. The count quantity is entered by the counter. This resource is not currently used. The resource is associated with a feature that requires opt in. |
InventoryCountTaskscosts | The Costs resource manages the costs associated with the count task. |
InventoryCountTasksDFF | The Flexfields for Inventory Count Tasks resource manages the descriptive flexfields for the count task. |
InventoryCountTasksrecallLots | The Recall Lots gets the information about the lot details for each recall notice line. |
InventoryCountTasksrecallLotSerials | The Recall Lot Serials resource gets the information about the lot and serial details for each recall notice line. |
InventoryItemLots | The Inventory Item Lots resource manages lot numbers for items in an organization. |
InventoryItemLotslotAttributeDFF | The Flexfields for Lot Attributes resource manages the descriptive flexfield information for lot attributes. |
InventoryItemLotslotStandardDFF | The Flexfields for Lots resource manages the descriptive flexfield information for maintaining lot numbers. |
InventoryItemSerialNumbers | The Inventory Item Serial Numbers resource manages the current serial numbers for items in organizations. |
InventoryItemSerialNumbersinventoryAttributesDFF | The Flexfields for Inventory Attributes resource manages the descriptive flexfield information for inventory attributes associated with the serial numbers. This resource is associated with a feature that requires opt in. |
InventoryItemSerialNumbersserialAttributeDFF | The Flexfields for Serial Number Attributes resource manages the descriptive flexfield information for serial number attributes. |
InventoryItemSerialNumbersserialStandardDFF | The Flexfields for Serial Numbers resource manages the descriptive flexfield information for serial numbers. |
InventoryMovementRequests | The Inventory Movement Requests resource manages movement requests. A movement request is a transaction of the type Requisition, Replenishment, Pick Wave, and Shop Floor. |
InventoryMovementRequestsDFF | The Flexfields resource stores the descriptive flexfields associated with movement requests. |
InventoryMovementRequestslines | The Lines for Inventory Movement Requests resource manages lines for movement requests. |
InventoryMovementRequestslinesDFF | The Flexfields for Lines resource stores the descriptive flexfields associated with lines for movement requests. |
InventoryMovementRequestslinesinventoryStripingDFF | The Flexfields for Inventory Striping Attributes resource manages the details of the inventory striping attributes that the descriptive flexfield references associated with a movement request line. Inventory striping (inventory tracking) attributes are a set of named attributes (project and task) as well as user-configurable attributes, which when specified as part of the movement request line, are used to track the inventory on hand. Movement request lines are not supported for the country of origin attribute. |
InventoryMovementRequestslinesprojectDFF | The Flexfields for Projects resource stores the project flexfields associated with lines for movement requests. |
InventoryOnhandBalances | The Inventory On-Hand Balances resource gets the summary of the on-hand quantities at different levels, such as Organization, Subinventory, and Locator. |
InventoryOnhandBalancesinventoryTrackingAttributes | The Inventory Tracking Attributes resource gets the details of the primary on-hand quantity, consigned quantity for specific inventory project, inventory task, and country of origin. This resource is associated with a feature that requires opt in. |
InventoryOnhandBalanceslots | The Lots resource gets the lot numbers associated with an inventory balance record for a lot-controlled item. |
InventoryOnhandBalanceslotsinventoryTrackingAttributes | The Inventory Tracking Attributes for Lots resource gets the details of the primary on-hand quantity, consigned quantity for specific inventory project, inventory task, and country of origin. This resource is associated with a feature that requires opt in. |
InventoryOnhandBalanceslotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages the descriptive flexfields that modify lot attributes. This resource is used only when the item is under lot control. |
InventoryOnhandBalanceslotslotSerials | The Lot Serials resource gets the serial numbers associated with an inventory balance record for a lot-serial controlled item. |
InventoryOnhandBalanceslotslotSerialslotSerialAttributeDFFs | The Flexfields for Lot Serial Attributes resource manages the descriptive flexfields that modify lot serial attributes. This resource is used only when the item is under both lot and serial control. |
InventoryOnhandBalanceslotslotSerialslotSerialStandardDFFs | The Flexfields for Lot Serials resource manages the descriptive flexfields that modify lot serials. This resource is used only when the item is under both lot and serial control. |
InventoryOnhandBalanceslotslotStandardDFFs | The Flexfields for Lots resource manages the descriptive flexfields that modify lots. This resource is used only when the item is under lot control. |
InventoryOnhandBalancesserials | The Serials resource gets the serial numbers associated with an inventory balance record for a serial-controlled item. |
InventoryOnhandBalancesserialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages the descriptive flexfields that modify serial attributes. This resource is used only when the item is under serial control. |
InventoryOnhandBalancesserialsserialStandardDFFs | The Flexfields for Serials resource manages the descriptive flexfields that modify serials. This resource is used only when the item is under serial control. |
InventoryOwningPartySites | The Inventory Owning Party Sites resource manages details about the owning party site. |
InventoryReplenishRequests | The Replenish Inventory Requests resource manages the replenish request group. |
InventoryReplenishRequestsreplenishRequestLines | The Request Lines resource manages the replenish request lines. |
InventoryReplenishRequestsreplenishRequestLinesreplenishRequestLineDFFs | The Flexfields resource manages the descriptive flexfields for the replenish request. |
InventoryReservations | The Inventory Reservations resource manages reservation details for an item, such as inventory location details, supply document details, or demand document details in the primary and secondary units of measure. |
InventoryReservationsserials | The Serials resource manages serial numbers for reservations that reserve the on-hand supply. You can use it to create, read, update, or delete serials for a reservation. |
InventoryStagedReservations | The Inventory Staged Reservations resource enables applications to get, create, update, and delete an inventory reservation interface record in Oracle Fusion Cloud Inventory Management and process reservation interface records. |
InventoryStagedTransactions | The Inventory Staged Transactions resource manages the staged inventory transactions. |
InventoryStagedTransactionscosts | The Costs resource manages the costs associated with the inventory staged transaction. |
InventoryStagedTransactionsdFFs | The Flexfields for Inventory Staged Transactions resource manages the descriptive flexfields defined for the transaction. |
InventoryStagedTransactionslots | The Lots resource manages the lots of a staged inventory transaction. |
InventoryStagedTransactionslotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages the lot attributes descriptive flexfields for a lot controlled item. |
InventoryStagedTransactionslotslotSerials | The Lot Serials resource manages the serials for a lot of a staged inventory transaction when an item is both lot and serial controlled. |
InventoryStagedTransactionslotslotSerialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages the serial attributes descriptive flexfields for a serial controlled item. |
InventoryStagedTransactionslotslotSerialsserialStandardDFFs | The Flexfields for Serials resource manages the serial descriptive flexfields for a serial controlled item. |
InventoryStagedTransactionslotslotStandardDFFs | The Flexfields for Lots resource manages the lot descriptive flexfields for a lot controlled item. |
InventoryStagedTransactionsprojectCostingDFFs | The Project Cost Details resource manages the project cost elements associated with the inventory staged transaction. |
InventoryStagedTransactionsserials | The Serials resource manages the serials of a staged inventory transaction for a serial controlled item. |
InventoryStagedTransactionsserialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages the serial attributes descriptive flexfields for a serial controlled item. |
InventoryStagedTransactionsserialsserialStandardDFFs | The Flexfields for Serials resource manages the serial descriptive flexfields for a serial controlled item. |
InventoryStagedTransactionstrackingAttributesDFF | The Tracking Attributes resource manages the inventory tracking attribute associated with the inventory staged transaction. This resource is associated with a feature that requires opt in. |
InventoryTransactionAccounts | The Inventory Transaction Accounts resource manages the account numbers from the general ledger that costs the inventory transactions. |
InventoryTransactionReasons | The Inventory Transaction Reasons resource manages the inventory transaction reasons that are currently active. A transaction reason allows you to classify or explain the reason for a transaction. You can use them with different types of item transactions. |
InventoryTransactionTypes | The Inventory Transaction Types resource manages the inventory transaction types that are active. A transaction type is a combination of a transaction source type and a transaction action. You can use it to classify a transaction for reporting and querying purposes. |
InvoiceMatchingReceiptQuantityTransactions | The Invoice Matching Receipt Quantity Transactions resource retrieves matching quantities for accounts payable invoice lines based on single or multiple transaction IDs. |
IssueLots | The Issue Lots resource manages the lot numbers to use when performing an issue or subinventory transfer for an inventory organization, item, subinventory, locator, or lot combination. |
IssueSerials | The Issue Serials resource manages the serial numbers that are available and that you can use to perform an issue or subinventory transfer for an inventory organization, item, subinventory, locator, or lot combination. |
LinesToCorrect | The Lines to Correct resource manages the received lines that are available for correction. |
LinesToCorrectmanufacturerParts | The Manufacturer Parts resource manages the manufacturer parts associated with a receipt line. |
LinesToInspect | The Lines to Inspect resource manages the received lines that require inspection. |
LinesToInspectmanufacturerParts | The Manufacturer Parts resource manages the manufacturer parts associated with a receipt line. |
LinesToReturn | The Lines to Return resource manages the received lines that are available to return. |
LinesToReturnmanufacturerParts | The Manufacturer Parts resource manages the manufacturer parts associated with a receipt line. |
MaterialStatuses | The Material Statuses resource manages the material status and allows the user to use a list of values to set this status. |
OnhandQuantityDetails | The On-hand Quantity Details resource manages details about the on-hand quantity in the primary UOM or secondary UOM. You can query for various quantities, such as on-hand, receiving, inbound, reserved, or consigned. |
OnhandQuantityDetailsConsignedQuantityDetails | The Consigned Quantity Details resource uses information about the item and inventory location that you provide to get details about the consigned quantities in the primary UOM or secondary UOM. |
OnhandQuantityDetailsInboundQuantityDetails | The Inbound Quantity Details resource uses information about the item and inventory location that you provide to get details about the inbound quantities in the primary UOM or secondary UOM. |
OpenPickLines | The Open Pick Lines resource manages details about open picks, such as pick slip number, quantities, locator information, and inventory control details, such as lot numbers and serial numbers. |
OpenPickLinesDFFs | The Flexfields for Pick Lines resource manages descriptive flexfields for the pick slip line. |
OpenPickLinesinventoryAttributesDFFs | The Flexfields for Inventory Attributes resource manages descriptive flexfields for inventory attributes. This resource is associated with a feature that requires opt in. |
OpenPickLinesitemLots | The Lot Details resource manages lot details for the item picked. |
OpenPickLinesitemLotsitemLotSerials | The Serial Details for Lots resource manages details about the serial when the lot controls the picked item. Use this resource when the lot controls the item. |
OpenPickLinesitemLotsitemLotSerialslotSerialAttributeDFFs | The Flexfields for Serials That Control Items and Lots resource manages descriptive flexfields for serial attributes. Use it when a serial controls the item or the lot. |
OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs | The Flexfields for Serials That Control Lots resource manages descriptive flexfields for serials. Use it when a serial controls the lot. |
OpenPickLinesitemLotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages descriptive flexfields for the lot attribute. |
OpenPickLinesitemLotslotStandardDFFs | The Flexfields for Lots resource manages descriptive flexfields for the lot. |
OpenPickLinesitemSerials | The Serial Details resource manages details about the serial that controls the picked item. Use this resource when the serial controls the item. |
OpenPickLinesitemSerialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages descriptive flexfields for the serial attribute. Use it when a serial controls the item. |
OpenPickLinesitemSerialsserialStandardDFFs | The Flexfields for Serials resource manages descriptive flexfields for the serial. Use it when a serial controls the item. |
OpenPickLinesprojectCostDFFs | The Flexfields for Project Costs resource manages descriptive flexfields for project cost. |
PackingUnits | The Packing Units resource manages the operations on packing units. |
PackingUnitsattachments | The Attachments resource manages the attachments associated with the packing unit resource. |
PackingUnitscontents | The Contents resource manages the operations on packing unit contents. |
PackingUnitscontentsserials | The Serials resource manages the operations on serials. |
PackingUnitsnestedPackingUnits | The Nested Packing Units resources manages the operations on nested packing units. |
PackingUnitsnestedPackingUnitsattachments | The attachments resource is used to view, create, and update attachments. |
PackingUnitsnestedPackingUnitscontents | The Contents resource manages the operations on packing unit contents. |
PackingUnitsnestedPackingUnitscontentsserials | The Serials resource manages the operations on serials. |
PackingUnitsnestedPackingUnitsnestedPackingUnits | The Nested Packing Units resources manages the operations on nested packing units. |
PackingUnitsnestedPackingUnitsnotes | The note objects resource is used to view the note objects. |
PackingUnitsnestedPackingUnitspackingUnitDFFs | The Flexfields for Packing Units resource manages the descriptive flexfields for packing units. |
PackingUnitsnotes | The Notes resource gets comments, information, or instructions for packing units. |
PackingUnitspackingUnitDFFs | The Flexfields for Packing Units resource manages the descriptive flexfields for packing units. |
PhysicalInventories | The Physical Inventories resource manages operations on physical inventories. |
PhysicalInventoriesphysicalInventoryDFFs | The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories. |
PhysicalInventoriesphysicalInventorySubinventories | The Physical Inventory Subinventories resource manages operations on physical inventory subinventories. |
PhysicalInventoryAdjustments | The Physical Inventory Adjustments resource manages the physical inventory adjustments. |
PhysicalInventoryAdjustmentsinventoryAttributesDFF | The Flexfields for Tracking Attributes resource manages details of the descriptive flexfields that reference the physical inventory adjustment. |
PhysicalInventoryTags | The Physical Inventory Tags resource manages physical inventory tags. |
PhysicalInventoryTagsinventoryAttributesDFF | The Flexfields for Tracking Attributes resource manages details of the descriptive flexfields that reference the physical inventory tags. |
PhysicalInventoryTagsphysicalInventoryTagDFFs | The Flexfields for Physical Inventory Tags resource manages descriptive flexfields that store details about physical inventory tags. |
PickSlipDetails | The Pick Slips resource manages the transaction details about confirming the pick, such as pick slip information, quantities, locator information, and inventory control details, such as lot numbers and serial numbers. |
PickSlipDetailspickLines | The Pick Lines resource manages picking details that describe the line to confirm. |
PickSlipDetailspickLinesdffs | The Flexfields for Pick Slip Lines resource manages descriptive flexfields for the pick slip line. |
PickSlipDetailspickLinesinventoryAttributesDFF | The Flexfields for Inventory Attributes resource manages descriptive flexfields for inventory attributes. This resource is associated with a feature that requires opt in. |
PickSlipDetailspickLinesitemLots | The Lot Details resource manages lot details for the item picked. |
PickSlipDetailspickLinesitemLotsitemLotSerials | The Serial Details in the Lot resource manages details about the serial when the lot controls the picked item. Use this resource when the lot controls the item. |
PickSlipDetailspickLinesitemLotsitemLotSerialslotSerialAttributeDFFs | The Flexfields for Serials That Control Items and Lots resource manages descriptive flexfields for serial attributes. Use it when a serial controls the item or the lot. |
PickSlipDetailspickLinesitemLotsitemLotSerialslotSerialStandardDFFs | The Flexfields for Serials That Control Lots resource manages descriptive flexfields for serials. Use it when a serial controls the lot. |
PickSlipDetailspickLinesitemLotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages descriptive flexfields for the lot attribute. |
PickSlipDetailspickLinesitemLotslotStandardDFFs | The Flexfields for Lots resource manages descriptive flexfields for the lot. |
PickSlipDetailspickLinesitemSerials | The Serial Details resource manages details about the serial that controls the picked item. Use this resource when the serial controls the item. |
PickSlipDetailspickLinesitemSerialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages descriptive flexfields for the serial attribute. Use it when a serial controls the item. |
PickSlipDetailspickLinesitemSerialsserialStandardDFFs | The Flexfields for Serials resource manages descriptive flexfields for the serial. Use it when a serial controls the item. |
PickSlipDetailspickLinespjcDFFs | The Flexfields for Project Costs resource manages descriptive flexfields for project cost. |
PurchaseOrderLinesForReceiving | The Purchase Order Lines for Receiving resource manages the purchase orders lines that are available to receive. |
PurchaseOrderReceiptSerials | The Purchase Order Receipt Serials resource manages the serial numbers that are available to use for receipts. |
PurchaseOrderSchedulesForReceiving | The Purchase Order Schedules for Receiving resource manages the purchase order schedules that are available to receive. |
PurchaseOrdersForReceiving | The Purchase Orders for Receiving resource manages the purchase orders that are available to receive. |
ReceiptLots | The Receipt Lots resource manages the lot numbers that you can use with receipts. |
ReceivingCountriesOfOrigin | The Receiving Countries of Origin resource manages the countries. |
ReceivingParameters | The Receiving Parameters resource manages the receiving parameters for the organization. |
ReceivingReceiptTransactionRequests | The Requests for Receiving Transactions resource is used to communicate requests to inspect, put away, correct, and return received goods and services with Oracle Fusion applications and process these requests. These transactions are created after creating a receipt to move the material and for acknowledging services. If there are errors in processing, you can search for the error records. After the search, the source application can either make the necessary corrections and resubmit the request or delete the requests that have resulted in errors. |
ReceivingReceiptTransactionRequestsattachments | The Attachments resource manages attachments when creating a post receipt transaction. The attachments uploaded as part of this correspond to the entity name Receiving Transactions. |
ReceivingReceiptTransactionRequestsDFF | The Flexfields for Receipt Transactions resource manages the information associated with receipt transactions. |
ReceivingReceiptTransactionRequestsinventoryStripingDFF | The Flexfields for Inventory Striping Attributes resource manages the inventory striping attributes that the descriptive flexfield references associated with a transaction. Inventory striping (inventory tracking) attributes are a set of named attributes (project, task, and country of origin) as well as user-configurable attributes, which when specified as part of the receipt or receiving transaction, are used to track the inventory on hand. |
ReceivingReceiptTransactionRequestslotItemLots | The Lots for Lot Items resource manages the lot information for a transaction line whose item is lot controlled and not serial controlled. |
ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF | The Flexfields for Lot Attributes resource manages the details of the lot attributes and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF | The Flexfields for Lot Numbers resource manages lot numbers and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLots | The Lots for Lot and Serial Items resource manages the lot information for a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLotslotAttributesDFF | The Flexfields for Lot Attributes resource manages the details of the lot attributes and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLotslotNumbersDFF | The Flexfields for Lot Numbers resource manages lot numbers and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials | The Serials for Lot and Serial Items resource manages the serial number information associated with a specific lot for a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialAttributesDFF | The Flexfields for Serial Attributes resource manages the details of serial attributes and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF | The Flexfields for Serial Numbers resource manages the details of serial numbers and is associated to a transaction line whose item is serial controlled and not lot controlled. |
ReceivingReceiptTransactionRequestsprocessingErrors | The Processing Errors resource gets the details for each error that was encountered while processing a request for post receipt transactions. |
ReceivingReceiptTransactionRequestsserialItemSerials | The Serials for Serial Items resource manages the serial number information for a transaction line whose item is serial controlled and not lot controlled. |
ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF | The Flexfields for Serial Attributes resource manages the details of serial attributes and is associated to a transaction line whose item is both lot and serial controlled. |
ReceivingReceiptTransactionRequestsserialItemSerialsserialNumbersDFF | The Flexfields for Serial Numbers resource manages the details of serial numbers and is associated to a transaction line whose item is serial controlled and not lot controlled. |
ReceivingTransactionsHistory | The Receiving Transaction History resource provides information about receiving transactions history. |
ReceivingTransactionsHistoryinventoryStripingDFF | The Flexfields for Inventory Striping Attributes resource manages the inventory striping attributes that the descriptive flexfield references associated with a receiving transaction. Inventory striping (inventory tracking) attributes are a set of named attributes (project, task, and country of origin) as well as user-configurable attributes, which when specified as part of the receipt or receiving transaction, are used to track the inventory on hand. |
ReceivingTransactionsHistorylots | The Lots resource manages the lots associated to a receiving transaction. |
ReceivingTransactionsHistorylotslotAttributeDFFs | The Flexfields for Lot Attributes resource manages details about the lot attributes that the descriptive flexfield references. |
ReceivingTransactionsHistorylotslotSerials | The Serials for Lots resource manages the serials associated to a lot. |
ReceivingTransactionsHistorylotslotSerialslotSerialAttributeDFFs | The Flexfields for Lot Serial Attributes resource manages details about the lot serial attributes that the descriptive flexfield references. |
ReceivingTransactionsHistorylotslotSerialslotSerialStandardDFFs | The Flexfields for Lot Serials resource manages details about the lot serial that the descriptive flexfield references. |
ReceivingTransactionsHistorylotslotStandardDFFs | The Flexfields for Lots resource manages details about the lot that the descriptive flexfield references. |
ReceivingTransactionsHistoryserials | The Serials resource manages the serials associated to a receiving transaction. |
ReceivingTransactionsHistoryserialsserialAttributeDFFs | The Flexfields for Serial Attributes resource manages details about the serial attributes that the descriptive flexfield references. |
ReceivingTransactionsHistoryserialsserialStandardDFFs | The Flexfields for Serials resource manages details about the serial that the descriptive flexfield references. |
ReceivingTransactionsHistorytransactionDFFs | The Flexfields for Receiving Transactions resource manages details about the receiving transaction attributes that the descriptive flexfield references. |
ReturnLots | The Return Lots resource manages the lot numbers that are available for returning items. |
ReturnSerials | The Return Serials resource manages the serial numbers that are available and that you can use to return items. |
ReturnSerialsForLots | The Return Serials for Lots resource manages the serial numbers that are available and that you can use to return the items that a lot references. |
RmaLinesForReceiving | The RMA Lines for Receiving resource manages the lines of the return material authorization that are available for receiving. |
RmaReceiptSerials | The RMA Receipt Serials resource manages the serial numbers that are eligible to be received on a return material authorization. When the Enforce Serial Number receiving parameter is disabled, use this resource to know the eligible serial numbers that were shipped as part of the original sales order. |
RmaRestrictedLots | The RMA Restricted Lots resource manages the lot numbers that are available to receive a return material authorization. When the Enforce Lot Number receiving parameter is enabled, then use this resource to know the eligible lot numbers. The customer specifies these lots on the return material authorization. |
RmaRestrictedSerials | The RMA Restricted Serials resource manages the serial numbers that are available to receive a return material authorization. When the Enforce Serial Number receiving parameter is enabled, then use this resource to know the eligible serial numbers. The customer specifies these serial numbers on the return material authorization. |
RmasForReceiving | The RMAs for Receiving resource manages the return material authorizations that are available for receiving. |
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. |
Subinventories | The Subinventories resource manages operations on subinventories. |
SubinventoriesitemSubinventories | The Item Subinventories resource manages operations on item subinventories. |
SubinventoriesitemSubinventoriesitemSubinventoriesDFF | The Flexfields for Item Subinventories resource manages descriptive flexfields that contain details about item subinventories. |
SubinventoriessubinventoriesDFF | The Flexfields for Subinventories resource manages descriptive flexfields that contain details about subinventories. |
TransferOrderLinesForReceiving | The Transfer Order Lines for Receiving resource manages the transfer order lines that are available for receiving. |
TransferOrders | The Inventory Transfer Orders resource manages transfer orders. |
TransferOrdersForReceiving | The Transfer Orders for Receiving resource manages the transfer orders that are available for receiving. |
TransferOrderstransferOrderHeaderDFFs | The Flexfields for Transfer Order Headers resource stores details for order header attributes in the transfer order. |
TransferOrderstransferOrderLines | The Transfer Order Lines resource manages order lines in the transfer order. |
TransferOrderstransferOrderLinestransferOrderDistributions | The Transfer Order Distributions resource manages distributions for the transfer order. |
TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs | The Flexfields for Transfer Order Distributions resource stores details for distribution attributes in the transfer order. |
TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionProjectDFFs | The Flexfields for Transfer Order Projects resource stores details for project attributes in the transfer order. |
TransferOrderstransferOrderLinestransferOrderLineDFFs | The Flexfields for Transfer Order Lines resource stores details for order line attributes in the transfer order. |
UnitOfMeasureUsages | The Unit of Measure Usages resource manages details about the unit of measure usages for items at the organization level, subinventory level, or both levels. |