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_NEW_LOAN_ASSETS_UV

Line 1236: from okl_new_loan_assets_uv nast

1232: -- nalc.location_id location_id,
1233: -- nast.fin_line_id parent_line_id,
1234: nast.parent_line_id,
1235: nast.dnz_chr_id
1236: from okl_new_loan_assets_uv nast
1237: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
1238: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
1239: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
1240: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 1289: from okl_new_loan_assets_uv nast

1285: -- nalc.location_id location_id,
1286: -- nast.fin_line_id parent_line_id,
1287: nast.parent_line_id,
1288: nast.dnz_chr_id
1289: from okl_new_loan_assets_uv nast
1290: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
1291: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
1292: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
1293: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 1770: FROM okl_new_loan_assets_uv nast

1766: nast.sts_code,
1767: nast.location_id,
1768: nast.parent_line_id,
1769: nast.dnz_chr_id
1770: FROM okl_new_loan_assets_uv nast
1771: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1772: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1773: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1774: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)

Line 1840: FROM okl_new_loan_assets_uv nast

1836: nast.sts_code,
1837: nast.location_id,
1838: nast.parent_line_id,
1839: nast.dnz_chr_id
1840: FROM okl_new_loan_assets_uv nast
1841: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1842: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1843: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1844: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)