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_ASSETS_UV

Line 906: from okl_new_assets_uv nast

902: -- nalc.location_id location_id,
903: -- nast.fin_line_id parent_line_id,
904: nast.parent_line_id,
905: nast.dnz_chr_id
906: from okl_new_assets_uv nast
907: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
908: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
909: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
910: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 1018: from okl_new_assets_uv nast

1014: -- nalc.location_id location_id,
1015: -- nast.fin_line_id parent_line_id,
1016: nast.parent_line_id,
1017: nast.dnz_chr_id
1018: from okl_new_assets_uv nast
1019: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
1020: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
1021: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
1022: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 1656: FROM okl_new_assets_uv nast

1652: nast.sts_code,
1653: nast.location_id,
1654: nast.parent_line_id,
1655: nast.dnz_chr_id
1656: FROM okl_new_assets_uv nast
1657: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1658: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1659: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1660: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)

Line 1728: FROM okl_new_assets_uv nast

1724: nast.sts_code,
1725: nast.location_id,
1726: nast.parent_line_id,
1727: nast.dnz_chr_id
1728: FROM okl_new_assets_uv nast
1729: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1730: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1731: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1732: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)