[Home] [Help]
114: ,NULL locator_inventory_item_id
115: ,NULL empty_flag
116: ,NULL location_current_units
117: from mtl_serial_numbers msn
118: ,mtl_secondary_inventories sub
119: ,mtl_item_locations loc
120: ,mtl_lot_numbers lot
121: where msn.current_status = 3
122: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
211: ,NULL locator_inventory_item_id
212: ,NULL empty_flag
213: ,NULL location_current_units
214: from mtl_serial_numbers msn
215: ,mtl_secondary_inventories sub
216: ,mtl_item_locations loc
217: ,mtl_lot_numbers lot
218: where msn.current_status = 3
219: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
324: ,NULL locator_inventory_item_id
325: ,NULL empty_flag
326: ,NULL location_current_units
327: from mtl_serial_numbers msn
328: ,mtl_secondary_inventories sub
329: ,mtl_item_locations loc
330: ,mtl_lot_numbers lot
331: where msn.current_status = 3
332: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
490: ,decode(mils.task_id, mils.task_id, moq.task_id)
491: HAVING
492: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
493: ) x
494: ,mtl_secondary_inventories sub
495: ,mtl_lot_numbers lot
496: where
497: -- x.primary_quantity > 0 and -- high volume project 8546026
498: x.organization_id = sub.organization_id
500: and x.organization_id = lot.organization_id (+)
501: and x.inventory_item_id = lot.inventory_item_id (+)
502: and x.lot_number = lot.lot_number (+)
503: ) x
504: ,mtl_secondary_inventories sub
505: ,mtl_item_locations loc
506: WHERE x.organization_id = loc.organization_id (+)
507: AND x.locator_id = loc.inventory_location_id (+)
508: AND sub.organization_id = x.organization_id