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_STREAM_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 353: okc_rule_groups_b rgp

349: -- Derive print lead days from the rules
350: CURSOR c_lead_days(p_khr_id IN NUMBER) IS
351: SELECT rule_information3
352: FROM okc_rules_b rule,
353: okc_rule_groups_b rgp
354: WHERE rgp.id = rule.rgp_id
355: AND rgp.dnz_chr_id = p_khr_id
356: AND rgd_code = 'LABILL'
357: AND rule_information_category = 'LAINVD';

Line 1325: Okc_rule_groups_B rgp

1321: -- Receipt Method Or Payment method
1322: CURSOR cust_pmth_csr ( p_khr_id NUMBER ) IS
1323: SELECT object1_id1
1324: FROM OKC_RULES_B rul,
1325: Okc_rule_groups_B rgp
1326: WHERE rul.rgp_id = rgp.id AND
1327: rgp.rgd_code = 'LABILL' AND
1328: rgp.dnz_chr_id = rgp.chr_id AND
1329: rul.rule_information_category = 'LAPMTH' AND

Line 1335: Okc_rule_groups_B rgp

1331:
1332: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1333: SELECT object1_id1
1334: FROM OKC_RULES_B rul,
1335: Okc_rule_groups_B rgp
1336: WHERE rul.rgp_id = rgp.id AND
1337: rgp.rgd_code = 'LABILL' AND
1338: rgp.cle_id = p_kle_id AND
1339: rul.rule_information_category = 'LAPMTH' AND

Line 1347: , Okc_rule_groups_B rgp

1343: FROM okc_k_lines_b cle
1344: , okc_k_items_v item
1345: , okc_k_lines_b linked_asset
1346: , OKC_RULES_B rul
1347: , Okc_rule_groups_B rgp
1348: WHERE cle.dnz_chr_id = p_khr_id AND
1349: cle.id = p_kle_id AND
1350: cle.chr_id IS NULL AND
1351: cle.id = item.cle_id AND

Line 1376: Okc_rule_groups_B rgp

1372:
1373: CURSOR cust_bank_csr ( p_khr_id NUMBER ) IS
1374: SELECT object1_id1
1375: FROM OKC_RULES_B rul,
1376: Okc_rule_groups_B rgp
1377: WHERE rul.rgp_id = rgp.id AND
1378: rgp.rgd_code = 'LABILL' AND
1379: rgp.dnz_chr_id = rgp.chr_id AND
1380: rul.rule_information_category = 'LABACC' AND

Line 1386: Okc_rule_groups_B rgp

1382:
1383: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1384: SELECT object1_id1
1385: FROM OKC_RULES_B rul,
1386: Okc_rule_groups_B rgp
1387: WHERE rul.rgp_id = rgp.id AND
1388: rgp.cle_id = p_kle_id AND
1389: rgp.rgd_code = 'LABILL' AND
1390: rul.rule_information_category = 'LABACC' AND

Line 1398: , Okc_rule_groups_B rgp

1394: FROM okc_k_lines_b cle
1395: , okc_k_items_v item
1396: , okc_k_lines_b linked_asset
1397: , OKC_RULES_B rul
1398: , Okc_rule_groups_B rgp
1399: WHERE cle.dnz_chr_id = p_khr_id AND
1400: cle.id = p_kle_id AND
1401: cle.chr_id IS NULL AND
1402: cle.id = item.cle_id AND

Line 1513: FROM okc_rule_groups_b A,

1509: -- AR. Bug 4525643
1510: -- -------------------------------------------
1511: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
1512: SELECT Rule_information1 PRIVATE_LABEL
1513: FROM okc_rule_groups_b A,
1514: okc_rules_b B
1515: WHERE A.DNZ_CHR_ID = CP_KHR_ID
1516: AND A.rgd_code = 'LALABL'
1517: AND A.id = B.rgp_id

Line 2527: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2523: AND khs.ste_code = 'ACTIVE'
2524: AND kle.id (+) = stm.kle_id
2525: AND kls.code (+) = kle.sts_code
2526: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2527: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2528: , okc_rules_b rul
2529: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2530: AND rgp.cle_id = kle.id
2531: AND rgp.rgd_code = 'LAASTX'

Line 2587: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2583: AND khs.ste_code = 'ACTIVE'
2584: AND kle.id (+) = stm.kle_id
2585: AND kls.code (+) = kle.sts_code
2586: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2587: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2588: , okc_rules_b rul
2589: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2590: AND rgp.cle_id = kle.id
2591: AND rgp.rgd_code = 'LAASTX'

Line 2748: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2744: AND khs.ste_code = 'ACTIVE'
2745: AND kle.id (+) = stm.kle_id
2746: AND kls.code (+) = kle.sts_code
2747: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2748: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2749: , okc_rules_b rul
2750: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2751: AND rgp.cle_id = kle.id
2752: AND rgp.rgd_code = 'LAASTX'

Line 2808: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2804: AND khs.ste_code = 'ACTIVE'
2805: AND kle.id (+) = stm.kle_id
2806: AND kls.code (+) = kle.sts_code
2807: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2808: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2809: , okc_rules_b rul
2810: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2811: AND rgp.cle_id = kle.id
2812: AND rgp.rgd_code = 'LAASTX'

Line 2977: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2973: AND khs.ste_code = 'ACTIVE'
2974: AND kle.id (+) = stm.kle_id
2975: AND kls.code (+) = kle.sts_code
2976: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2977: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2978: , okc_rules_b rul
2979: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2980: AND rgp.cle_id = kle.id
2981: AND rgp.rgd_code = 'LAASTX'

Line 3040: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

3036: AND khs.ste_code = 'ACTIVE'
3037: AND kle.id (+) = stm.kle_id
3038: AND kls.code (+) = kle.sts_code
3039: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
3040: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3041: , okc_rules_b rul
3042: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3043: AND rgp.cle_id = kle.id
3044: AND rgp.rgd_code = 'LAASTX'