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.OKL_LA_ASSET_PVT dependencies on OKL_OLD_ASSETS_UV

Line 963: from okl_old_assets_uv oast

959: -- oalc.location_id location_id,
960: -- oast.fin_line_id parent_line_id,
961: oast.parent_line_id,
962: oast.dnz_chr_id
963: from okl_old_assets_uv oast
964: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
965: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
966: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
967: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1074: from okl_old_assets_uv oast

1070: -- oalc.location_id location_id,
1071: -- oast.fin_line_id parent_line_id,
1072: oast.parent_line_id,
1073: oast.dnz_chr_id
1074: from okl_old_assets_uv oast
1075: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1076: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1077: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1078: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1370: from okl_old_assets_uv oast

1366: oast.sts_code,
1367: oast.location_id,
1368: oast.parent_line_id,
1369: oast.dnz_chr_id
1370: from okl_old_assets_uv oast
1371: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1372: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1373: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1374: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1444: from okl_old_assets_uv oast

1440: -- oalc.location_id location_id,
1441: -- oast.fin_line_id parent_line_id,
1442: oast.parent_line_id,
1443: oast.dnz_chr_id
1444: from okl_old_assets_uv oast
1445: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1446: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1447: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1448: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)