[Home] [Help]
109: ,NULL locator_inventory_item_id
110: ,NULL empty_flag
111: ,NULL location_current_units
112: from mtl_serial_numbers msn
113: ,mtl_secondary_inventories sub
114: ,mtl_item_locations loc
115: ,mtl_lot_numbers lot
116: where msn.current_status = 3
117: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
198: ,NULL locator_inventory_item_id
199: ,NULL empty_flag
200: ,NULL location_current_units
201: from mtl_serial_numbers msn
202: ,mtl_secondary_inventories sub
203: ,mtl_item_locations loc
204: ,mtl_lot_numbers lot
205: where msn.current_status = 3
206: 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) =
460: ,moq.cost_group_id,moq.status_id, mils.reservable_type, moq.lpn_id -- Bug 6719290
461: ,decode(mils.project_id, mils.project_id, moq.project_id)
462: ,decode(mils.task_id, mils.task_id, moq.task_id)
463: ) x
464: ,mtl_secondary_inventories sub
465: ,mtl_lot_numbers lot
466: where x.primary_quantity > 0
467: and x.organization_id = sub.organization_id
468: and x.subinventory_code = sub.secondary_inventory_name
469: and x.organization_id = lot.organization_id (+)
470: and x.inventory_item_id = lot.inventory_item_id (+)
471: and x.lot_number = lot.lot_number (+)
472: ) x
473: ,mtl_secondary_inventories sub
474: ,mtl_item_locations loc
475: WHERE x.organization_id = loc.organization_id (+)
476: AND x.locator_id = loc.inventory_location_id (+)
477: AND sub.organization_id = x.organization_id