APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 67: from mtl_material_transactions_temp mmtt,

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

Line 141: from mtl_material_transactions_temp mmtt,

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

Line 200: from mtl_material_transactions_temp mmtt,

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

Line 254: from mtl_material_transactions_temp mmtt,

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

Line 317: from mtl_material_transactions_temp mmtt,

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

Line 383: from mtl_material_transactions_temp mmtt,

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