Page 1 of 1

Purchasing & Inventory Tables

Posted: Wed Jan 30, 2008 6:17 am
by Hadi_apps
Hi,

Can any body help me what are the commonly used tables and columns
in Oracle Purchasing & Inventory can any sujjest any documents which helps me ?

Regards...

Posted: Wed Jan 30, 2008 12:00 pm
by salman_faridi1001
IMPORTANT TABLES IN PO:

po_requisition_headers, po_requisition_lines, po_vendors,

po_vendor_sites_all, po_vendor_contacts, po_headers_all,

po_lines_all, po_releases_all, po_line_locations_all, po_distributions_all,

rcv_shipment_headers, rcv_shipment_lines.

INVENTORY:

mtl_system_items, mtl_parameters, mtl_categories, mtl_category_sets,

mtl_item_categories, mtl_secondary_inventories,

mtl_item_sub_inventories, mt_item_locations, mtl_material_transactions,

mtl_material_transaction_temp, mtl_onhand_quantities,

hr_all_organization_units, hz_locations.


Hope this will help !

Thanks
Salman

Posted: Thu Jan 31, 2008 6:36 am
by Hadi_apps
Hi,

Thank you Salman for your kind reply !!!!!

Regards,

Hadi....