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