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.OKS_CON_COVERAGE_PVT dependencies on OKC_K_ITEMS

Line 174: okc_k_items cimbp

170: okc_k_lines_b bpl,
171: oks_k_lines_b oksbpl, -- 11.5.10 rule rearchitecture changes
172: okc_k_lines_b cov,
173: okc_k_lines_b svl,
174: okc_k_items cimbp
175: where svl.id = p_line_id
176: and cov.cle_id = svl.id
177: and cov.lse_id in (2,15,20)
178: and bpl.cle_id = cov.id

Line 222: Select /+ leading(svl) use_nl(svl ksl bpl cimbp oksbpl) index(cimbp okc_k_items_n1) /

218: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
219: --
220: -- Bug Fix #5369536. Added hint.
221: Cursor l_bp_csr Is
222: Select /*+ leading(svl) use_nl(svl ksl bpl cimbp oksbpl) index(cimbp okc_k_items_n1) */
223: nvl(oksbpl.allow_bt_discount,'N') --'Y' -- fixed the 11.5.9 bug 3612660
224: From okc_k_lines_b svl,
225: oks_k_Lines_b ksl,
226: okc_k_lines_b bpl,

Line 227: okc_k_items cimbp,

223: nvl(oksbpl.allow_bt_discount,'N') --'Y' -- fixed the 11.5.9 bug 3612660
224: From okc_k_lines_b svl,
225: oks_k_Lines_b ksl,
226: okc_k_lines_b bpl,
227: okc_k_items cimbp,
228: oks_k_lines_b oksbpl -- 11.5.10 rule rearchitecture changes
229: where svl.id = p_line_id
230: and svl.lse_id in (1,14,19)
231: and ksl.cle_id = svl.id

Line 349: okc_k_items cimbp,

345: okc_k_lines_b cov,
346: okc_k_lines_b bpl,
347: okc_k_lines_b btl,
348: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
349: okc_k_items cimbp,
350: okc_k_items cimbt
351: -- okc_rule_groups_b rgp,
352: -- okc_rules_b rul
353: where svl.id = p_contract_line_id

Line 350: okc_k_items cimbt

346: okc_k_lines_b bpl,
347: okc_k_lines_b btl,
348: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
349: okc_k_items cimbp,
350: okc_k_items cimbt
351: -- okc_rule_groups_b rgp,
352: -- okc_rules_b rul
353: where svl.id = p_contract_line_id
354: and cov.cle_id = svl.id

Line 379: okc_k_items cimbt

375: okc_k_lines_b cov,
376: okc_k_lines_b bpl,
377: okc_k_lines_b btl,
378: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
379: okc_k_items cimbt
380: -- okc_rule_groups_b rgp,
381: -- okc_rules_b rul
382: where svl.id = p_contract_line_id
383: and cov.cle_id = svl.id

Line 413: okc_k_items cimbp,

409: from okc_k_lines_b svl,
410: okc_k_lines_b bpl,
411: okc_k_lines_b btl,
412: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
413: okc_k_items cimbp,
414: okc_k_items cimbt
415: ,OKS_K_LINES_B ksl
416:
417: where svl.id = p_contract_line_id

Line 414: okc_k_items cimbt

410: okc_k_lines_b bpl,
411: okc_k_lines_b btl,
412: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
413: okc_k_items cimbp,
414: okc_k_items cimbt
415: ,OKS_K_LINES_B ksl
416:
417: where svl.id = p_contract_line_id
418: and svl.lse_id in (1,14,19)

Line 439: okc_k_items cimbt

435: from okc_k_lines_b svl,
436: okc_k_lines_b bpl,
437: okc_k_lines_b btl,
438: oks_k_lines_b oksbtl, --11.5.10 rule reachitecture changes
439: okc_k_items cimbt
440: ,OKS_K_LINES_B ksl
441:
442: where svl.id = p_contract_line_id
443: and svl.lse_id in (1,14,19)

Line 799: okc_k_items cimbp,

795: from okc_k_lines_b svl,
796: okc_k_lines_b cov,
797: okc_k_lines_b bpl,
798: oks_k_lines_b oksbpl,
799: okc_k_items cimbp,
800: okc_k_headers_b chr -- 11.5.10 addition
801: where svl.id = p_contract_line_id
802: and svl.chr_id = chr.id -- 11.5.10 addition
803: and cov.cle_id = svl.id

Line 830: okc_k_items cimbp,

826: chr.price_list_id chr_pre
827: from okc_k_lines_b svl,
828: okc_k_lines_b bpl,
829: oks_k_lines_b oksbpl,
830: okc_k_items cimbp,
831: okc_k_headers_all_b chr -- Modified for 12.0 MOAC project (JVARGHES)
832: , oks_k_lines_b ksl
833: where svl.id = p_contract_line_id
834: and svl.lse_id in (1,14,19)

Line 911: okc_k_items cimbp,

907: select btl.id btl_id
908: from okc_k_lines_b svl,
909: okc_k_lines_b cov,
910: okc_k_lines_b bpl,
911: okc_k_items cimbp,
912: okc_k_lines_b btl,
913: okc_k_items cimbt
914: where svl.id = p_cont_line_id
915: and cov.cle_id = svl.id

Line 913: okc_k_items cimbt

909: okc_k_lines_b cov,
910: okc_k_lines_b bpl,
911: okc_k_items cimbp,
912: okc_k_lines_b btl,
913: okc_k_items cimbt
914: where svl.id = p_cont_line_id
915: and cov.cle_id = svl.id
916: and cov.lse_id in (2,15,20)
917: and bpl.cle_id = cov.id

Line 937: okc_k_items cimbp,

933: p_txn_bill_type_id in number,p_request_date in date) IS
934: select btl.id btl_id
935: from okc_k_lines_b svl,
936: okc_k_lines_b bpl,
937: okc_k_items cimbp,
938: okc_k_lines_b btl,
939: okc_k_items cimbt,
940: oks_k_lines_b ksl
941: where svl.id = p_cont_line_id

Line 939: okc_k_items cimbt,

935: from okc_k_lines_b svl,
936: okc_k_lines_b bpl,
937: okc_k_items cimbp,
938: okc_k_lines_b btl,
939: okc_k_items cimbt,
940: oks_k_lines_b ksl
941: where svl.id = p_cont_line_id
942: and svl.lse_id in (1,14,19)
943: and ksl.cle_id = svl.id