Tuesday, August 23, 2016

Onhand quantity checking and sub inventory

SELECT msi.segment1, msi.organization_id, SUM (moq.transaction_quantity),moq.inventory_item_id FROM mtl_system_items_b msi, mtl_onhand_quantities moq WHERE moq.organization_id(+) = msi.organization_id AND moq.inventory_item_id(+) = msi.inventory_item_id and moq.ORGANIZATION_ID = 4 and msi.SEGMENT1 = 'B600312RML-77' GROUP BY msi.segment1, msi.organization_id,moq.inventory_item_id;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...