[Home] [Help]
111: ,NULL locator_inventory_item_id
112: ,NULL empty_flag
113: ,NULL location_current_units
114: from mtl_serial_numbers msn
115: ,mtl_secondary_inventories sub
116: ,mtl_item_locations loc
117: ,mtl_lot_numbers lot
118: where msn.current_status = 3
119: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
198: ,NULL locator_inventory_item_id
199: ,NULL empty_flag
200: ,NULL location_current_units
201: from mtl_serial_numbers msn
202: ,mtl_secondary_inventories sub
203: ,mtl_item_locations loc
204: ,mtl_lot_numbers lot
205: where msn.current_status = 3
206: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
301: ,NULL locator_inventory_item_id
302: ,NULL empty_flag
303: ,NULL location_current_units
304: from mtl_serial_numbers msn
305: ,mtl_secondary_inventories sub
306: ,mtl_item_locations loc
307: ,mtl_lot_numbers lot
308: where msn.current_status = 3
309: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
457: ,decode(mils.task_id, mils.task_id, moq.task_id)
458: HAVING
459: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
460: ) x
461: ,mtl_secondary_inventories sub
462: ,mtl_lot_numbers lot
463: where
464: -- x.primary_quantity > 0 and -- high volume project 8546026
465: x.organization_id = sub.organization_id
467: and x.organization_id = lot.organization_id (+)
468: and x.inventory_item_id = lot.inventory_item_id (+)
469: and x.lot_number = lot.lot_number (+)
470: ) x
471: ,mtl_secondary_inventories sub
472: ,mtl_item_locations loc
473: WHERE x.organization_id = loc.organization_id (+)
474: AND x.locator_id = loc.inventory_location_id (+)
475: AND sub.organization_id = x.organization_id