[Home] [Help]
112: ,NULL locator_inventory_item_id
113: ,NULL empty_flag
114: ,NULL location_current_units
115: from mtl_serial_numbers msn
116: ,mtl_secondary_inventories sub
117: ,mtl_item_locations loc
118: ,mtl_lot_numbers lot
119: where msn.current_status = 3
120: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
205: ,NULL locator_inventory_item_id
206: ,NULL empty_flag
207: ,NULL location_current_units
208: from mtl_serial_numbers msn
209: ,mtl_secondary_inventories sub
210: ,mtl_item_locations loc
211: ,mtl_lot_numbers lot
212: where msn.current_status = 3
213: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
314: ,NULL locator_inventory_item_id
315: ,NULL empty_flag
316: ,NULL location_current_units
317: from mtl_serial_numbers msn
318: ,mtl_secondary_inventories sub
319: ,mtl_item_locations loc
320: ,mtl_lot_numbers lot
321: where msn.current_status = 3
322: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
476: ,decode(mils.task_id, mils.task_id, moq.task_id)
477: HAVING
478: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
479: ) x
480: ,mtl_secondary_inventories sub
481: ,mtl_lot_numbers lot
482: where
483: -- x.primary_quantity > 0 and -- high volume project 8546026
484: x.organization_id = sub.organization_id
486: and x.organization_id = lot.organization_id (+)
487: and x.inventory_item_id = lot.inventory_item_id (+)
488: and x.lot_number = lot.lot_number (+)
489: ) x
490: ,mtl_secondary_inventories sub
491: ,mtl_item_locations loc
492: WHERE x.organization_id = loc.organization_id (+)
493: AND x.locator_id = loc.inventory_location_id (+)
494: AND sub.organization_id = x.organization_id