[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) =
199: ,NULL locator_inventory_item_id
200: ,NULL empty_flag
201: ,NULL location_current_units
202: from mtl_serial_numbers msn
203: ,mtl_secondary_inventories sub
204: ,mtl_item_locations loc
205: ,mtl_lot_numbers lot
206: where msn.current_status = 3
207: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
304: ,NULL locator_inventory_item_id
305: ,NULL empty_flag
306: ,NULL location_current_units
307: from mtl_serial_numbers msn
308: ,mtl_secondary_inventories sub
309: ,mtl_item_locations loc
310: ,mtl_lot_numbers lot
311: where msn.current_status = 3
312: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
462: ,decode(mils.task_id, mils.task_id, moq.task_id)
463: HAVING
464: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
465: ) x
466: ,mtl_secondary_inventories sub
467: ,mtl_lot_numbers lot
468: where
469: -- x.primary_quantity > 0 and -- high volume project 8546026
470: x.organization_id = sub.organization_id
472: and x.organization_id = lot.organization_id (+)
473: and x.inventory_item_id = lot.inventory_item_id (+)
474: and x.lot_number = lot.lot_number (+)
475: ) x
476: ,mtl_secondary_inventories sub
477: ,mtl_item_locations loc
478: WHERE x.organization_id = loc.organization_id (+)
479: AND x.locator_id = loc.inventory_location_id (+)
480: AND sub.organization_id = x.organization_id