Oracle Fusion SCM Table Names
Oracle Fusion SCM Table Names
Oracle Fusion Supply Chain Management (SCM) is a comprehensive suite of applications designed to manage various aspects of supply chain operations. Some common table names associated with Oracle Fusion SCM:
- INV_ITEMS: This table stores information about inventory items, including their descriptions, units of measure, and other attributes.
- PO_HEADERS_ALL: This table contains header-level information for purchase orders, including details like the purchase order number, supplier information, and order status.
- PO_LINES_ALL: This table stores line-level information for purchase orders, including item details, quantities, and prices.
- PO_DISTRIBUTIONS_ALL: It holds distribution-level information for purchase orders, including accounting information related to the distribution of costs.
- PO_REQ_HEADERS_ALL: This table stores header-level information for purchase requisitions, including requisition numbers, requester details, and dates.
- PO_REQ_LINES_ALL: It contains line-level information for purchase requisitions, including the requested item, quantity, and related details.
- INV_TRANSACTIONS: This table records various inventory transactions, such as issues, receipts, and transfers, with details like transaction types, quantities, and locations.
- OM_ORDER_HEADERS_ALL: In the context of SCM, this table stores header-level information for sales orders, including order numbers, customer details, and order status.
- OM_ORDER_LINES_ALL: It contains line-level information for sales orders, including item details, quantities, and pricing information.
- OM_SHIPMENTS: This table tracks shipments related to sales orders, including shipment numbers, shipping methods, and delivery details.
- WIP_JOBS: If you are dealing with manufacturing in your SCM, this table stores information about work-in-process jobs, including job numbers, status, and associated items.
- CST_COST_TXN_DETAIL: This table is related to cost transactions in SCM and contains details about cost transactions, including cost types and amounts.