PO Tables (258)

PO - Purchasing — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
CHV_AUTHORIZATIONS_GT 39
EDW_PO_VENDOR_HIERARCHIES 4 EDW PO Vendor Hierarchies
FND_FUNCTION_PARAMETER_MAP 5 The FND_FUNCTION_PARAMETER_MAP table contains seed data for notification viewer
FND_NOTIFICATIONS 59 This table is obsolete in release 11.
PON_AUCTION_HEADERS_EXT_B 105
PON_AUCTION_HEADERS_EXT_TL 57 Stores the UDA Attributes of the negotiations header level details.
PON_AUCTION_ITEM_PRICES_EXT_B 106 Stores the UDA attibutes of negotiation item details including price
PON_AUCTION_ITEM_PRICES_EXT_TL 58 Stores the UDA attibutes of negotiation item details including price
PON_BID_HEADERS_EXT_B 105 Stores the UDA attributes of header level data for a response to a negotiation
PON_BID_HEADERS_EXT_TL 57 Stores the UDA attributes of header level data for a response to a negotiation
PON_BID_ITEM_PRICES_EXT_B 106 Stores the UDA data of the information regarding the responses submitted by a supplier on a negotiation.
PON_BID_ITEM_PRICES_EXT_TL 58 Stores the UDA data of the information regarding the responses submitted by a supplier on a negotiation.
PO_ACCEPTANCES 45 Purchase order acceptances
PO_ACCRUAL_ACCOUNTS_TEMP_ALL 3 Accrual accounts temporary table
PO_ACCRUAL_WRITE_OFFS_ALL 56 Accrual write-offs
PO_ACCRUAL_WRITE_OFFS_ALL_EFC 7 archive for euro functional currency project
PO_ACTION_HISTORY 22 Document approval and control action history table
PO_AGENTS 33 Buyers table
PO_APPROVAL_LIST_HEADERS 32 Purchasing document approval list
PO_APPROVAL_LIST_LINES 36 Purchasing doument lines approval list
PO_APPROVED_SUPPLIER_LIST 40 Approved supplier list
PO_APPROVED_SUPPLIER_LIST_GT 48
PO_ASL_API_ERRORS 4
PO_ASL_ATTRIBUTES 64 Approved supplier list attributes
PO_ASL_ATTRIBUTES_GT 75
PO_ASL_DOCUMENTS 32 Approved supplier list documents
PO_ASL_DOCUMENTS_GT 34
PO_ASL_STATUSES 31 Approved supplier list statuses
PO_ASL_STATUS_RULES 12 Approved supplier list status rules
PO_ATTRIBUTE_VALUES 327 Stores descriptor values for records that are searchable in iProcurement
PO_ATTRIBUTE_VALUES_DRAFT 331 Draft table for PO_ATTRIBUTE_VALUES
PO_ATTRIBUTE_VALUES_TLP 174 Stores translatable descriptor values for records that are searchable in iProcurement
PO_ATTRIBUTE_VALUES_TLP_DRAFT 178 Draft table for PO_ATTRIBUTE_VALUES_TLP
PO_ATTR_VALUES_ARCHIVE 328 Archive table for PO_ATTRIBUTE_VALUES
PO_ATTR_VALUES_INTERFACE 330 Interface table for PO_ATTRIBUTE_VALUES
PO_ATTR_VALUES_TLP_ARCHIVE 175 Archive table for PO_ATTRIBUTE_VALUES_TLP
PO_ATTR_VALUES_TLP_INTERFACE 177 Interface table form PO_ATTRIBUTE_VALUES_TLP
PO_ATT_TMP_RECORDS 5 No longer used
PO_AUTOCREATE_UDA_RULES 18 Autocreate UDA rules
PO_AUTOSOURCE_DOCUMENTS_ALL 33 No longer used
PO_AUTOSOURCE_RULES 31 No longer used
PO_AUTOSOURCE_VENDORS 30 No longer used
PO_BC_DISTRIBUTIONS 70 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 Transact
PO_CHANGE_ORDER_TOLERANCES_ALL 14 PO_CHANGE_ORDER_TOLERANCES_ALL table stores the tolerances.
PO_CHANGE_REQUESTS 79 PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and Requisitions submitted by Suppliers or Requesters
PO_CLM_AGENCIES 33 Stores the information FPDS - NG Agencies
PO_CLM_ASSGNMT_ACTION_HISTORY 14 Stores the information regarding PALT Assignment action history
PO_CLM_ASSGNMT_MILESTONE_DTLS 13 Stores the information of the Milestones in PALT assignment
PO_CLM_ASSIGNMENTS 15 Assignments Table
PO_CLM_CARS 51 Stores the information for FPDS-NG Cars
PO_CLM_CAR_LOGS 13 Stores the information for FPDS-NG Car Logs
PO_CLM_MILESTONES 10 CLM Milestones table
PO_CLM_MILESTONE_TEMPLATES 9 Milestone Templates Table.
PO_CLM_TO_FPDS_AWARD_TYP_MAP 9 Mapping between FPDS-NG Award Types and PO Award Types
PO_COMMODITIES_B 8 Commodities
PO_COMMODITIES_TL 10 A table holding translated names and descriptions for Commodities
PO_COMMODITY_CATEGORIES 7 List of Categories in Commodities
PO_COMMODITY_GRANTS 8 Roles granted to employees for Commodities
PO_CONTROL_FUNCTIONS 34 Control document type functions
PO_CONTROL_GROUPS_ALL 30 Document authorization groups
PO_CONTROL_RULES 92 Document authorization rules
PO_CONTROL_RULES_EFC 5 archive for euro functional currency project
PO_CWK_ASSOCIATIONS 13 This table stores the association of CWK with Purchase Orders
PO_DIFF_CONFIG 20
PO_DISTRIBUTIONS_ALL 128 Purchase order distributions
PO_DISTRIBUTIONS_ALL_EBS 24 archive for euro business support project - Not in Use
PO_DISTRIBUTIONS_ALL_EXT_B 106 Stores UDA data of the Purchase order distributions
PO_DISTRIBUTIONS_ALL_EXT_TL 58 Stores UDA data of the Purchase order distributions
PO_DISTRIBUTIONS_ARCHIVE_ALL 127 Archived distributions
PO_DISTRIBUTIONS_DRAFT_ALL 132 Purchase order distributions draft
PO_DISTRIBUTIONS_GT1 115 For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data
PO_DISTRIBUTIONS_INTERFACE 162 Interface table for purchase order distributions
PO_DOCUMENT_TOTALS_GT 22
PO_DOCUMENT_TYPES_ALL_B 53 Document types
PO_DOCUMENT_TYPES_ALL_TL 12 Translated document types
PO_DOC_STYLE_HEADERS 40 PO_DOC_STYLE_HEADERS contains information about the document style you use in your business.
PO_DOC_STYLE_LINES_B 9 PO_DOC_STYLE_LINES_B contains document subtype level information in a document style.
PO_DOC_STYLE_LINES_TL 11 PO_DOC_STYLE_LINES_TL contains translatable information for a line in a document style.
PO_DOC_STYLE_VALUES 10 PO_DOC_STYLE_VALUES contains information for the values which are allowed based on a document style.
PO_DRAFTS 32 Control table for draft changes
PO_EDA_ENTITY_DIFFERENCES 25
PO_EDA_MAPPING 4
PO_EDA_UDA_ATTR_VALUES 5
PO_EMPLOYEE_HIERARCHIES_ALL 17 Employee and position hierarchies
PO_ENCUMBRANCE_GT1 123
PO_ENTITY_DIFFERENCES 25
PO_ENTITY_GT 8
PO_ENTITY_LOCKS 13 Table to store locks for Modification entities
PO_ENTITY_ROLLUP_GT 23
PO_GA_ORG_ASSIGNMENTS 11 Global Agreements Org Assignments
PO_GA_ORG_ASSIGNMENTS_ARCHIVE 13 Archived Global Agreements Org Assignments
PO_GA_ORG_ASSIGN_DRAFT 15 Global Agreements Org Assignments
PO_HAZARD_CLASSES_B 27 Hazardous classes
PO_HAZARD_CLASSES_TL 10 Translated hazardous classes
PO_HEADERS_ALL 202 Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_HEADERS_ALL_EBS 16 archive for euro business support project
PO_HEADERS_ALL_EXT_B 107
PO_HEADERS_ALL_EXT_B_ARCHIVE 108 Archived UDA data of the Document headers (for purchase orders, purchase agreements)
PO_HEADERS_ALL_EXT_TL 58 Stores the UDA data of the Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_HEADERS_ALL_EXT_TL_ARCHIVE 60 Translated archive UDA data of the Document headers (for purchase orders, purchase agreements)
PO_HEADERS_ARCHIVE_ALL 201 Archived purchase orders
PO_HEADERS_DRAFT_ALL 202 Draft Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_HEADERS_GT1 167 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
PO_HEADERS_INTERFACE 172 Interface table for purchase order headers
PO_HISTORY_POS_ALL 16 Purged purchase orders
PO_HISTORY_RECEIPTS 11 Purged receipts
PO_HISTORY_REQUISITIONS_ALL 12 Purged requisitions
PO_HISTORY_VENDORS 9 Purged suppliers
PO_INTERFACE_ERRORS 38 Requisition import interface errors
PO_JOB_ASSOCIATIONS_B 8 Associates HR jobs with Purchasing categories.
PO_JOB_ASSOCIATIONS_TL 10 Provides descriptions for HR jobs in multiple languages.
PO_LINES_ALL 186 Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL_EBS 18 archive for euro business support project
PO_LINES_ALL_EXT_B 106 Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL_EXT_B_ARCHIVE 108 Archived UDA data of Purchase document lines (for purchase orders, purchase agreements)
PO_LINES_ALL_EXT_TL 58 Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL_EXT_TL_ARCHIVE 60 Translated Archive UDA data of Purchase document lines (for purchase orders, purchase agreements)
PO_LINES_ARCHIVE_ALL 186 Archived purchase order lines
PO_LINES_DRAFT_ALL 198 Draft table for purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_GT1 168 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 A
PO_LINES_INTERFACE 256 Interface table for purchase order lines
PO_LINE_LOCATIONS_ALL 177 Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL_EBS 21 archive for euro business support project
PO_LINE_LOCATIONS_ALL_EXT_B 106 Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL_EXT_TL 58 Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ARCHIVE_ALL 177 Archived purchase order shipments
PO_LINE_LOCATIONS_DRAFT_ALL 182 Draft table for PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_GT1 152 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
PO_LINE_LOCATIONS_INTERFACE 97 Interface table for purchase order line locations
PO_LINE_LOC_ALL_EXT_B_ARCHIVE 108 Archived UDA data of Document shipment schedules (for purchase orders, purchase agreements)
PO_LINE_LOC_ALL_EXT_TL_ARCHIVE 60 Translated Archive UDA data of Document shipment schedules (for purchase orders, purchase agreements)
PO_LINE_TYPES_B 38 Line types
PO_LINE_TYPES_TL 11 Translated line types
PO_LOCATION_ASSOCIATIONS_ALL 34 Location associations to customers and customer sites
PO_MASSCANCEL_INCLUDES_ALL 73 MassCancel rules
PO_MASSCANCEL_INTERIM 23 MassCancel temporary table
PO_MC_DISTRIBUTIONS 6 Multiple Reporting Currencies (MRC) sub-table of PO_DISTRIBUTIONS_ALL
PO_MC_HEADERS 5 MRC sub-table of PO_HEADERS
PO_MULTI_MOD_CHANGES 19 This table stores the Supplier related changes pertaining to a Multiple Modifications Request.
PO_MULTI_MOD_CLAUSE_CHANGES 11
PO_MULTI_MOD_DOCS 11 This table stores the documents that are selected for a Multiple Modifications Request.
PO_MULTI_MOD_REQUESTS 41 This table serves as the control table for Multiple Modifications and Supplier Change Requests.
PO_MULTI_MOD_VAL_RESULTS 32 This table stores the Supplier exceptions generated for a Multiple Modifications Request.
PO_NOTE_ATTRIBUTES 11 Note attributes
PO_NOTE_REFERENCES 34 Document/notes references
PO_NOTIFICATIONS_ALL 18 Notifications
PO_NOTIFICATION_CONTROLS 32 Blanket agreement and planned purchase order notification controls
PO_NOTIFICATION_CTRL_DRAFT 36 Blanket agreement and planned purchase order notification controls draft table
PO_OKC_VARS_GT 6
PO_ONLINE_REPORT_TEXT 26 Online report errors
PO_POSITION_CONTROLS_ALL 33 Job/organization and position controls
PO_PRICE_ADJUSTMENTS 102 Stores information regarding the Price Adjustments
PO_PRICE_ADJUSTMENTS_ARCHIVE 103 Stores history regarding the Price Adjustments
PO_PRICE_ADJUSTMENTS_DRAFT 106 Draft table for the Price Adjustments.
PO_PRICE_ADJ_ATTRIBS 18 Data for the Price Adjustments Attributes.
PO_PRICE_ADJ_ATTRIBS_ARCHIVE 19 Archive data for Price Adjustments Attributes.
PO_PRICE_ADJ_ATTRIBS_DRAFT 19 Draft table for Price Adjustments Attributes.
PO_PRICE_DIFFERENTIALS 14 Price differentials for rate-based lines
PO_PRICE_DIFFERENTIALS_ARCHIVE 16 Price differentials for rate based lines
PO_PRICE_DIFF_DRAFT 18 Draft Table for price differentials for rate-based lines.
PO_PRICE_DIFF_INTERFACE 20 Price differentials for rate based lines
PO_PRINT_FORM_FORMATS 15 Federal Printing Formats
PO_PROTESTS 43
PO_PURGE_PO_LIST 7 Purchase order candidates for purging
PO_PURGE_REQ_LIST 7 Requisition candidates for purging
PO_PURGE_VENDOR_LIST 7 Supplier candidates for purging
PO_QUALITY_CODES 13 Quality inspection codes
PO_QUOTATION_APPROVALS_ALL 34 Quotation approvals
PO_RCV_CHARGES 24 Table for Freight and Special Charge records
PO_RCV_CHARGE_ALLOCATIONS 15 Charge Allocations table
PO_RELATED_TEMPLATES 8 Not used in Release 11i
PO_RELEASES_ALL 97 Purchase order releases
PO_RELEASES_ALL_EBS 9 archive for euro business support project
PO_RELEASES_ARCHIVE_ALL 94 Archived releases
PO_REQEXPRESS_HEADERS_ALL 33 Template headers for express requisitions
PO_REQEXPRESS_LINES_ALL 75 Template lines for express requisitions
PO_REQUISITIONS_INTERFACE_ALL 281 Requisition Import interface table
PO_REQUISITIONS_INT_ALL_EFC 7 archive for euro functional currency project
PO_REQUISITION_HEADERS_ALL 94 Requisition headers
PO_REQUISITION_LINES_ALL 222 Requisition lines
PO_REQUISITION_LINES_ALL_EFC 7 archive for euro functional currency project
PO_REQUISITION_SUPPLIERS 33 This table holds the list of suppliers to which the contractor request is sent out
PO_REQ_DISTRIBUTIONS_ALL 86 Requisition distributions
PO_REQ_DISTRIBUTIONS_ALL_EFC 4 archive for euro functional currency project
PO_REQ_DISTRIBUTIONS_EXT_B 105 Stores the UDA data for the Requisition Distributions.
PO_REQ_DISTRIBUTIONS_EXT_TL 57 Stores the UDA data for the Requisition Distributions.
PO_REQ_DIST_INTERFACE_ALL 100 Interface table for requisition distributions
PO_REQ_HEADERS_EXT_B 105
PO_REQ_HEADERS_EXT_TL 57 Stores the UDA data for the Requisition headers
PO_REQ_LINES_EXT_B 105 Stores the UDA data for the Requisition Lines
PO_REQ_LINES_EXT_TL 57 Stores the UDA data for the Requisition Lines
PO_REQ_LINES_GT 140 For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It is used for internal processing of d
PO_RESCHEDULE_INTERFACE 19 Requisition reschedule interface table
PO_RETRIEVED_TIMECARDS 36 Retrieved Timecards
PO_RETROPRICE_GT 7 For Internal Use Only: PO_RETROPRICE_GT is used to write the results of the bulk selects in the procedure PO_RETROACTIVE_PRICING_PVT.MassUpd
PO_RFQ_VENDORS 33 Suppliers on an RFQ
PO_RULE_EXPENSE_ACCOUNTS 11 Expense charge account rules.
PO_SUPPLIER_ITEM_CAPACITY 31 Supplier capacity information
PO_SUPPLIER_ITEM_CAPACITY_GT 30
PO_SUPPLIER_ITEM_TOLERANCE 29 Supplier capacity tolerance information
PO_SUPPLIER_ITEM_TOLERANCE_GT 28
PO_SYSTEM_PARAMETERS_ALL 133 Purchasing options
PO_UDA_AG_TEMPLATES 18 Stores the information regarding the Attribute Templates
PO_UDA_AG_TEMPLATES_TL 11 Stores the information regarding the Attribute Templates
PO_UDA_AG_TEMPLATE_USAGES 32 Stores information regarding the Attribute Group Template Usages
PO_UDA_DUMMY_ALL 1 Dummy Table for UDA Seeding purposes
PO_UDA_DUMMY_ALL_EXT_B 104 Stores the UDA data of the Dummy Table for UDA Seeding purposes
PO_UDA_DUMMY_ALL_EXT_TL 50 Stores the UDA data of the Dummy Table for UDA Seeding purposes
PO_UDA_INTERFACE 40 Interface table for importing UDA Data
PO_UDA_MAPPINGS 18 Holds the data of the Mapping Between Dummy and Real Attribute Group types
PO_UNIQUE_IDENTIFIER_CONT_ALL 12 Purchase order document number control
PO_UN_NUMBERS_B 28 United Nations numbers
PO_UN_NUMBERS_TL 10 Translated United Nations numbers
PO_USAGES 12 Note usages
PO_USAGE_ATTRIBUTES 11 Note usage attributes
PO_USER_PREFERENCES 34 Table to Store User preferences
PO_USER_WARRANTS 14 This table stores warrant information
PO_VALIDATION_RESULTS_GT 22
PO_VENDORS_EBS 11 archive for euro business support project
PO_VENDORS_OBS 173 Suppliers
PO_VENDOR_CONTACTS_OBS 46 Supplier contacts
PO_VENDOR_LIST_ENTRIES 30 RFQ supplier list entries
PO_VENDOR_LIST_HEADERS 30 RFQ supplier list headers
PO_VENDOR_SITES_ALL_EBS 12 archive for euro business support project
PO_VENDOR_SITES_OBS 146 Supplier sites
PO_WARRANT_LINES 10 This table stores warrant lines information.
PO_WF_CANDIDATE_REQ_LINES_TEMP 20 Temporary table to store requisition lines that can be automatically created using workflow
PO_WF_DEBUG 14 This table is reserved for use by Oracle only
PO_WF_USER_TMP 1
RCV_ACCOUNTING_EVENTS 62 Receiving Accounting Events
RCV_ACCOUNTING_EVENT_TYPES 13 Receiving Accounting Event Types
RCV_CHARGES_INTERFACE 19 Interface table for charges
RCV_FTE_TRANSACTION_LINES 11 Receiving logistics transaction lines
RCV_GAPLESS_INVOICE_NUMBERS 5 Gapless Invoice Numbers for Self Billing Invoices
RCV_HEADERS_INTERFACE 100 RCV_HEADERS_INTERFACE is the interface table that stores receiving header information.
RCV_LOTS_INTERFACE 22 Receiving lots interface table
RCV_LOTS_SUPPLY 20 Receiving lots supply
RCV_LOT_TRANSACTIONS 24 Receiving lots transactions
RCV_MC_REC_SUB_LEDGER 79 MRC sub-table of RCV_RECEIVING_SUB_LEDGER
RCV_MC_SHIPMENT_HEADERS 5 MRC sub-table of RCV_SHIPMENT_HEADERS
RCV_MC_SUB_LEDGER_DETAILS 75 MRC sub-table of RCV_SUB_LEDGER_DETAILS
RCV_MC_TRANSACTIONS 5 MRC sub-table of RCV_TRANSACTIONS
RCV_PARAMETERS 61 Organization-level receiving controls
RCV_RECEIVING_SUB_LEDGER 77 Receiving subledger
RCV_ROUTING_HEADERS_OLD 28 Receiving routing headers
RCV_ROUTING_STEPS 31 Receiving routing steps
RCV_SERIALS_INTERFACE 19 Receiving serial interface table
RCV_SERIALS_SUPPLY 15 Receiving serial supply
RCV_SERIAL_TRANSACTIONS 20 Receiving serial transactions
RCV_SHIPMENT_HEADERS 91 Shipment and receipt header information
RCV_SHIPMENT_LINES 112 Receiving shipment line information
RCV_SHIPMENT_LINES_EFC 5 archive for euro functional currency project
RCV_STAGING_TABLE 11 Receiving transactions for subcontracted items
RCV_SUB_LEDGER_DETAILS 75 Detailed accounting lines for the receiving transaction
RCV_SUPPLY 43 Summary information about items in receiving/inspection
RCV_TRANSACTIONS 134 Receiving transactions
RCV_TRANSACTIONS_INTERFACE 249 Receiving transactions interface table
RCV_UPGRADE_STEPS 4 Temporary table for tracking a receiving upgrade from Release 9 to Release 10