[Home] [Help]
119: ,NULL locator_inventory_item_id
120: ,NULL empty_flag
121: ,NULL location_current_units
122: from mtl_serial_numbers msn
123: ,mtl_secondary_inventories sub
124: ,mtl_item_locations loc
125: ,mtl_lot_numbers lot
126: where msn.current_status = 3
127: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
231: ,NULL locator_inventory_item_id
232: ,NULL empty_flag
233: ,NULL location_current_units
234: from mtl_serial_numbers msn
235: ,mtl_secondary_inventories sub
236: ,mtl_item_locations loc
237: ,mtl_lot_numbers lot
238: where msn.current_status = 3
239: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
372: ,NULL locator_inventory_item_id
373: ,NULL empty_flag
374: ,NULL location_current_units
375: from mtl_serial_numbers msn
376: ,mtl_secondary_inventories sub
377: ,mtl_item_locations loc
378: ,mtl_lot_numbers lot
379: where msn.current_status = 3
380: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
566: ,decode(mils.task_id, mils.task_id, moq.task_id)
567: HAVING
568: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
569: ) x
570: ,mtl_secondary_inventories sub
571: ,mtl_lot_numbers lot
572: where
573: -- x.primary_quantity > 0 and -- high volume project 8546026
574: x.organization_id = sub.organization_id
576: and x.organization_id = lot.organization_id (+)
577: and x.inventory_item_id = lot.inventory_item_id (+)
578: and x.lot_number = lot.lot_number (+)
579: ) x
580: ,mtl_secondary_inventories sub
581: ,mtl_item_locations loc
582: WHERE x.organization_id = loc.organization_id (+)
583: AND x.locator_id = loc.inventory_location_id (+)
584: AND sub.organization_id = x.organization_id