[Home] [Help]
108: ,NULL locator_inventory_item_id
109: ,NULL empty_flag
110: ,NULL location_current_units
111: from mtl_serial_numbers msn
112: ,mtl_secondary_inventories sub
113: ,mtl_item_locations loc
114: ,mtl_lot_numbers lot
115: where msn.current_status = 3
116: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
192: ,NULL locator_inventory_item_id
193: ,NULL empty_flag
194: ,NULL location_current_units
195: from mtl_serial_numbers msn
196: ,mtl_secondary_inventories sub
197: ,mtl_item_locations loc
198: ,mtl_lot_numbers lot
199: where msn.current_status = 3
200: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
293: ,NULL locator_inventory_item_id
294: ,NULL empty_flag
295: ,NULL location_current_units
296: from mtl_serial_numbers msn
297: ,mtl_secondary_inventories sub
298: ,mtl_item_locations loc
299: ,mtl_lot_numbers lot
300: where msn.current_status = 3
301: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
444: ,moq.cost_group_id,moq.status_id, mils.reservable_type, moq.lpn_id -- Bug 6719290
445: ,decode(mils.project_id, mils.project_id, moq.project_id)
446: ,decode(mils.task_id, mils.task_id, moq.task_id)
447: ) x
448: ,mtl_secondary_inventories sub
449: ,mtl_lot_numbers lot
450: where x.primary_quantity > 0
451: and x.organization_id = sub.organization_id
452: and x.subinventory_code = sub.secondary_inventory_name
453: and x.organization_id = lot.organization_id (+)
454: and x.inventory_item_id = lot.inventory_item_id (+)
455: and x.lot_number = lot.lot_number (+)
456: ) x
457: ,mtl_secondary_inventories sub
458: ,mtl_item_locations loc
459: WHERE x.organization_id = loc.organization_id (+)
460: AND x.locator_id = loc.inventory_location_id (+)
461: AND sub.organization_id = x.organization_id