[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) =
212: ,NULL locator_inventory_item_id
213: ,NULL empty_flag
214: ,NULL location_current_units
215: from mtl_serial_numbers msn
216: ,mtl_secondary_inventories sub
217: ,mtl_item_locations loc
218: ,mtl_lot_numbers lot
219: where msn.current_status = 3
220: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
326: ,NULL locator_inventory_item_id
327: ,NULL empty_flag
328: ,NULL location_current_units
329: from mtl_serial_numbers msn
330: ,mtl_secondary_inventories sub
331: ,mtl_item_locations loc
332: ,mtl_lot_numbers lot
333: where msn.current_status = 3
334: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
493: ,decode(mils.task_id, mils.task_id, moq.task_id)
494: HAVING
495: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
496: ) x
497: ,mtl_secondary_inventories sub
498: ,mtl_lot_numbers lot
499: where
500: -- x.primary_quantity > 0 and -- high volume project 8546026
501: x.organization_id = sub.organization_id
503: and x.organization_id = lot.organization_id (+)
504: and x.inventory_item_id = lot.inventory_item_id (+)
505: and x.lot_number = lot.lot_number (+)
506: ) x
507: ,mtl_secondary_inventories sub
508: ,mtl_item_locations loc
509: WHERE x.organization_id = loc.organization_id (+)
510: AND x.locator_id = loc.inventory_location_id (+)
511: AND sub.organization_id = x.organization_id