Search Results po_line_locations_all
The PO_LINE_LOCATIONS_ALL
table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical entity within the Purchasing module, serving as the foundation for tracking shipment and delivery details associated with purchase order lines. This table stores information about scheduled shipments, quantities, pricing, and receiving details, ensuring accurate procurement execution. Below is a detailed analysis of its structure, key columns, relationships, and functional significance.
Table Overview
PO_LINE_LOCATIONS_ALL
is part of the PO
schema and acts as a child table to PO_LINES_ALL
. Each record represents a shipment schedule for a specific purchase order line, enabling organizations to manage multiple deliveries for a single line item. The table is multi-org enabled, as indicated by the _ALL
suffix, meaning it stores data across operating units while enforcing data security via ORG_ID
.
Key Columns and Descriptions
- LINE_LOCATION_ID: Primary key, uniquely identifying each shipment line.
- PO_LINE_ID: Foreign key linking to
PO_LINES_ALL
, associating the shipment with a specific PO line. - SHIPMENT_TYPE: Indicates whether the shipment is "Standard," "Blanket," or "Planned."
- QUANTITY: Ordered quantity for the shipment.
- QUANTITY_RECEIVED: Tracks received quantities against the shipment.
- QUANTITY_BILLED: Records invoiced quantities for matching with AP invoices.
- SHIP_TO_ORGANIZATION_ID: Identifies the inventory organization receiving the shipment.
- SHIP_TO_LOCATION_ID: Physical delivery location, tied to
HR_LOCATIONS_ALL
. - NEED_BY_DATE: Expected delivery date for the shipment.
- PROMISED_DATE: Vendor-committed delivery date.
- PRICE_OVERRIDE: Allows deviation from the unit price defined in
PO_LINES_ALL
. - TAXABLE_FLAG: Determines if the shipment is subject to tax.
- CLOSED_CODE: Status of the shipment (e.g., "OPEN," "CLOSED," "CANCELLED").
Functional Significance
The table plays a pivotal role in procurement workflows:
- Shipment Scheduling: Enables splitting a single PO line into multiple deliveries with distinct dates, quantities, or destinations.
- Receiving: Integrates with the
RCV_TRANSACTIONS
table to updateQUANTITY_RECEIVED
upon goods receipt. - Invoice Matching: Provides data for three-way matching (PO, receipt, invoice) in Accounts Payable.
- Reporting: Supports analytics on delivery performance, vendor compliance, and procurement cycle times.
Relationships with Other Tables
- PO_LINES_ALL: Parent table via
PO_LINE_ID
. - PO_HEADERS_ALL: Indirect relationship through
PO_LINES_ALL.PO_HEADER_ID
. - RCV_SHIPMENT_LINES: Ties shipment details to receiving transactions.
- AP_INVOICE_LINES: Links to invoiced quantities via
PO_DISTRIBUTIONS_ALL
.
Technical Considerations
In EBS 12.2.2, the table benefits from Online Patching (ADOP) compatibility, ensuring uninterrupted operations during patches. Indexes such as PO_LINE_LOCATIONS_N1
(PO_LINE_ID
) and PO_LINE_LOCATIONS_U1
(LINE_LOCATION_ID
) optimize query performance. Customizations often extend the table via descriptive flexfields (DFFs) to capture organization-specific attributes.
Conclusion
PO_LINE_LOCATIONS_ALL
is indispensable for granular procurement control, bridging purchase orders, logistics, and financial accountability. Its design reflects Oracle EBS's emphasis on flexibility, auditability, and integration across supply chain and financial modules. Understanding this table is essential for troubleshooting, custom reporting, and enhancing procurement automation.
-
Table: PO_LINE_LOCATIONS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
-
Table: PO_LINE_LOCATIONS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
-
APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.AHL_OSP_ORDERS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POS_WC_CREATE_UPDATE_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.AP_IAW_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.JMF_SHIKYU_ONT_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.RCV_ROI_PREPROCESSOR dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POA_SAVINGS_CON dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POS_ASN_CREATE_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POA_EDW_RCV_TXNS_F_C dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.AP_ISP_UTILITIES_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_LINE_LOCATIONS_DRAFT_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.ICX_POR_WF_UTIL_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.RCV_ACCRUALUTILITIES_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.RCV_DEFAULT_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.INV_DIAG_RCV_PO dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_COMPLEX_WORK_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.IGC_CC_PO_LINE_LOCS_ALL_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.RCV_HXT_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_COMMUNICATION_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POR_RCV_ORD_SV dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_LINE_LOCATIONS_PKG_S0 dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_INTERFACE_S dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_VAL_LINES dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PA_ADJUSTMENTS dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_COPYDOC_S1 dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_VAL_SHIPMENTS dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_AP_INVOICE_MATCH_GRP dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.POS_ASN_XML dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.RCV_TRANSACTIONS_SV dependencies on PO_LINE_LOCATIONS_ALL
12.1.1
-
APPS.ITG_X_UTILS dependencies on PO_LINE_LOCATIONS_ALL
12.1.1