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 935: from okl_old_assets_uv oast

931: -- oalc.location_id location_id,
932: -- oast.fin_line_id parent_line_id,
933: oast.parent_line_id,
934: oast.dnz_chr_id
935: from okl_old_assets_uv oast
936: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
937: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
938: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
939: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1046: from okl_old_assets_uv oast

1042: -- oalc.location_id location_id,
1043: -- oast.fin_line_id parent_line_id,
1044: oast.parent_line_id,
1045: oast.dnz_chr_id
1046: from okl_old_assets_uv oast
1047: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1048: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1049: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1050: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1342: from okl_old_assets_uv oast

1338: oast.sts_code,
1339: oast.location_id,
1340: oast.parent_line_id,
1341: oast.dnz_chr_id
1342: from okl_old_assets_uv oast
1343: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1344: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1345: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1346: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1416: from okl_old_assets_uv oast

1412: -- oalc.location_id location_id,
1413: -- oast.fin_line_id parent_line_id,
1414: oast.parent_line_id,
1415: oast.dnz_chr_id
1416: from okl_old_assets_uv oast
1417: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1418: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1419: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1420: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)