eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 30: from mtl_onhand_quantities moq,

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

Line 110: from mtl_onhand_quantities moq,

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

Line 177: from mtl_onhand_quantities moq,

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

Line 231: from mtl_onhand_quantities moq,

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

Line 288: from mtl_onhand_quantities moq,

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

Line 353: from mtl_onhand_quantities moq,

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