Purchasing & Inventory Tables

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
Hadi_apps
Posts: 15
Joined: Wed Jan 30, 2008 1:18 am
Location: Malaysia

Purchasing & Inventory Tables

Post 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...
salman_faridi1001
Posts: 3
Joined: Mon Oct 15, 2007 1:59 pm
Location: India

Post 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
Hadi_apps
Posts: 15
Joined: Wed Jan 30, 2008 1:18 am
Location: Malaysia

Post by Hadi_apps »

Hi,

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

Regards,

Hadi....
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests