[Home] [Help]
116: ,NULL locator_inventory_item_id
117: ,NULL empty_flag
118: ,NULL location_current_units
119: from mtl_serial_numbers msn
120: ,mtl_secondary_inventories sub
121: ,mtl_item_locations loc
122: ,mtl_lot_numbers lot
123: where msn.current_status = 3
124: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
223: ,NULL locator_inventory_item_id
224: ,NULL empty_flag
225: ,NULL location_current_units
226: from mtl_serial_numbers msn
227: ,mtl_secondary_inventories sub
228: ,mtl_item_locations loc
229: ,mtl_lot_numbers lot
230: where msn.current_status = 3
231: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
359: ,NULL locator_inventory_item_id
360: ,NULL empty_flag
361: ,NULL location_current_units
362: from mtl_serial_numbers msn
363: ,mtl_secondary_inventories sub
364: ,mtl_item_locations loc
365: ,mtl_lot_numbers lot
366: where msn.current_status = 3
367: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
545: ,moq.cost_group_id,moq.status_id, mils.reservable_type, moq.lpn_id -- Bug 6719290
546: ,decode(mils.project_id, mils.project_id, moq.project_id)
547: ,decode(mils.task_id, mils.task_id, moq.task_id)
548: ) x
549: ,mtl_secondary_inventories sub
550: ,mtl_lot_numbers lot
551: where x.primary_quantity > 0
552: and x.organization_id = sub.organization_id
553: and x.subinventory_code = sub.secondary_inventory_name
554: and x.organization_id = lot.organization_id (+)
555: and x.inventory_item_id = lot.inventory_item_id (+)
556: and x.lot_number = lot.lot_number (+)
557: ) x
558: ,mtl_secondary_inventories sub
559: ,mtl_item_locations loc
560: WHERE x.organization_id = loc.organization_id (+)
561: AND x.locator_id = loc.inventory_location_id (+)
562: AND sub.organization_id = x.organization_id