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 801: , DUAL d

797: , WMS_LICENSE_PLATE_NUMBERS plpn
798: , WMS_LICENSE_PLATE_NUMBERS olpn
799: , MTL_SYSTEM_ITEMS_KFV msik
800: /*Commented for bug# 6334460 start
801: , DUAL d
802: WHERE d.dummy = 'X'
803: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
804: Commented for bug# 6334460 end */
805: WHERE lpn.lpn_id (+) = p_lpn_id

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

1063: , mtl_item_locations milkfv
1064: WHERE plpn.lpn_id in (select /*+ cardinality(1) */ lpn_id from wms_license_plate_numbers
1065: where 1=1
1066: -- Bug 4137707
1067: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual
1068: --union all
1069: --select lpn_id from wms_packaging_hist
1070: --where pack_level = 0
1071: --and lpn_id IS not null

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

1183: WHERE plpn.lpn_id in (
1184: select /*+ cardinality(1) */ id from
1185: ((select lpn_id id from wms_license_plate_numbers
1186: where 1=1
1187: start with lpn_id in (select nvl(p_lpn_id, -99) from dual
1188: union all
1189: select /*+ cardinality(1) */ lpn_id from wms_packaging_hist
1190: where pack_level = 0
1191: and lpn_id IS not null