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...
Purchasing & Inventory Tables
-
- Posts: 3
- Joined: Mon Oct 15, 2007 1:59 pm
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 1 guest