[Home] [Help]
109: ,NULL empty_flag
110: ,NULL location_current_units
111: from mtl_serial_numbers msn
112: ,mtl_secondary_inventories sub
113: ,mtl_item_locations loc
114: ,mtl_lot_numbers lot
115: where msn.current_status = 3
116: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
117: decode(g_unit_number, '-9999', 'a', g_unit_number)
192: ,NULL empty_flag
193: ,NULL location_current_units
194: from mtl_serial_numbers msn
195: ,mtl_secondary_inventories sub
196: ,mtl_item_locations loc
197: ,mtl_lot_numbers lot
198: where msn.current_status = 3
199: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
200: decode(g_unit_number, '-9999', 'a', g_unit_number)
291: ,NULL empty_flag
292: ,NULL location_current_units
293: from mtl_serial_numbers msn
294: ,mtl_secondary_inventories sub
295: ,mtl_item_locations loc
296: ,mtl_lot_numbers lot
297: where msn.current_status = 3
298: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
299: decode(g_unit_number, '-9999', 'a', g_unit_number)
424: ,moq.lpn_id lpn_id
425: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
426: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
427: FROM
428: mtl_onhand_quantities_detail moq,mtl_item_locations mils
429: WHERE
430: moq.organization_id = g_organization_id
431: AND moq.inventory_item_id = g_inventory_item_id
432: AND moq.organization_id = mils.organization_id (+)
449: and x.inventory_item_id = lot.inventory_item_id (+)
450: and x.lot_number = lot.lot_number (+)
451: ) x
452: ,mtl_secondary_inventories sub
453: ,mtl_item_locations loc
454: WHERE x.organization_id = loc.organization_id (+)
455: AND x.locator_id = loc.inventory_location_id (+)
456: AND sub.organization_id = x.organization_id
457: AND sub.secondary_inventory_name = x.subinventory_code