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_ACTIVATE_IB_PVT dependencies on OKC_LINE_STYLES_B

Line 843: OKC_LINE_STYLES_B MDL_LSE,

839: cim.object1_id1,
840: cim.object1_id2
841: FROM OKC_K_ITEMS CIM,
842: OKC_K_LINES_B MDL,
843: OKC_LINE_STYLES_B MDL_LSE,
844: OKC_K_LINES_B INST
845: WHERE CIM.CLE_ID = MDL.ID
846: AND MDL.CLE_ID = INST.CLE_ID
847: AND MDL.LSE_ID = MDL_LSE.ID

Line 1519: OKC_LINE_STYLES_B CLS,

1515: AND ROWNUM = 1
1516: AND NOT EXISTS
1517: (SELECT CLE.DNZ_CHR_ID
1518: FROM OKC_K_LINES_B CLE,
1519: OKC_LINE_STYLES_B CLS,
1520: OKC_K_ITEMS CIM,
1521: OKX_INSTALL_ITEMS_V CIX,
1522: OKL_K_HEADERS KHR
1523: WHERE CLE.LSE_ID = CLS.ID

Line 1537: FROM okc_line_styles_b lse,

1533: SELECT '!'
1534: FROM okc_k_headers_b CHR
1535: WHERE chr.id = p_contract_id
1536: AND EXISTS (SELECT '1'
1537: FROM okc_line_styles_b lse,
1538: okc_k_lines_b cle
1539: WHERE cle.sts_code = 'APPROVED'
1540: AND lse.id = cle.lse_id
1541: AND lse.lty_code = 'USAGE'

Line 2231: okc_line_styles_b lse,

2227: SELECT cle.id,
2228: cle.cle_id,
2229: cle.dnz_chr_id
2230: from okc_k_lines_b cle,
2231: okc_line_styles_b lse,
2232: okc_k_lines_b inst_cle,
2233: okc_line_styles_b inst_cle_lse
2234: where lse.id = cle.lse_id
2235: and lse.lty_code = p_lty_code

Line 2233: okc_line_styles_b inst_cle_lse

2229: cle.dnz_chr_id
2230: from okc_k_lines_b cle,
2231: okc_line_styles_b lse,
2232: okc_k_lines_b inst_cle,
2233: okc_line_styles_b inst_cle_lse
2234: where lse.id = cle.lse_id
2235: and lse.lty_code = p_lty_code
2236: and cle.cle_id = inst_cle.id
2237: and cle.dnz_chr_id = inst_cle.dnz_chr_id

Line 2448: okc_line_styles_b lseb_ib,

2444: trx.id tas_id,
2445: cleb_ib.id cleb_ib_id
2446: From okc_k_items cim_ib,
2447: okc_k_lines_b cleb_ib,
2448: okc_line_styles_b lseb_ib,
2449: okc_statuses_b stsb,
2450: okl_txl_itm_insts iti,
2451: okl_trx_assets trx,
2452: okl_trx_types_tl ttyt

Line 3102: OKC_LINE_STYLES_B MDL_LSE

3098: cim.object1_id1,
3099: cim.object1_id2
3100: FROM OKC_K_ITEMS CIM,
3101: OKC_K_LINES_B MDL,
3102: OKC_LINE_STYLES_B MDL_LSE
3103: WHERE CIM.CLE_ID = MDL.ID
3104: AND MDL.CLE_ID = p_fin_ast_cle_id
3105: AND MDL.LSE_ID = MDL_LSE.ID
3106: AND MDL_LSE.LTY_CODE = G_MODEL_LINE_LTY_CODE;