Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, August 4, 2011

PO Tables

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

3 comments:

Anonymous said...

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??

Unknown said...

thanks

Anonymous said...

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

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect