Search Results po_headers_all
Here's a detailed description of the PO_HEADERS_ALL table in Oracle E-Business Suite (EBS):
Table Name: PO_HEADERS_ALL
Purpose:
- Stores header-level information for Purchase Orders (POs)
- Contains primary purchase order details across all operating units
Key Columns:
1. PO_HEADER_ID (Primary Key)
- Unique identifier for each purchase order
- System-generated sequential number
- Used to link with other related tables
2. SEGMENT1
- Purchase order number
- Visible PO number used for reference
- Typically follows organizational numbering scheme
3. PO_STATUS
- Current status of purchase order
- Examples:
- OPEN
- CLOSED
- CANCELLED
- IN PROCESS
4. AGENT_ID
- Buyer/Purchasing agent responsible for the PO
- Links to HR_EMPLOYEES or PER_PEOPLE_V
5. TYPE_LOOKUP_CODE
- Defines purchase order type
- Examples:
- STANDARD
- BLANKET
- CONTRACT
6. AUTHORIZATION_STATUS
- Approval status of purchase order
- Indicates workflow/approval progression
7. APPROVED_FLAG
- Indicates if PO has been formally approved
- 'Y' or 'N' value
8. ORG_ID
- Operating unit identifier
- Ensures multi-organization support
9. VENDOR_ID
- Links to supplier/vendor information
- References PO_VENDORS table
10. REVISION_NUM
- Track purchase order revisions
- Increments with modifications
Typical Use Cases:
- Purchase order tracking
- Procurement reporting
- Vendor management
- Financial reconciliation
Related Tables:
- PO_LINES_ALL
- PO_LINE_LOCATIONS_ALL
- PO_DISTRIBUTIONS_ALL
- AP_SUPPLIERS
Performance Considerations:
- Indexed on PO_HEADER_ID
- Partitioned in large implementations
- Critical for procurement processes
Recommended Best Practices:
- Regularly archive closed/historical POs
- Maintain proper access controls
- Implement robust approval workflows
Would you like me to elaborate on any specific aspect of this table?
-
Table: PO_HEADERS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
-
Table: PO_HEADERS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
-
Lookup Type: MRC_UPGRADE
12.1.1
product: PO - Purchasing , meaning: NODESCRIPTION47 ,
-
Lookup Type: MRC_UPGRADE
12.2.2
product: PO - Purchasing , meaning: NODESCRIPTION47 ,
-
View: PO_LINES_CHANGE_PRINT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_CHANGE_PRINT, object_name:PO_LINES_CHANGE_PRINT, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_LINES_CHANGE_PRINT ,
-
View: PO_LINES_CHANGE_PRINT
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_CHANGE_PRINT, object_name:PO_LINES_CHANGE_PRINT, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_LINES_CHANGE_PRINT ,
-
Table: PO_MASSCANCEL_INTERIM
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_MASSCANCEL_INTERIM, object_name:PO_MASSCANCEL_INTERIM, status:VALID, product: PO - Purchasing , description: MassCancel temporary table , implementation_dba_data: PO.PO_MASSCANCEL_INTERIM ,
-
Table: PO_MASSCANCEL_INTERIM
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_MASSCANCEL_INTERIM, object_name:PO_MASSCANCEL_INTERIM, status:VALID, product: PO - Purchasing , description: MassCancel temporary table , implementation_dba_data: PO.PO_MASSCANCEL_INTERIM ,
-
Table: PO_LINES_ARCHIVE_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ARCHIVE_ALL, object_name:PO_LINES_ARCHIVE_ALL, status:VALID, product: PO - Purchasing , description: Archived purchase order lines , implementation_dba_data: PO.PO_LINES_ARCHIVE_ALL ,
-
Table: PO_LINE_LOCATIONS_DRAFT_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_DRAFT_ALL, object_name:PO_LINE_LOCATIONS_DRAFT_ALL, status:VALID, product: PO - Purchasing , description: Draft table for PO_LINE_LOCATIONS_ALL , implementation_dba_data: PO.PO_LINE_LOCATIONS_DRAFT_ALL ,
-
Table: PO_LINES_ARCHIVE_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ARCHIVE_ALL, object_name:PO_LINES_ARCHIVE_ALL, status:VALID, product: PO - Purchasing , description: Archived purchase order lines , implementation_dba_data: PO.PO_LINES_ARCHIVE_ALL ,
-
Table: PO_LINE_LOCATIONS_ARCHIVE_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ARCHIVE_ALL, object_name:PO_LINE_LOCATIONS_ARCHIVE_ALL, status:VALID, product: PO - Purchasing , description: Archived purchase order shipments , implementation_dba_data: PO.PO_LINE_LOCATIONS_ARCHIVE_ALL ,
-
Table: PO_LINE_LOCATIONS_ARCHIVE_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ARCHIVE_ALL, object_name:PO_LINE_LOCATIONS_ARCHIVE_ALL, status:VALID, product: PO - Purchasing , description: Archived purchase order shipments , implementation_dba_data: PO.PO_LINE_LOCATIONS_ARCHIVE_ALL ,
-
View: PO_LINES_PRINT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_PRINT, object_name:PO_LINES_PRINT, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_LINES_PRINT ,
-
View: PO_LINES_PRINT
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_PRINT, object_name:PO_LINES_PRINT, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_LINES_PRINT ,
-
View: PO_SOURCE_VENDORS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_SOURCE_VENDORS_V, object_name:PO_SOURCE_VENDORS_V, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_SOURCE_VENDORS_V ,
-
View: PO_SOURCE_VENDORS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_SOURCE_VENDORS_V, object_name:PO_SOURCE_VENDORS_V, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.PO_SOURCE_VENDORS_V ,
-
View: POFV_QUOTATION_SHIPMENTS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_SHIPMENTS, object_name:POFV_QUOTATION_SHIPMENTS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_SHIPMENTS ,
-
View: POFV_QUOTATION_SHIPMENTS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_SHIPMENTS, object_name:POFV_QUOTATION_SHIPMENTS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_SHIPMENTS ,
-
View: POFV_STD_PO_LINES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_STD_PO_LINES, object_name:POFV_STD_PO_LINES, status:VALID, product: PO - Purchasing , description: Referenced Contract Number , implementation_dba_data: APPS.POFV_STD_PO_LINES ,
-
View: POFV_STD_PO_LINES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_STD_PO_LINES, object_name:POFV_STD_PO_LINES, status:VALID, product: PO - Purchasing , description: Referenced Contract Number , implementation_dba_data: APPS.POFV_STD_PO_LINES ,
-
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 ,
-
View: POFV_PO_LINES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_PO_LINES, object_name:POFV_PO_LINES, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POFV_PO_LINES ,
-
View: POFV_QUOTATION_LINES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_LINES, object_name:POFV_QUOTATION_LINES, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_LINES ,
-
View: PO_ECX_LINE_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_ECX_LINE_V, object_name:PO_ECX_LINE_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.PO_ECX_LINE_V ,
-
View: PO_ECX_LINE_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_ECX_LINE_V, object_name:PO_ECX_LINE_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.PO_ECX_LINE_V ,
-
View: POFV_PO_LINES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_PO_LINES, object_name:POFV_PO_LINES, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POFV_PO_LINES ,
-
View: POFV_QUOTATION_LINES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_LINES, object_name:POFV_QUOTATION_LINES, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_LINES ,
-
View: POFV_QUOTATION_PRICE_BREAKS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_PRICE_BREAKS, object_name:POFV_QUOTATION_PRICE_BREAKS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_PRICE_BREAKS ,
-
View: PO_TEMP_LABOR_RATES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_TEMP_LABOR_RATES_V, object_name:PO_TEMP_LABOR_RATES_V, status:VALID, product: PO - Purchasing , description: Retrieves rate information for Temp Labor lines and their price differentials on Standard POs. , implementation_dba_data: APPS.PO_TEMP_LABOR_RATES_V ,
-
View: POFV_QUOTATION_PRICE_BREAKS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATION_PRICE_BREAKS, object_name:POFV_QUOTATION_PRICE_BREAKS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATION_PRICE_BREAKS ,
-
View: PO_TEMP_LABOR_RATES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_TEMP_LABOR_RATES_V, object_name:PO_TEMP_LABOR_RATES_V, status:VALID, product: PO - Purchasing , description: Retrieves rate information for Temp Labor lines and their price differentials on Standard POs. , implementation_dba_data: APPS.PO_TEMP_LABOR_RATES_V ,
-
Table: PO_PURGE_PO_LIST
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PURGE_PO_LIST, object_name:PO_PURGE_PO_LIST, status:VALID, product: PO - Purchasing , description: Purchase order candidates for purging , implementation_dba_data: PO.PO_PURGE_PO_LIST ,
-
Table: PO_PURGE_PO_LIST
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PURGE_PO_LIST, object_name:PO_PURGE_PO_LIST, status:VALID, product: PO - Purchasing , description: Purchase order candidates for purging , implementation_dba_data: PO.PO_PURGE_PO_LIST ,
-
View: PO_EDA_CLM_DOC_NBR_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_EDA_CLM_DOC_NBR_V, object_name:PO_EDA_CLM_DOC_NBR_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.PO_EDA_CLM_DOC_NBR_V ,
-
Table: PO_NOTIFICATION_CONTROLS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATION_CONTROLS, object_name:PO_NOTIFICATION_CONTROLS, status:VALID, product: PO - Purchasing , description: Blanket agreement and planned purchase order notification controls , implementation_dba_data: PO.PO_NOTIFICATION_CONTROLS ,
-
Table: PO_NOTIFICATION_CONTROLS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATION_CONTROLS, object_name:PO_NOTIFICATION_CONTROLS, status:VALID, product: PO - Purchasing , description: Blanket agreement and planned purchase order notification controls , implementation_dba_data: PO.PO_NOTIFICATION_CONTROLS ,
-
Table: PO_ACCEPTANCES
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCEPTANCES, object_name:PO_ACCEPTANCES, status:VALID, product: PO - Purchasing , description: Purchase order acceptances , implementation_dba_data: PO.PO_ACCEPTANCES ,
-
Table: PO_ACCEPTANCES
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCEPTANCES, object_name:PO_ACCEPTANCES, status:VALID, product: PO - Purchasing , description: Purchase order acceptances , implementation_dba_data: PO.PO_ACCEPTANCES ,
-
Table: PO_NOTIFICATIONS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATIONS_ALL, object_name:PO_NOTIFICATIONS_ALL, status:VALID, product: PO - Purchasing , description: Notifications , implementation_dba_data: PO.PO_NOTIFICATIONS_ALL ,
-
Table: PO_NOTIFICATIONS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATIONS_ALL, object_name:PO_NOTIFICATIONS_ALL, status:VALID, product: PO - Purchasing , description: Notifications , implementation_dba_data: PO.PO_NOTIFICATIONS_ALL ,
-
Table: PO_HEADERS_GT1
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_GT1, object_name:PO_HEADERS_GT1, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_HEADERS_GT1 ,
-
Table: PO_HEADERS_GT
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_GT, object_name:PO_HEADERS_GT, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_HEADERS_GT ,
-
Table: PO_AUTOSOURCE_DOCUMENTS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_AUTOSOURCE_DOCUMENTS_ALL, object_name:PO_AUTOSOURCE_DOCUMENTS_ALL, status:VALID, product: PO - Purchasing , description: No longer used , implementation_dba_data: PO.PO_AUTOSOURCE_DOCUMENTS_ALL ,
-
View: PO_LINES_SUPPLIER_ITEMS_ALL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_LINES_SUPPLIER_ITEMS_ALL_V, object_name:PO_LINES_SUPPLIER_ITEMS_ALL_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY , implementation_dba_data: APPS.PO_LINES_SUPPLIER_ITEMS_ALL_V ,
-
Table: PO_AUTOSOURCE_DOCUMENTS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_AUTOSOURCE_DOCUMENTS_ALL, object_name:PO_AUTOSOURCE_DOCUMENTS_ALL, status:VALID, product: PO - Purchasing , description: No longer used , implementation_dba_data: PO.PO_AUTOSOURCE_DOCUMENTS_ALL ,
-
Table: PO_RFQ_VENDORS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_RFQ_VENDORS, object_name:PO_RFQ_VENDORS, status:VALID, product: PO - Purchasing , description: Suppliers on an RFQ , implementation_dba_data: PO.PO_RFQ_VENDORS ,
-
View: POFV_QUOTATIONS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATIONS, object_name:POFV_QUOTATIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATIONS ,
-
View: POFV_QUOTATIONS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_QUOTATIONS, object_name:POFV_QUOTATIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_QUOTATIONS ,