Wednesday, December 3, 2008

Important Table in Purchasing Module of Oracle apps
=========================================

Purchase Order
Po_headers_all
Po_lines_all
Po_line_locations_all
Po_distributions_all

Buyers
Po_agents

Document and line types
Po_document_types_all_b
Po_line_types_b

Releases
Po_realeases_all

Requisitions
Po_requisition_headers_all
Po_requisition_lines_all
Po_req_distributions_all

Vendors
Po_vendors
Po_vendor_sites_all
Po_vendor_contacts

Receiving
Rcv_transactions

Others
Mtl_system_items_b
Mtl_categories_b

Links between Oracle Apps PO Tables
============================

Po_headers_all/Po_lines_all --> po_header_id/po_header_id
Po_headers_all/Po_vendor_sites_all --> vendor_site_id/vendor_site_id
Po_headers_all/Po_vendors --> vendor_id/vendor_id
Po_headers_all/Po_line_locations_all--> po_header_id/po_header_id

Po_lines_all/Po_line_locations_all --> po_line_id/po_line_id
Po_lines_all/mtl_system_items_b --> item_id /inventory_item_id ( get for master org)
Po_lines_all/Mtl_categories_b --> category_id/ category_id

Po_line_locations_all/Rcv_transactions -->line_location_id/po_line_location_id

Po_vendor_sites_all/Po_vendors --> vendor_id/ vendor_id
po_distributions_all/po_req_distributions_all --> req_distribution_id/distribution_id