APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 29: from mtl_onhand_quantities moq,

25: cpp.planning_parameters_id,
26: cpp.level_id,
27: sum(decode(csi.condition_type,'B',moq.transaction_quantity,null)),
28: sum(decode(csi.condition_type,'G',moq.transaction_quantity,null))
29: from mtl_onhand_quantities moq,
30: csp_sec_inventories csi,
31: csp_planning_parameters cpp
32: where csi.organization_id = moq.organization_id
33: and csi.secondary_inventory_name = moq.subinventory_code

Line 109: from mtl_onhand_quantities moq,

105: cpp.planning_parameters_id,
106: cpp.level_id,
107: sum(decode(csi.condition_type,'B',moq.transaction_quantity,null)),
108: sum(decode(csi.condition_type,'G',moq.transaction_quantity,null))
109: from mtl_onhand_quantities moq,
110: csp_sec_inventories csi,
111: csp_planning_parameters cpp
112: where csi.organization_id = moq.organization_id
113: and csi.secondary_inventory_name = moq.subinventory_code

Line 176: from mtl_onhand_quantities moq,

172: moq.organization_id,
173: cpp.planning_parameters_id,
174: cpp.level_id,
175: sum(moq.transaction_quantity)
176: from mtl_onhand_quantities moq,
177: csp_planning_parameters cpp
178: where moq.inventory_item_id > 0
179: and cpp.organization_id = moq.organization_id
180: and cpp.organization_type = 'W'

Line 230: from mtl_onhand_quantities moq,

226: moq.organization_id,
227: cpp.planning_parameters_id,
228: cpp.level_id,
229: sum(moq.transaction_quantity)
230: from mtl_onhand_quantities moq,
231: csp_planning_parameters cpp
232: where cpp.organization_id = moq.organization_id
233: and cpp.node_type = 'ORGANIZATION_WH'
234: and cpp.organization_type = 'W'

Line 287: from mtl_onhand_quantities moq,

283: cpp.planning_parameters_id,
284: cpp.level_id,
285: sum(moq.transaction_quantity),
286: sum(moq.transaction_quantity)*-1
287: from mtl_onhand_quantities moq,
288: csp_sec_inventories csi,
289: csp_planning_parameters cpp
290: where csi.organization_id = moq.organization_id
291: and csi.secondary_inventory_name = moq.subinventory_code

Line 352: from mtl_onhand_quantities moq,

348: cpp.planning_parameters_id,
349: cpp.level_id,
350: sum(moq.transaction_quantity),
351: sum(moq.transaction_quantity)*-1
352: from mtl_onhand_quantities moq,
353: csp_sec_inventories csi,
354: csp_planning_parameters cpp
355: where csi.organization_id = moq.organization_id
356: and csi.secondary_inventory_name = moq.subinventory_code