Search Results po_lines_all
The PO_LINES_ALL
table is a fundamental entity within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as a core component of the Purchasing module. It stores detailed information about purchase order (PO) lines, which represent individual items or services requested in a purchase order. This table is integral to procurement processes, enabling organizations to track, manage, and report on purchasing transactions efficiently. Below is a detailed breakdown of its structure, functionality, and significance in Oracle EBS.
Table Structure and Key Columns
ThePO_LINES_ALL
table contains numerous columns that capture critical attributes of PO lines. Key columns include:
- PO_LINE_ID: A unique identifier for each PO line, serving as the primary key.
- PO_HEADER_ID: References the parent PO header in the
PO_HEADERS_ALL
table, linking lines to their respective orders. - LINE_NUM: The sequential number of the line within the PO, ensuring proper ordering.
- ITEM_ID: Links to the
MTL_SYSTEM_ITEMS_B
table, identifying the item being purchased. - ITEM_DESCRIPTION: A textual description of the item or service, useful when no item ID is specified.
- UNIT_PRICE: The per-unit price of the item or service.
- QUANTITY: The number of units ordered.
- QUANTITY_RECEIVED: Tracks the amount received against the line.
- QUANTITY_BILLED: Records the quantity invoiced by suppliers.
- UOM_CODE: The unit of measure (e.g., each, kilogram) for the item.
- NEED_BY_DATE: The requested delivery date for the line.
- CLOSED_CODE: Indicates the line's status (e.g., open, closed, canceled).
- ORG_ID: The operating unit associated with the line, supporting multi-org functionality.
Functional Role in Procurement
ThePO_LINES_ALL
table plays a pivotal role in procurement workflows:
- Order Creation: When a PO is created, each line item is stored in this table, capturing details such as item, quantity, and price.
- Receiving: The table interacts with the
RCV_TRANSACTIONS
table to updateQUANTITY_RECEIVED
as goods are received. - Invoicing: During invoice matching (via the
AP_INVOICE_LINES
table),QUANTITY_BILLED
is updated to reflect invoiced quantities. - Reporting and Analytics: Data from this table feeds into procurement reports, spend analysis, and supplier performance metrics.
Integration with Other Modules
The table integrates seamlessly with other Oracle EBS modules:- Inventory: Links to
MTL_SYSTEM_ITEMS_B
for item details and stock levels. - Accounts Payable: Ties to
AP_INVOICE_LINES
for invoice validation and payment processing. - General Ledger: Supports accrual accounting by providing line-level details for journal entries.
Multi-Org and Security
The_ALL
suffix denotes that the table stores data for all operating units, with ORG_ID
enforcing data segregation. Access is controlled via Oracle's Multi-Org Access Control (MOAC) and responsibility-based security.
Customizations and Extensions
Organizations often extend this table with custom columns (e.g., project codes, contract references) or leverage it for custom workflows, such as approval hierarchies or spend compliance checks.Conclusion
ThePO_LINES_ALL
table is a cornerstone of Oracle EBS Purchasing, enabling granular tracking of procurement activities. Its robust structure, integration capabilities, and support for multi-org operations make it indispensable for organizations leveraging Oracle EBS 12.1.1 or 12.2.2. Understanding its design and functionality is essential for effective procurement management and system customization.
-
Table: PO_LINES_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
-
Table: PO_LINES_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
-
APPS.PO_CHARGES_GRP dependencies on PO_LINES_ALL
12.1.1
-
APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.AP_LINES_UPGRADE_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_AP_MERGE_GRP dependencies on PO_LINES_ALL
12.1.1
-
APPS.POA_DBI_SAVINGS_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.CST_ACCRUAL_LOAD dependencies on PO_LINES_ALL
12.1.1
-
APPS.JAI_RCV_TAX_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_LINE_TYPES_SV dependencies on PO_LINES_ALL
12.1.1
-
APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.INL_CHARGE_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.POGOT_S dependencies on PO_LINES_ALL
12.1.1
-
APPS.CSE_IPV_FA_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.PER_QH_FIND_QUERY dependencies on PO_LINES_ALL
12.1.1
-
APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LINES_ALL
12.1.1
-
APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.POA_EDW_PO_DIST_F_SIZE dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.INV_LABEL_PVT4 dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_PERSON dependencies on PO_LINES_ALL
12.1.1
-
APPS.ZX_PO_REC_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.INV_MGD_MVT_PO_MDTR dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_FTE_INTEGRATION_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.RCV_RMA_TRANSACTIONS dependencies on PO_LINES_ALL
12.1.1
-
APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on PO_LINES_ALL
12.1.1
-
APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINES_ALL
12.1.1
-
APPS.INV_DIAG_RCV_IPROC dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_RCO_VALIDATION_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.OE_MARGIN_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.AHL_OSP_RCV_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.RCV_INSPECTION_GRP dependencies on PO_LINES_ALL
12.1.1
-
APPS.CSTPPIPV dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.GMS_AWARD_DIST_ENG dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_RESCHEDULE_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.AP_RCT_AMT_MATCH_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.CST_EAMCOST_PUB dependencies on PO_LINES_ALL
12.1.1
-
APPS.EAM_DIRECT_ITEMS_VALIDATE_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_COMMUNICATION_PVT dependencies on PO_LINES_ALL
12.1.1
-
APPS.MRP_SOURCING_API_PK dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_OM_INTEGRATION_GRP dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_HEADERS_SV2 dependencies on PO_LINES_ALL
12.1.1
-
APPS.GML_MOBILE_RECEIPT dependencies on PO_LINES_ALL
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on PO_LINES_ALL
12.1.1
-
APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINES_ALL
12.1.1
-
APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_LINES_ALL
12.1.1