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