=========================================
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
Thursday, August 4, 2011
PO Tables
Important Table in Purchasing Module of Oracle apps
Subscribe to:
Post Comments (Atom)
3 comments:
I want to get item name(SEGMENT1 IN MTL_SYSTEM_ITEMS_B) for a Particular PO NUMBER(SEGMENT1 IN PO_HEADERS_ALL) how can i do it??
thanks
Item details not available in po_headers_all, you first get header_id by mentioning the po_ number(segment1) in po_headers_all, then find the inventory_item_id by mentioning the header_id in where condition from po_lines_all.
Post a Comment