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 878: from okl_new_assets_uv nast

874: -- nalc.location_id location_id,
875: -- nast.fin_line_id parent_line_id,
876: nast.parent_line_id,
877: nast.dnz_chr_id
878: from okl_new_assets_uv nast
879: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
880: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
881: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
882: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 990: from okl_new_assets_uv nast

986: -- nalc.location_id location_id,
987: -- nast.fin_line_id parent_line_id,
988: nast.parent_line_id,
989: nast.dnz_chr_id
990: from okl_new_assets_uv nast
991: where nast.dnz_chr_id = p_las_rec.dnz_chr_id
992: and upper(nast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(nast.asset_number))
993: and nvl(upper(nast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(nast.vendor_name),'x'))
994: and nast.oec between nvl(p_las_rec.from_oec,nast.oec) and nvl(p_las_rec.to_oec,nast.oec)

Line 1628: FROM okl_new_assets_uv nast

1624: nast.sts_code,
1625: nast.location_id,
1626: nast.parent_line_id,
1627: nast.dnz_chr_id
1628: FROM okl_new_assets_uv nast
1629: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1630: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1631: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1632: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)

Line 1700: FROM okl_new_assets_uv nast

1696: nast.sts_code,
1697: nast.location_id,
1698: nast.parent_line_id,
1699: nast.dnz_chr_id
1700: FROM okl_new_assets_uv nast
1701: WHERE nast.dnz_chr_id = p_las_rec.dnz_chr_id
1702: AND UPPER(nast.asset_number) LIKE NVL(UPPER(p_las_rec.asset_number),UPPER(nast.asset_number))
1703: AND NVL(UPPER(nast.vendor_name),'x') LIKE NVL(UPPER(p_las_rec.vendor_name),NVL(UPPER(nast.vendor_name),'x'))
1704: AND nast.oec BETWEEN NVL(p_las_rec.from_oec,nast.oec) AND NVL(p_las_rec.to_oec,nast.oec)