eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT5 dependencies on DUAL

Line 772: , DUAL d

768: , WMS_LICENSE_PLATE_NUMBERS plpn
769: , WMS_LICENSE_PLATE_NUMBERS olpn
770: , MTL_SYSTEM_ITEMS_KFV msik
771: /*Commented for bug# 6334460 start
772: , DUAL d
773: WHERE d.dummy = 'X'
774: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
775: Commented for bug# 6334460 end */
776: WHERE lpn.lpn_id (+) = p_lpn_id

Line 922: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual

918: , mtl_item_locations milkfv
919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
920: where 1=1
921: -- Bug 4137707
922: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual
923: --union all
924: --select lpn_id from wms_packaging_hist
925: --where pack_level = 0
926: --and lpn_id IS not null

Line 1039: start with lpn_id in (select nvl(p_lpn_id, -99) from dual

1035: , cst_cost_groups ccg
1036: , mtl_item_locations milkfv
1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
1038: where 1=1
1039: start with lpn_id in (select nvl(p_lpn_id, -99) from dual
1040: union all
1041: select lpn_id from wms_packaging_hist
1042: where pack_level = 0
1043: and lpn_id IS not null