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 4224: okl_txl_itm_insts inst

4220: SELECT COUNT(inst.serial_number) no_srl
4221: FROM okc_k_lines_b ib,
4222: okc_k_lines_b f2,
4223: okc_line_styles_b style,
4224: okl_txl_itm_insts inst
4225: WHERE f2.cle_id = p_top_cle_id
4226: AND f2.lse_id = style.id
4227: AND f2.dnz_chr_id = p_chr_id
4228: AND ib.dnz_chr_id = p_chr_id

Line 4328: FROM okl_txl_itm_insts iti

4324: serial_number,
4325: mfg_serial_number_yn,
4326: inventory_item_id,
4327: inv_master_org_id
4328: FROM okl_txl_itm_insts iti
4329: WHERE iti.kle_id = p_kle_id
4330: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4331: AND EXISTS (SELECT '1' FROM okl_trx_assets
4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK

Line 9165: FROM OKL_TXL_ITM_INSTS inst,

9161: cust_rec cust_csr%ROWTYPE;
9162:
9163: CURSOR l_inst_csr( chrId NUMBER ) IS
9164: SELECT inst.object_id1_new
9165: FROM OKL_TXL_ITM_INSTS inst,
9166: OKL_K_LINES_FULL_V kle,
9167: OKC_LINE_STYLES_B lse
9168: WHERE inst.kle_id = kle.id
9169: AND lse.id = kle.lse_id