[Home] [Help]
117: ,NULL empty_flag
118: ,NULL location_current_units
119: from mtl_serial_numbers msn
120: ,mtl_secondary_inventories sub
121: ,mtl_item_locations loc
122: ,mtl_lot_numbers lot
123: where msn.current_status = 3
124: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
125: decode(g_unit_number, '-9999', 'a', g_unit_number)
224: ,NULL empty_flag
225: ,NULL location_current_units
226: from mtl_serial_numbers msn
227: ,mtl_secondary_inventories sub
228: ,mtl_item_locations loc
229: ,mtl_lot_numbers lot
230: where msn.current_status = 3
231: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
232: decode(g_unit_number, '-9999', 'a', g_unit_number)
360: ,NULL empty_flag
361: ,NULL location_current_units
362: from mtl_serial_numbers msn
363: ,mtl_secondary_inventories sub
364: ,mtl_item_locations loc
365: ,mtl_lot_numbers lot
366: where msn.current_status = 3
367: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
368: decode(g_unit_number, '-9999', 'a', g_unit_number)
530: ,moq.lpn_id lpn_id
531: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
532: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
533: FROM
534: mtl_onhand_quantities_detail moq,mtl_item_locations mils
535: WHERE
536: moq.organization_id = g_organization_id
537: AND moq.inventory_item_id = g_inventory_item_id
538: AND moq.organization_id = mils.organization_id (+)
555: and x.inventory_item_id = lot.inventory_item_id (+)
556: and x.lot_number = lot.lot_number (+)
557: ) x
558: ,mtl_secondary_inventories sub
559: ,mtl_item_locations loc
560: WHERE x.organization_id = loc.organization_id (+)
561: AND x.locator_id = loc.inventory_location_id (+)
562: AND sub.organization_id = x.organization_id
563: AND sub.secondary_inventory_name = x.subinventory_code