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_SPLIT_CONTRACT_PVT dependencies on OKC_RULES_B

Line 2460: okc_rules_b rl,

2456: SELECT rl.id,
2457: rl.rule_information6 payment_amount,
2458: rl.rule_information2 rl_date
2459: FROM okc_rule_groups_b rg,
2460: okc_rules_b rl,
2461: okc_k_lines_v cle,
2462: okc_line_styles_b lse
2463: WHERE cle.dnz_chr_id = p_chr_id
2464: AND cle.id = p_cle_id

Line 2489: okc_rules_b rl,

2485: IS
2486: SELECT rl.id,
2487: rl.rule_information6 payment_amount
2488: FROM okc_rule_groups_b rg,
2489: okc_rules_b rl,
2490: okc_k_lines_v cle,
2491: okc_line_styles_b lse
2492: WHERE cle.dnz_chr_id = p_chr_id
2493: AND cle.id = p_cle_id

Line 2519: okc_rules_b rl,

2515: IS
2516: SELECT rl.id,
2517: cle.currency_code
2518: FROM okc_rule_groups_b rg,
2519: okc_rules_b rl,
2520: okc_k_lines_v cle,
2521: okc_line_styles_b lse
2522: WHERE cle.dnz_chr_id = p_chr_id
2523: AND cle.id = p_cle_id

Line 2536: p_rgp_cat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

2532: AND rg.rgd_code = 'LAFEXP'
2533: AND rl.rule_information_category = 'LAFEXP';
2534:
2535: CURSOR get_expense_service_rule_info( p_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2536: p_rgp_cat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2537: p_chr_id NUMBER,
2538: p_cle_id NUMBER ) IS
2539: SELECT crl.RULE_INFORMATION1,
2540: crl.RULE_INFORMATION2

Line 2542: OKC_RULES_B crl

2538: p_cle_id NUMBER ) IS
2539: SELECT crl.RULE_INFORMATION1,
2540: crl.RULE_INFORMATION2
2541: FROM OKC_RULE_GROUPS_B crg,
2542: OKC_RULES_B crl
2543: WHERE crl.rgp_id = crg.id
2544: AND crg.RGD_CODE = p_rgd_code
2545: AND crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
2546: AND crg.dnz_chr_id = p_chr_id

Line 2585: p_rgp_cat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

2581: AND klfv.dnz_chr_id = p_new_chr_id);
2582:
2583:
2584: CURSOR get_service_line_payments( p_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2585: p_rgp_cat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2586: p_chr_id NUMBER,
2587: p_cle_id NUMBER ) IS
2588: SELECT rl.id,
2589: rl.rule_information2,

Line 2596: okc_rules_b rl,

2592: rl.rule_information7,
2593: rl.rule_information8,
2594: cle.currency_code
2595: FROM okc_rule_groups_b rg,
2596: okc_rules_b rl,
2597: okc_k_lines_v cle,
2598: okc_line_styles_b lse
2599: WHERE cle.dnz_chr_id = p_chr_id
2600: AND cle.id = p_cle_id

Line 2613: OKC_RULES_B crl

2609: /*SELECT crl.id,
2610: crl.RULE_INFORMATION3,
2611: crl.RULE_INFORMATION6
2612: FROM OKC_RULE_GROUPS_B crg,
2613: OKC_RULES_B crl
2614: WHERE crl.rgp_id = crg.id
2615: and crg.RGD_CODE = p_rgd_code
2616: and crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
2617: and crg.dnz_chr_id = p_chr_id