[Home] [Help]
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
35: and moq.inventory_item_id > 0
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
115: and moq.inventory_item_id > 0
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
147: and mmtt.posting_flag = 'Y'
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
293: and csi.condition_type = 'B'
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'
323: and csi.condition_type = 'B'
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
358: and csi.condition_type = 'B'
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
389: and csi.organization_id = cpp.organization_id
428: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
429: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
430: from mtl_supply ms,
431: po_requisition_headers_all prha,
432: csp_sec_inventories csi,
433: csp_planning_parameters cpp
434: where ms.req_header_id = prha.requisition_header_id(+)
435: and ms.to_organization_id = csi.organization_id
436: and ms.to_subinventory = csi.secondary_inventory_name
637: cpp.level_id,
638: sum(start_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped, 0))
639: from wip_discrete_jobs wdj,
640: wip_entities we,
641: csp_sec_inventories csi,
642: csp_planning_parameters cpp
643: where wdj.status_type = 3
644: and we.wip_entity_id = wdj.wip_entity_id
645: and we.entity_type <> 6
782: msib.primary_uom_code,
783: null,
784: null))
785: from mtl_txn_request_lines mtrl,
786: csp_sec_inventories csi,
787: mtl_system_items_b msib,
788: csp_planning_parameters cpp
789: where mtrl.organization_id = csi.organization_id
790: and mtrl.organization_id = msib.organization_id
865: msib.primary_uom_code,
866: null,
867: null))
868: from mtl_txn_request_lines mtrl,
869: csp_sec_inventories csi,
870: mtl_system_items_b msib,
871: csp_planning_parameters cpp
872: where mtrl.organization_id = csi.organization_id
873: and mtrl.organization_id = msib.organization_id
1039: sum(nvl(ola.ordered_quantity,0) -
1040: nvl(ola.cancelled_quantity,0) -
1041: nvl(ola.shipped_quantity,0)),0) internal_orders_out
1042: from oe_order_lines_all ola,
1043: csp_sec_inventories csi,
1044: csp_planning_parameters cpp
1045: where ola.ship_from_org_id = csi.organization_id
1046: and ola.subinventory = csi.secondary_inventory_name
1047: and ola.open_flag = 'Y'
1118: cpp.planning_parameters_id,
1119: cpp.level_id,
1120: sum(nvl(excess_quantity,0))
1121: from csp_excess_lists cel,
1122: csp_sec_inventories csi,
1123: csp_planning_parameters cpp
1124: where cel.condition_code = 'G'
1125: and cel.excess_status = 'O'
1126: and cel.subinventory_code = csi.secondary_inventory_name