[Home] [Help]
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) =
118: decode(g_unit_number, '-9999', 'a', g_unit_number)
200: ,NULL empty_flag
201: ,NULL location_current_units
202: from mtl_serial_numbers msn
203: ,mtl_secondary_inventories sub
204: ,mtl_item_locations loc
205: ,mtl_lot_numbers lot
206: where msn.current_status = 3
207: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
208: decode(g_unit_number, '-9999', 'a', g_unit_number)
309: ,NULL empty_flag
310: ,NULL location_current_units
311: from mtl_serial_numbers msn
312: ,mtl_secondary_inventories sub
313: ,mtl_item_locations loc
314: ,mtl_lot_numbers lot
315: where msn.current_status = 3
316: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
317: decode(g_unit_number, '-9999', 'a', g_unit_number)
452: ,moq.lpn_id lpn_id
453: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
454: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
455: FROM
456: mtl_onhand_quantities_detail moq,mtl_item_locations mils
457: WHERE
458: moq.organization_id = g_organization_id
459: AND moq.inventory_item_id = g_inventory_item_id
460: AND moq.organization_id = mils.organization_id (+)
477: and x.inventory_item_id = lot.inventory_item_id (+)
478: and x.lot_number = lot.lot_number (+)
479: ) x
480: ,mtl_secondary_inventories sub
481: ,mtl_item_locations loc
482: WHERE x.organization_id = loc.organization_id (+)
483: AND x.locator_id = loc.inventory_location_id (+)
484: AND sub.organization_id = x.organization_id
485: AND sub.secondary_inventory_name = x.subinventory_code