[Home] [Help]
113: ,NULL locator_inventory_item_id
114: ,NULL empty_flag
115: ,NULL location_current_units
116: from mtl_serial_numbers msn
117: ,mtl_secondary_inventories sub
118: ,mtl_item_locations loc
119: ,mtl_lot_numbers lot
120: where msn.current_status = 3
121: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
208: ,NULL locator_inventory_item_id
209: ,NULL empty_flag
210: ,NULL location_current_units
211: from mtl_serial_numbers msn
212: ,mtl_secondary_inventories sub
213: ,mtl_item_locations loc
214: ,mtl_lot_numbers lot
215: where msn.current_status = 3
216: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
319: ,NULL locator_inventory_item_id
320: ,NULL empty_flag
321: ,NULL location_current_units
322: from mtl_serial_numbers msn
323: ,mtl_secondary_inventories sub
324: ,mtl_item_locations loc
325: ,mtl_lot_numbers lot
326: where msn.current_status = 3
327: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
483: ,decode(mils.task_id, mils.task_id, moq.task_id)
484: HAVING
485: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
486: ) x
487: ,mtl_secondary_inventories sub
488: ,mtl_lot_numbers lot
489: where
490: -- x.primary_quantity > 0 and -- high volume project 8546026
491: x.organization_id = sub.organization_id
493: and x.organization_id = lot.organization_id (+)
494: and x.inventory_item_id = lot.inventory_item_id (+)
495: and x.lot_number = lot.lot_number (+)
496: ) x
497: ,mtl_secondary_inventories sub
498: ,mtl_item_locations loc
499: WHERE x.organization_id = loc.organization_id (+)
500: AND x.locator_id = loc.inventory_location_id (+)
501: AND sub.organization_id = x.organization_id