DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 963: FROM mtl_onhand_quantities_detail moqd

959: THEN
960:
961: SELECT SUM(moqd.transaction_quantity)
962: INTO l_moq_qty1
963: FROM mtl_onhand_quantities_detail moqd
964: WHERE moqd.organization_id = p_org_id
965: AND moqd.inventory_item_id = p_item_id
966: AND EXISTS (select 'x' from mtl_secondary_inventories msi
967: WHERE msi.organization_id = moqd.organization_id and

Line 1017: FROM mtl_onhand_quantities_detail moqd

1013: THEN
1014:
1015: SELECT SUM(moqd.transaction_quantity)
1016: INTO l_moq_qty1
1017: FROM mtl_onhand_quantities_detail moqd
1018: WHERE moqd.organization_id = p_org_id
1019: AND moqd.inventory_item_id = p_item_id
1020: --AND moqd.planning_tp_type = 2
1021: AND moqd.subinventory_code = p_subinv;