APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 68: from mtl_material_transactions_temp mmtt,

64: cssdt.planning_parameters_id,
65: cssdt.level_id,
66: sum(decode(cssdt.onhand_good,null,mmtt.primary_quantity,0)),
67: sum(decode(cssdt.onhand_bad,null,mmtt.primary_quantity,0))
68: from mtl_material_transactions_temp mmtt,
69: csp_sup_dem_sub_temp cssdt,
70: csp_planning_parameters cpp
71: where mmtt.inventory_item_id = cssdt.inventory_item_id
72: and mmtt.organization_id = cssdt.organization_id

Line 142: from mtl_material_transactions_temp mmtt,

138: cpp.planning_parameters_id,
139: cpp.level_id,
140: sum(decode(csi.condition_type,'B',mmtt.primary_quantity,0)),
141: sum(decode(csi.condition_type,'G',mmtt.primary_quantity,0))
142: from mtl_material_transactions_temp mmtt,
143: csp_sec_inventories csi,
144: csp_planning_parameters cpp
145: where mmtt.organization_id = csi.organization_id
146: and mmtt.subinventory_code = csi.secondary_inventory_name

Line 201: from mtl_material_transactions_temp mmtt,

197: mmtt.organization_id,
198: cpp.planning_parameters_id,
199: cpp.level_id,
200: sum(nvl(mmtt.primary_quantity,0))
201: from mtl_material_transactions_temp mmtt,
202: csp_planning_parameters cpp
203: where mmtt.organization_id = cpp.organization_id
204: and cpp.organization_type = 'W'
205: and mmtt.posting_flag = 'Y'

Line 255: from mtl_material_transactions_temp mmtt,

251: mmtt.organization_id,
252: cpp.planning_parameters_id,
253: cpp.level_id,
254: sum(nvl(mmtt.primary_quantity,0))
255: from mtl_material_transactions_temp mmtt,
256: csp_planning_parameters cpp
257: where mmtt.organization_id = cpp.organization_id
258: and cpp.node_type = 'ORGANIZATION_WH'
259: and cpp.organization_type = 'W'

Line 318: from mtl_material_transactions_temp mmtt,

314: cpp.planning_parameters_id,
315: cpp.level_id,
316: sum(nvl(mmtt.primary_quantity,0)),
317: sum(nvl(mmtt.primary_quantity,0)) * -1
318: from mtl_material_transactions_temp mmtt,
319: csp_sec_inventories csi,
320: csp_planning_parameters cpp
321: where mmtt.organization_id = cpp.organization_id
322: and cpp.organization_type = 'W'

Line 384: from mtl_material_transactions_temp mmtt,

380: cpp.planning_parameters_id,
381: cpp.level_id,
382: sum(nvl(mmtt.primary_quantity,0)),
383: sum(nvl(mmtt.primary_quantity,0)) * -1
384: from mtl_material_transactions_temp mmtt,
385: csp_sec_inventories csi,
386: csp_planning_parameters cpp
387: where mmtt.organization_id = cpp.organization_id
388: and mmtt.subinventory_code = csi.secondary_inventory_name