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_QA_DATA_INTEGRITY dependencies on OKL_TXL_ITM_INSTS

Line 4554: okl_txl_itm_insts inst

4550: SELECT COUNT(inst.serial_number) no_srl
4551: FROM okc_k_lines_b ib,
4552: okc_k_lines_b f2,
4553: okc_line_styles_b style,
4554: okl_txl_itm_insts inst
4555: WHERE f2.cle_id = p_top_cle_id
4556: AND f2.lse_id = style.id
4557: AND f2.dnz_chr_id = p_chr_id
4558: AND ib.dnz_chr_id = p_chr_id

Line 4571: okl_txl_itm_insts inst

4567: SELECT inst.serial_number
4568: FROM okc_k_lines_b ib,
4569: okc_k_lines_b f2,
4570: okc_line_styles_b style,
4571: okl_txl_itm_insts inst
4572: WHERE f2.cle_id = p_top_cle_id
4573: AND f2.lse_id = style.id
4574: AND f2.dnz_chr_id = p_chr_id
4575: AND ib.dnz_chr_id = p_chr_id

Line 4715: FROM okl_txl_itm_insts iti

4711: serial_number,
4712: mfg_serial_number_yn,
4713: inventory_item_id,
4714: inv_master_org_id
4715: FROM okl_txl_itm_insts iti
4716: WHERE iti.kle_id = p_kle_id
4717: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4718: AND EXISTS (SELECT '1' FROM okl_trx_assets
4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK

Line 9586: FROM OKL_TXL_ITM_INSTS inst,

9582: cust_rec cust_csr%ROWTYPE;
9583:
9584: CURSOR l_inst_csr( chrId NUMBER ) IS
9585: SELECT inst.object_id1_new
9586: FROM OKL_TXL_ITM_INSTS inst,
9587: OKL_K_LINES_FULL_V kle,
9588: OKC_LINE_STYLES_B lse
9589: WHERE inst.kle_id = kle.id
9590: AND lse.id = kle.lse_id