Purchase Order Tables in R12

TABLE NAME	TABLE DESCRIPTION
EDW_PO_VENDOR_HIERARCHIES	EDW PO Vendor Hierarchies
FND_FUNCTION_PARAMETER_MAP	The FND_FUNCTION_PARAMETER_MAP table contains seed data for notification viewer
FND_NOTIFICATIONS	This table is obsolete in release 11.
POA_BIS_SAVINGS	Purchase details and analysis based on contracts
POA_BIS_SAVINGS_EFC	archive for euro functional currency project
POA_BIS_SAVINGS_RPT	Temporary table for Purchasing Intelligence reports.
POA_BIS_SAVINGS_RPT_EFC	archive for euro functional currency project
POA_BIS_SUPPLIER_PERFORMANCE	Summary information to compare suppliers for an item
POA_BIS_SUPPLIER_PERFORMAN_EFC	archive for euro functional currency project
POA_CM_DISTRIBUTIONS
POA_CM_EVALUATION
POA_CM_EVAL_SCORES
PO_ACCEPTANCES	Purchase order acceptances
PO_ACCRUAL_ACCOUNTS_TEMP_ALL	Accrual accounts temporary table
PO_ACCRUAL_RECONCILE_TEMP_ALL	Accrual Reconciliation Report temporary table
PO_ACCRUAL_WRITE_OFFS_ALL	Accrual write-offs
PO_ACCRUAL_WRITE_OFFS_ALL_EFC	archive for euro functional currency project
PO_ACTION_HISTORY	Document approval and control action history table
PO_AGENTS	Buyers table
PO_APPROVAL_LIST_HEADERS	Purchasing document approval list
PO_APPROVAL_LIST_LINES	Purchasing doument lines approval list
PO_APPROVED_SUPPLIER_LIST	Approved supplier list
PO_ASL_ATTRIBUTES	Approved supplier list attributes
PO_ASL_DOCUMENTS	Approved supplier list documents
PO_ASL_STATUSES	Approved supplier list statuses
PO_ASL_STATUS_RULES	Approved supplier list status rules
PO_ATTRIBUTE_VALUES	Stores descriptor values for records that are searchable in iProcurement
PO_ATTRIBUTE_VALUES_DRAFT	Draft table for PO_ATTRIBUTE_VALUES
PO_ATTRIBUTE_VALUES_TLP	Stores translatable descriptor values for records that are searchable in iProcurement
PO_ATTRIBUTE_VALUES_TLP_DRAFT	Draft table for PO_ATTRIBUTE_VALUES_TLP
PO_ATTR_VALUES_ARCHIVE	Archive table for PO_ATTRIBUTE_VALUES
PO_ATTR_VALUES_INTERFACE	Interface table for PO_ATTRIBUTE_VALUES
PO_ATTR_VALUES_TLP_ARCHIVE	Archive table for PO_ATTRIBUTE_VALUES_TLP
PO_ATTR_VALUES_TLP_INTERFACE	Interface table form PO_ATTRIBUTE_VALUES_TLP
PO_ATT_TMP_RECORDS	No longer used
PO_AUTOSOURCE_DOCUMENTS_ALL	No longer used
PO_AUTOSOURCE_RULES	No longer used
PO_AUTOSOURCE_VENDORS	No longer used
PO_BC_DISTRIBUTIONS	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.
PO_CHANGE_ORDER_TOLERANCES_ALL	PO_CHANGE_ORDER_TOLERANCES_ALL  table stores the tolerances.
PO_CHANGE_REQUESTS	PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and Requisitions submitted by Suppliers or Requesters
PO_COMMODITIES_B	Commodities
PO_COMMODITIES_TL	A table holding translated names and descriptions for Commodities
PO_COMMODITY_CATEGORIES	List of Categories in Commodities
PO_COMMODITY_GRANTS	Roles granted to employees for Commodities
PO_CONTROL_FUNCTIONS	Control document type functions
PO_CONTROL_GROUPS_ALL	Document authorization groups
PO_CONTROL_RULES	Document authorization rules
PO_CONTROL_RULES_EFC	archive for euro functional currency project
PO_CWK_ASSOCIATIONS	This table stores the association of CWK with Purchase Orders
PO_DISTRIBUTIONS_ALL	Purchase order distributions
PO_DISTRIBUTIONS_ALL_EBS	archive for euro business support project - Not in Use
PO_DISTRIBUTIONS_ARCHIVE_ALL	Archived distributions
PO_DISTRIBUTIONS_DRAFT_ALL	Purchase order distributions draft
PO_DISTRIBUTIONS_GT	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.
PO_DISTRIBUTIONS_INTERFACE	Interface table for purchase order distributions
PO_DOCUMENT_TOTALS_GT
PO_DOCUMENT_TYPES_ALL_B	Document types
PO_DOCUMENT_TYPES_ALL_TL	Translated document types
PO_DOC_STYLE_HEADERS	PO_DOC_STYLE_HEADERS contains information about the document style you use in your business.
PO_DOC_STYLE_LINES_B	PO_DOC_STYLE_LINES_B contains document subtype level information in a document style.
PO_DOC_STYLE_LINES_TL	PO_DOC_STYLE_LINES_TL contains translatable information for a line in a document style.
PO_DOC_STYLE_VALUES	PO_DOC_STYLE_VALUES contains information for the values which are allowed based on a document style.
PO_DRAFTS	Control table for draft changes
PO_EMPLOYEE_HIERARCHIES_ALL	Employee and position hierarchies
PO_ENCUMBRANCE_GT	For Internal Use Only
PO_GA_ORG_ASSIGNMENTS	Global Agreements Org Assignments
PO_GA_ORG_ASSIGNMENTS_ARCHIVE	Archived Global Agreements Org Assignments
PO_GA_ORG_ASSIGN_DRAFT	Global Agreements Org Assignments
PO_HAZARD_CLASSES_B	Hazardous classes
PO_HAZARD_CLASSES_TL	Translated hazardous classes
PO_HEADERS_ALL	Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_HEADERS_ALL_EBS	archive for euro business support project
PO_HEADERS_ARCHIVE_ALL	Archived purchase orders
PO_HEADERS_DRAFT_ALL	Draft Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_HEADERS_GT	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.
PO_HEADERS_INTERFACE	Interface table for purchase order headers
PO_HISTORY_POS_ALL	Purged purchase orders
PO_HISTORY_RECEIPTS	Purged receipts
PO_HISTORY_REQUISITIONS_ALL	Purged requisitions
PO_HISTORY_VENDORS	Purged suppliers
PO_INTERFACE_ERRORS	Requisition import interface errors
PO_JOB_ASSOCIATIONS_B	Associates HR jobs with Purchasing categories.
PO_JOB_ASSOCIATIONS_TL	Provides descriptions for HR jobs in multiple languages.
PO_LINES_ALL	Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL_EBS	archive for euro business support project
PO_LINES_ARCHIVE_ALL	Archived purchase order lines
PO_LINES_DRAFT_ALL	Draft table for purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_INTERFACE	Interface table for purchase order lines
PO_LINE_LOCATIONS_ALL	Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL_EBS	archive for euro business support project
PO_LINE_LOCATIONS_ARCHIVE_ALL	Archived purchase order shipments
PO_LINE_LOCATIONS_DRAFT_ALL	Draft table for PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_GT	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.
PO_LINE_LOCATIONS_INTERFACE	Interface table for purchase order line locations
PO_LINE_TYPES_B	Line types
PO_LINE_TYPES_TL	Translated line types
PO_LOCATION_ASSOCIATIONS	Location associations to customers and customer sites
PO_LOCATION_ASSOCIATIONS_ALL	Location associations to customers and customer sites
PO_MASSCANCEL_INCLUDES_ALL	MassCancel rules
PO_MASSCANCEL_INTERIM	MassCancel temporary table
PO_MC_DISTRIBUTIONS	Multiple Reporting Currencies (MRC) sub-table of PO_DISTRIBUTIONS_ALL
PO_MC_HEADERS	MRC sub-table of PO_HEADERS
PO_NOTES	No longer used
PO_NOTE_ATTRIBUTES	Note attributes
PO_NOTE_REFERENCES	Document/notes references
PO_NOTIFICATIONS_ALL	Notifications
PO_NOTIFICATION_CONTROLS	Blanket agreement and planned purchase order notification controls
PO_NOTIFICATION_CTRL_DRAFT	Blanket agreement and planned purchase order notification controls draft table
PO_ONLINE_REPORT_TEXT	Online report errors
PO_POSITION_CONTROLS_ALL	Job/organization and position controls
PO_PRICE_DIFFERENTIALS	Price differentials for rate-based lines
PO_PRICE_DIFFERENTIALS_ARCHIVE	Price differentials for rate based lines
PO_PRICE_DIFF_DRAFT	Draft Table for price differentials for rate-based lines.
PO_PRICE_DIFF_INTERFACE	Price differentials for rate based lines
PO_PURGE_PO_LIST	Purchase order candidates for purging
PO_PURGE_RECEIPT_LIST	Receiving candidates list for purge process. Temporary table.
PO_PURGE_REQ_LIST	Requisition candidates for purging
PO_PURGE_VENDOR_LIST	Supplier candidates for purging
PO_QUALITY_CODES	Quality inspection codes
PO_QUOTATION_APPROVALS_ALL	Quotation approvals
PO_RCV_CHARGES	Table for Freight and Special Charge records
PO_RCV_CHARGE_ALLOCATIONS	Charge Allocations table
PO_RELATED_TEMPLATES	Not used in Release 11i
PO_RELEASES_ALL	Purchase order releases
PO_RELEASES_ALL_EBS	archive for euro business support project
PO_RELEASES_ARCHIVE_ALL	Archived releases
PO_REQEXPRESS_HEADERS_ALL	Template headers for express requisitions
PO_REQEXPRESS_LINES_ALL	Template lines for express requisitions
PO_REQUISITIONS_INTERFACE_ALL	Requisition Import interface table
PO_REQUISITIONS_INT_ALL_EFC	archive for euro functional currency project
PO_REQUISITION_HEADERS_ALL	Requisition headers
PO_REQUISITION_LINES_ALL	Requisition lines
PO_REQUISITION_LINES_ALL_EFC	archive for euro functional currency project
PO_REQUISITION_SUPPLIERS	This table holds the list of suppliers to which the contractor request is sent out
PO_REQ_DISTRIBUTIONS_ALL	Requisition distributions
PO_REQ_DISTRIBUTIONS_ALL_EFC	archive for euro functional currency project
PO_REQ_DIST_INTERFACE_ALL	Interface table for requisition distributions
PO_REQ_LINES_GT	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.
PO_RESCHEDULE_INTERFACE	Requisition reschedule interface table
PO_RETRIEVED_TIMECARDS	Retrieved Timecards
PO_RETROPRICE_GT	For Internal Use Only: PO_RETROPRICE_GT is used to write the results of the bulk selects in the procedure PO_RETROACTIVE_PRICING_PVT.MassUpdate_Releases. This is then used later to update the tables using bulk processing.
PO_RFQ_VENDORS	Suppliers on an RFQ
PO_RULE_EXPENSE_ACCOUNTS	Expense charge account rules.
PO_SUPPLIER_ITEM_CAPACITY	Supplier capacity information
PO_SUPPLIER_ITEM_TOLERANCE	Supplier capacity tolerance information
PO_SYSTEM_PARAMETERS_ALL	Purchasing options
PO_UNIQUE_IDENTIFIER_CONT_ALL	Purchase order document number control
PO_UN_NUMBERS_B	United Nations numbers
PO_UN_NUMBERS_TL	Translated United Nations numbers
PO_USAGES	Note usages
PO_USAGE_ATTRIBUTES	Note usage attributes
PO_VALIDATION_RESULTS_GT
PO_VENDORS	Suppliers
PO_VENDORS_EBS	archive for euro business support project
PO_VENDORS_OBS	Suppliers
PO_VENDOR_CONTACTS	Supplier contacts
PO_VENDOR_CONTACTS_OBS	Supplier contacts
PO_VENDOR_LIST_ENTRIES	RFQ supplier list entries
PO_VENDOR_LIST_HEADERS	RFQ supplier list headers
PO_VENDOR_SITES_ALL	Supplier sites
PO_VENDOR_SITES_ALL_EBS	archive for euro business support project
PO_VENDOR_SITES_OBS	Supplier sites
PO_WF_CANDIDATE_REQ_LINES_TEMP	Temporary table to store requisition lines that can be automatically created using workflow
PO_WF_DEBUG	This table is reserved for use by Oracle only
PO_WF_USER_TMP
RCV_ACCOUNTING_EVENTS	Receiving Accounting Events
RCV_ACCOUNTING_EVENT_TYPES	Receiving Accounting Event Types
RCV_CHARGES_INTERFACE	Interface table for charges
RCV_FTE_TRANSACTION_LINES	Receiving logistics transaction lines
RCV_GAPLESS_INVOICE_NUMBERS	Gapless Invoice Numbers for Self Billing Invoices
RCV_HEADERS_INTERFACE	RCV_HEADERS_INTERFACE is the interface table that stores receiving header information.
RCV_LOTS_INTERFACE	Receiving lots interface table
RCV_LOTS_SUPPLY	Receiving lots supply
RCV_LOT_TRANSACTIONS	Receiving lots transactions
RCV_MC_REC_SUB_LEDGER	MRC sub-table of RCV_RECEIVING_SUB_LEDGER
RCV_MC_SHIPMENT_HEADERS	MRC sub-table of RCV_SHIPMENT_HEADERS
RCV_MC_SHIPMENT_LINES	MRC sub-table of RCV_SHIPMENT_LINES
RCV_MC_SUB_LEDGER_DETAILS	MRC sub-table of RCV_SUB_LEDGER_DETAILS
RCV_MC_TRANSACTIONS	MRC sub-table of RCV_TRANSACTIONS
RCV_PARAMETERS	Organization-level receiving controls
RCV_RECEIVING_SUB_LEDGER	Receiving subledger
RCV_ROUTING_HEADERS	Receiving routing headers
RCV_ROUTING_HEADERS_OLD	Receiving routing headers
RCV_ROUTING_STEPS	Receiving routing steps
RCV_SERIALS_INTERFACE	Receiving serial interface table
RCV_SERIALS_SUPPLY	Receiving serial supply
RCV_SERIAL_TRANSACTIONS	Receiving serial transactions
RCV_SHIPMENT_HEADERS	Shipment and receipt header information
RCV_SHIPMENT_LINES	Receiving shipment line information
RCV_SHIPMENT_LINES_EFC	archive for euro functional currency project
RCV_STAGING_TABLE	Receiving transactions for subcontracted items
RCV_SUB_LEDGER_DETAILS	Detailed accounting lines for the receiving transaction
RCV_SUPPLY	Summary information about items in receiving/inspection
RCV_TRANSACTIONS	Receiving transactions
RCV_TRANSACTIONS_INTERFACE	Receiving transactions interface table
RCV_UPGRADE_STEPS	Temporary table for tracking a receiving upgrade from Release 9 to Release 10