[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) =
204: ,NULL locator_inventory_item_id
205: ,NULL empty_flag
206: ,NULL location_current_units
207: from mtl_serial_numbers msn
208: ,mtl_secondary_inventories sub
209: ,mtl_item_locations loc
210: ,mtl_lot_numbers lot
211: where msn.current_status = 3
212: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
313: ,NULL locator_inventory_item_id
314: ,NULL empty_flag
315: ,NULL location_current_units
316: from mtl_serial_numbers msn
317: ,mtl_secondary_inventories sub
318: ,mtl_item_locations loc
319: ,mtl_lot_numbers lot
320: where msn.current_status = 3
321: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
472: ,moq.cost_group_id,moq.status_id, mils.reservable_type, moq.lpn_id -- Bug 6719290
473: ,decode(mils.project_id, mils.project_id, moq.project_id)
474: ,decode(mils.task_id, mils.task_id, moq.task_id)
475: ) x
476: ,mtl_secondary_inventories sub
477: ,mtl_lot_numbers lot
478: where x.primary_quantity > 0
479: and x.organization_id = sub.organization_id
480: and x.subinventory_code = sub.secondary_inventory_name
481: and x.organization_id = lot.organization_id (+)
482: and x.inventory_item_id = lot.inventory_item_id (+)
483: and x.lot_number = lot.lot_number (+)
484: ) x
485: ,mtl_secondary_inventories sub
486: ,mtl_item_locations loc
487: WHERE x.organization_id = loc.organization_id (+)
488: AND x.locator_id = loc.inventory_location_id (+)
489: AND sub.organization_id = x.organization_id