Search Results build tool for visual studio

The PO_DISTRIBUTIONS_GT table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as a global temporary table (GTT) designed to temporarily store purchase order (PO) distribution data during complex procurement transactions. As a GTT, it holds session-specific data that is automatically purged at the end of the transaction or session, ensuring transactional integrity and performance optimization. This table is integral to Oracle's Purchasing and Payables modules, particularly for processing multi-distribution POs, requisitions, and invoice matching workflows.

Key Attributes of PO_DISTRIBUTIONS_GT:
1. Session-Specific Storage: Data persists only for the duration of a user session or transaction, eliminating the need for manual cleanup.
2. Structural Alignment: Mirrors the schema of the permanent PO_DISTRIBUTIONS_ALL table, containing columns like PO_DISTRIBUTION_ID, PO_HEADER_ID, QUANTITY_ORDERED, and DESTINATION_TYPE_CODE.
3. Performance Optimization: Reduces contention on permanent tables during bulk operations by staging distribution lines before final commit.
4. Multi-Org Support: Includes ORG_ID for multi-organization access control (MOAC) compliance.

Primary Use Cases:
1. PO Creation/Modification: Temporarily holds distribution lines during PO entry or updates before validation and submission to PO_DISTRIBUTIONS_ALL.
2. Requisition Conversion: Stores distributions when converting requisitions to POs via AutoCreate.
3. Invoice Matching: Facilitates 2-way/3-way matching by caching matched distributions during invoice validation.
4. Mass Processing: Enables bulk operations like blanket agreement releases or PO approvals without locking permanent tables.

Technical Implementation:
The table is instantiated per session using Oracle's GTT mechanism (ON COMMIT PRESERVE ROWS or DELETE ROWS). Key columns include:
- INTERFACE_LINE_ID: Links to source data in interface tables
- DESTINATION_ORGANIZATION_ID: For inventory destinations
- CHARGE_ACCOUNT_ID: GL account mapping
- RATE/AMOUNT: Financial terms
Indexes on PO_HEADER_ID and PO_LINE_ID optimize join operations with other PO tables.

Integration Points:
1. Purchasing Module: Interacts with PO_HEADERS_GT, PO_LINES_GT, and permanent PO tables.
2. Payables: Shares data with AP_INVOICE_DISTRIBUTIONS during invoice matching.
3. Inventory: Coordinates with MTL_SYSTEM_ITEMS for item validations.
4. General Ledger: Validates accounts against GL_CODE_COMBINATIONS.

Customization Considerations:
While Oracle discourages direct modifications to GTTs, extensions can be implemented via:
1. Custom PL/SQL APIs that populate/read the GTT
2. Concurrent programs leveraging the table for custom reporting
3. Triggers on related permanent tables to synchronize critical data
All customizations must account for the temporary nature of the data and session isolation properties.

In summary, PO_DISTRIBUTIONS_GT provides a transactional workspace for PO distribution processing in Oracle EBS, combining the scalability of temporary storage with the structural rigor of permanent tables. Its design reflects Oracle's architectural philosophy of separating transient operational data from persistent business records while maintaining referential integrity across procurement workflows.

Lookup Type: PRINT TOOL 12.1.1
product: PO - Purchasing , meaning: Options for what report tool to use , description: Options for what report tool to use ,
Lookup Type: PRINT TOOL 12.2.2
product: PO - Purchasing , meaning: Options for what report tool to use , description: Options for what report tool to use ,
Lookup Type: PO_CLM_CONTRACT_CATEGORY 12.2.2
product: PO - Purchasing , meaning: Contract Categories ,
Lookup Type: PO_USER_DOCUMENT_STATUS 12.2.2
product: PO - Purchasing , meaning: User Document Status ,
Lookup Type: MOD_LINE_USER_DOCUMENT_STATUS 12.2.2
product: PO - Purchasing , meaning: Modification Line User Document Status ,
Lookup Type: CHANGE_ORDER_TOLERANCES_DUP 12.1.1
product: PO - Purchasing , meaning: Change Order Tolerances (Extension) , description: Change Order Tolerances (for duplicate meanings) ,
Lookup Type: CHANGE_ORDER_TOLERANCES_DUP 12.2.2
product: PO - Purchasing , meaning: Change Order Tolerances (Extension) , description: Change Order Tolerances (for duplicate meanings) ,
Lookup Type: CONTROL ACTIONS 12.1.1
product: PO - Purchasing , meaning: Valid Control Actions , description: Valid Control Actions ,
Lookup Type: CONTROL ACTIONS 12.2.2
product: PO - Purchasing , meaning: Valid Control Actions , description: Valid Control Actions ,
Lookup Type: CHANGE_ORDER_TOLERANCES 12.1.1
product: PO - Purchasing , meaning: Tolerances , description: Tolerances ,
Lookup Type: PAR_NOTIFY_ACTION_LKP 12.2.2
product: PO - Purchasing , meaning: Lookup for Action Requested in Notify Action for PAR ,
Lookup Type: CHANGE_ORDER_TOLERANCES 12.2.2
product: PO - Purchasing , meaning: Tolerances , description: Tolerances ,
Lookup Type: POA BIS REPORT OPTION 12.2.2
product: PO - Purchasing , meaning: PO Report Options , description: PO Report Options ,
Lookup Type: DOCUMENT STATE 12.1.1
product: PO - Purchasing , meaning: Valid Document States , description: Valid Document States ,
Lookup Type: DOCUMENT STATE 12.2.2
product: PO - Purchasing , meaning: Valid Document States , description: Valid Document States ,
Concurrent Program: POXWARMG 12.1.1
execution_filename: POXWARMG , product: PO - Purchasing , user_name: Send Notifications for Purchasing Documents , description: Send Notifications for Purchasing Documents , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Lookup Type: POA BIS REPORT OPTION 12.1.1
product: PO - Purchasing , meaning: PO Report Options , description: PO Report Options ,
Concurrent Program: POCLMGENXMLCP 12.2.2
execution_filename: PoCLMGenXMLCP , product: PO - Purchasing , user_name: Generate XML for CLM Documents , description: Used to generate XML for CLM Documents , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: APPROVER ACTIONS 12.2.2
product: PO - Purchasing , meaning: Actions taken during the approval process. , description: Actions taken during the approval process. ,
Concurrent Program: POXWARMG 12.2.2
execution_filename: POXWARMG , product: PO - Purchasing , user_name: Send Notifications for Purchasing Documents , description: Send Notifications for Purchasing Documents , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Lookup Type: DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: Meaning N/A for : DOCUMENT TYPE , description: Document Type ,
Lookup Type: PO_MULTI_MOD_ACTIONS 12.2.2
product: PO - Purchasing , meaning: PO Multiple Modification Actions , description: PO Multiple Modification Actions ,
Concurrent Program: PO_HIST_FEED 12.1.1
execution_filename: POR_History_Feed_Pkg.Main , product: PO - Purchasing , user_name: Purchase Order History Feed for P-card Reconciliation , description: Purchase Order History Feed for reconciling P-card payments , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: AUTO TRANSACT CODE 12.1.1
product: PO - Purchasing , meaning: Auto Transact code for Receiving transactions , description: Auto Transact code for Receiving transactions ,
Lookup Type: AUTO TRANSACT CODE 12.2.2
product: PO - Purchasing , meaning: Auto Transact code for Receiving transactions , description: Auto Transact code for Receiving transactions ,
Lookup Type: DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: Meaning N/A for : DOCUMENT TYPE , description: Document Type ,
Concurrent Program: PO_HIST_FEED 12.2.2
execution_filename: POR_History_Feed_Pkg.Main , product: PO - Purchasing , user_name: Purchase Order History Feed for P-card Reconciliation , description: Purchase Order History Feed for reconciling P-card payments , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: PO_DISTRIBUTIONS_GT 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DISTRIBUTIONS_GT, object_name:PO_DISTRIBUTIONS_GT, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_DISTRIBUTIONS_GT ,
Table: PO_LINE_LOCATIONS_GT 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_GT, object_name:PO_LINE_LOCATIONS_GT, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_LINE_LOCATIONS_GT ,
Table: PO_DISTRIBUTIONS_GT 12.2.2
product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: Not implemented in this database ,
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_LINE_LOCATIONS_GT 12.2.2
product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: Not implemented in this database ,
Lookup Type: FUNDS CONTROL PERIOD 12.1.1
product: PO - Purchasing , meaning: Period for which to perform funds control , description: Period for which to perform funds control ,
Lookup Type: FUNDS CONTROL PERIOD 12.2.2
product: PO - Purchasing , meaning: Period for which to perform funds control , description: Period for which to perform funds control ,
Table: PO_REQ_LINES_GT 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_LINES_GT, object_name:PO_REQ_LINES_GT, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_REQ_LINES_GT ,
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_LINES_GT1 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_GT1, object_name:PO_LINES_GT1, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_LINES_GT1 ,
Table: PO_LINE_LOCATIONS_GT1 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_GT1, object_name:PO_LINE_LOCATIONS_GT1, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_LINE_LOCATIONS_GT1 ,
Table: PO_DISTRIBUTIONS_GT1 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DISTRIBUTIONS_GT1, object_name:PO_DISTRIBUTIONS_GT1, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_DISTRIBUTIONS_GT1 ,
Lookup Type: PO_DEL_ORD_STD_FORM 12.2.2
product: PO - Purchasing , meaning: Order off IDV Standard Forms ,
Lookup Type: RFQ PRINT CHOICE 12.2.2
product: PO - Purchasing , meaning: Choice for printing RFQS , description: Choice for printing RFQS ,
Lookup Type: RFQ PRINT CHOICE 12.1.1
product: PO - Purchasing , meaning: Choice for printing RFQS , description: Choice for printing RFQS ,
Concurrent Program: GMLRCPT 12.1.1
execution_filename: Gml_Reprocess_Rcpts.Update_Records , product: PO - Purchasing , user_name: GMLRCPT , description: OPM Update Receipts for Reprocessing , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: PO_LINES_GT 12.2.2
product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: Not implemented in this database ,
Table: PO_HEADERS_GT 12.2.2
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: Not implemented in this database ,
Table: PO_BC_DISTRIBUTIONS 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_BC_DISTRIBUTIONS, object_name:PO_BC_DISTRIBUTIONS, status:VALID, product: PO - Purchasing , description: It contains values for most of the sources used as Transaction Objects in XLA for PO. This is one of the main tables on which those Transaction objects derive values for core PO sources. , implementation_dba_data: PO.PO_BC_DISTRIBUTIONS ,
Lookup Type: RESERVE PO NUM 12.2.2
product: PO - Purchasing , meaning: Reserve PO Number , description: Reserve PO Number ,
Concurrent Program: GMLRCPT 12.2.2
execution_filename: Gml_Reprocess_Rcpts.Update_Records , product: PO - Purchasing , user_name: GMLRCPT , description: OPM Update Receipts for Reprocessing , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: APPROVER ACTIONS 12.1.1
product: PO - Purchasing , meaning: Actions taken during the approval process. , description: Actions taken during the approval process. ,
Lookup Type: RESERVE PO NUM 12.1.1
product: PO - Purchasing , meaning: Reserve PO Number , description: Reserve PO Number ,