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_LOAN_ASSETS_UV

Line 1132: from okl_old_loan_assets_uv oast

1128: -- oalc.location_id location_id,
1129: -- oast.fin_line_id parent_line_id,
1130: oast.parent_line_id,
1131: oast.dnz_chr_id
1132: from okl_old_loan_assets_uv oast
1133: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1134: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1135: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1136: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1184: from okl_old_loan_assets_uv oast

1180: -- oalc.location_id location_id,
1181: -- oast.fin_line_id parent_line_id,
1182: oast.parent_line_id,
1183: oast.dnz_chr_id
1184: from okl_old_loan_assets_uv oast
1185: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1186: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1187: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1188: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1489: from okl_old_loan_assets_uv oast

1485: oast.sts_code,
1486: oast.location_id,
1487: oast.parent_line_id,
1488: oast.dnz_chr_id
1489: from okl_old_loan_assets_uv oast
1490: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1491: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1492: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1493: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1558: from okl_old_loan_assets_uv oast

1554: oast.sts_code,
1555: oast.location_id,
1556: oast.parent_line_id,
1557: oast.dnz_chr_id
1558: from okl_old_loan_assets_uv oast
1559: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1560: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1561: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1562: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)