Purchase order PO table details in Oracle Apps R12, PO_HEADERS_ALL table plays an important role in PO Purchasing module, all PO module tables are linked with PO header table which stores PO header related information.
List of Important Purchase Order (PO) Module tables in Oracle Apps R12
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
PO_VENDORS_ALL
PO_VENDOR_SITES_ALL
PO_RELEASES_ALL
PO_VENDOR_CONTACTS
PO_ACTION_HISTORY
PO Table Descriptions in Oracle Apps R12
PO_HEADERS_ALL: This table stores PO header level data, each record in this table represents a purchase order, which is an order for goods or services from a single supplier. Each purchase order may have multiple lines (PO_LINES)
PO_LINES_ALL: This table stores PO line level data, each record in this table represents a purchase order line, which identifies the items and unit price for the goods ordered on a purchase order. Each purchase order line may have multiple shipments (PO_LINE_LOCATIONS).
PO_LINE_LOCATIONS_ALL: This table stores PO line location level data, each record in this table represents a purchase order shipment, which identifies the quantity of an item shipped to a buyer location by the supplier. Each purchase order shipment may have multiple accounting distributions (PO_DISTRIBUTIONS).
PO_DISTRIBUTIONS_ALL: This table stores PO distributions level data, each record in this table/view represents a purchase order distribution, which identifies the account charged for the items on a purchase order shipment.
PO_VENDORS_ALL: This table stores PO general information about the suppliers.
PO_VENDOR_SITES_ALL: This table stores PO related supplier site level information, each row includes the site address, supplier reference, purchasing, payment, bank, and general information.
PO_RELEASES_ALL: This table stores planned and blanket Purchase Order releases, each row includes the date, buyer, release status, and release number, each release must have at least one purchase order shipment.
PO_VENDOR_CONTACTS: This table stores supplier contact details which are related to purchase order, each record includes contact name and supplier site.