Monday, 21 January 2013

P2P TABLES


Usual Oracle Applications PO Tables

PO_HEADERS_ALL:
Purchase Order information with Supplier, Site and status

PO_LINES_ALL: PO Lines with Item Information and quantity

PO_LINE_LOCATIONS_ALL: PO Information on Shipments Destination

PO_DISTRIBUTIONS_ALL: PO Distribution where the accounts are

PO_LINE_LOCATIONS_ARCHIVE_ALL: table updated for history on Shipment/Destination Location Information

PO_LINE_TYPES_B: PO Types used in the PO_LINES_ALL

PO_LINES_TYPES_TL: PO Line Types used in MLS

PO_RELEASES_ALL:
Stores revision number for the PO

PO_HEADERS_ARCHIVE_ALL: table updated for the history on the status and PO Header changes, Lines, Location and PO Accounts Distribution

PO_LINES_ARCHIVE_ALL: table updated for the history on the lines

PO_DISTRIBUTIONS_ARCHIVE_ALL:
table updated for the history on the account distribution

PO_AGENTS_ALL_V: Buyer

PO_VENDORS: Supplier Table - R - ap_suppliers

PO_VENDOR_SITES: Supplier Sites

PO_VENDOR_CONTACTS: Supplier Contacts

PO_HAZARD_CLASSES: contains code and description for hazardous items which gets automatically printed into purchase order, RFQ and Receipt Travelers

PO_REQUISITION_LINES_ALL: Requisition Lines

PO_REQUISITION_HEADERS_ALL:
Requisition Headers

PO_REQ_DISTRIBUTIONS_ALL: Distribution Lines of Requisition where accounts are

PO_APPROVED_SUPPLIER_LIST: Supplier List for Auto-Sourcing

PO_ASL_DOCUMENTS: Advanced Shipment Documents

PO_APPROVAL_LIST_HEADERS:
PO Approval Path

PO_APPROVAL_LIST_LINES: PO Approval Path

No comments:

Post a Comment