[Home] [Help]
111: ,NULL empty_flag
112: ,NULL location_current_units
113: from mtl_serial_numbers msn
114: ,mtl_secondary_inventories sub
115: ,mtl_item_locations loc
116: ,mtl_lot_numbers lot
117: where msn.current_status = 3
118: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
119: decode(g_unit_number, '-9999', 'a', g_unit_number)
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) =
213: decode(g_unit_number, '-9999', 'a', g_unit_number)
316: ,NULL empty_flag
317: ,NULL location_current_units
318: from mtl_serial_numbers msn
319: ,mtl_secondary_inventories sub
320: ,mtl_item_locations loc
321: ,mtl_lot_numbers lot
322: where msn.current_status = 3
323: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
324: decode(g_unit_number, '-9999', 'a', g_unit_number)
461: ,moq.lpn_id lpn_id
462: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
463: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
464: FROM
465: mtl_onhand_quantities_detail moq,mtl_item_locations mils
466: WHERE
467: moq.organization_id = g_organization_id
468: AND moq.inventory_item_id = g_inventory_item_id
469: AND moq.organization_id = mils.organization_id (+)
486: and x.inventory_item_id = lot.inventory_item_id (+)
487: and x.lot_number = lot.lot_number (+)
488: ) x
489: ,mtl_secondary_inventories sub
490: ,mtl_item_locations loc
491: WHERE x.organization_id = loc.organization_id (+)
492: AND x.locator_id = loc.inventory_location_id (+)
493: AND sub.organization_id = x.organization_id
494: AND sub.secondary_inventory_name = x.subinventory_code