[Home] [Help]
120: ,NULL empty_flag
121: ,NULL location_current_units
122: from mtl_serial_numbers msn
123: ,mtl_secondary_inventories sub
124: ,mtl_item_locations loc
125: ,mtl_lot_numbers lot
126: where msn.current_status = 3
127: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
128: decode(g_unit_number, '-9999', 'a', g_unit_number)
232: ,NULL empty_flag
233: ,NULL location_current_units
234: from mtl_serial_numbers msn
235: ,mtl_secondary_inventories sub
236: ,mtl_item_locations loc
237: ,mtl_lot_numbers lot
238: where msn.current_status = 3
239: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
240: decode(g_unit_number, '-9999', 'a', g_unit_number)
373: ,NULL empty_flag
374: ,NULL location_current_units
375: from mtl_serial_numbers msn
376: ,mtl_secondary_inventories sub
377: ,mtl_item_locations loc
378: ,mtl_lot_numbers lot
379: where msn.current_status = 3
380: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
381: decode(g_unit_number, '-9999', 'a', g_unit_number)
548: ,moq.lpn_id lpn_id
549: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
550: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
551: FROM
552: mtl_onhand_quantities_detail moq,mtl_item_locations mils
553: WHERE
554: moq.organization_id = g_organization_id
555: AND moq.inventory_item_id = g_inventory_item_id
556: AND moq.organization_id = mils.organization_id (+)
577: and x.inventory_item_id = lot.inventory_item_id (+)
578: and x.lot_number = lot.lot_number (+)
579: ) x
580: ,mtl_secondary_inventories sub
581: ,mtl_item_locations loc
582: WHERE x.organization_id = loc.organization_id (+)
583: AND x.locator_id = loc.inventory_location_id (+)
584: AND sub.organization_id = x.organization_id
585: AND sub.secondary_inventory_name = x.subinventory_code