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 355: okc_rule_groups_b rgp

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

Line 1387: Okc_rule_groups_B rgp

1383: -- Receipt Method Or Payment method
1384: CURSOR cust_pmth_csr ( p_khr_id NUMBER ) IS
1385: SELECT object1_id1
1386: FROM OKC_RULES_B rul,
1387: Okc_rule_groups_B rgp
1388: WHERE rul.rgp_id = rgp.id AND
1389: rgp.rgd_code = 'LABILL' AND
1390: rgp.dnz_chr_id = rgp.chr_id AND
1391: rul.rule_information_category = 'LAPMTH' AND

Line 1397: Okc_rule_groups_B rgp

1393:
1394: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1395: SELECT object1_id1
1396: FROM OKC_RULES_B rul,
1397: Okc_rule_groups_B rgp
1398: WHERE rul.rgp_id = rgp.id AND
1399: rgp.rgd_code = 'LABILL' AND
1400: rgp.cle_id = p_kle_id AND
1401: rul.rule_information_category = 'LAPMTH' AND

Line 1409: , Okc_rule_groups_B rgp

1405: FROM okc_k_lines_b cle
1406: , okc_k_items_v item
1407: , okc_k_lines_b linked_asset
1408: , OKC_RULES_B rul
1409: , Okc_rule_groups_B rgp
1410: WHERE cle.dnz_chr_id = p_khr_id AND
1411: cle.id = p_kle_id AND
1412: cle.chr_id IS NULL AND
1413: cle.id = item.cle_id AND

Line 1438: Okc_rule_groups_B rgp

1434:
1435: CURSOR cust_bank_csr ( p_khr_id NUMBER ) IS
1436: SELECT object1_id1
1437: FROM OKC_RULES_B rul,
1438: Okc_rule_groups_B rgp
1439: WHERE rul.rgp_id = rgp.id AND
1440: rgp.rgd_code = 'LABILL' AND
1441: rgp.dnz_chr_id = rgp.chr_id AND
1442: rul.rule_information_category = 'LABACC' AND

Line 1448: Okc_rule_groups_B rgp

1444:
1445: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1446: SELECT object1_id1
1447: FROM OKC_RULES_B rul,
1448: Okc_rule_groups_B rgp
1449: WHERE rul.rgp_id = rgp.id AND
1450: rgp.cle_id = p_kle_id AND
1451: rgp.rgd_code = 'LABILL' AND
1452: rul.rule_information_category = 'LABACC' AND

Line 1460: , Okc_rule_groups_B rgp

1456: FROM okc_k_lines_b cle
1457: , okc_k_items_v item
1458: , okc_k_lines_b linked_asset
1459: , OKC_RULES_B rul
1460: , Okc_rule_groups_B rgp
1461: WHERE cle.dnz_chr_id = p_khr_id AND
1462: cle.id = p_kle_id AND
1463: cle.chr_id IS NULL AND
1464: cle.id = item.cle_id AND

Line 1576: FROM okc_rule_groups_b A,

1572: -- AR. Bug 4525643
1573: -- -------------------------------------------
1574: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
1575: SELECT Rule_information1 PRIVATE_LABEL
1576: FROM okc_rule_groups_b A,
1577: okc_rules_b B
1578: WHERE A.DNZ_CHR_ID = CP_KHR_ID
1579: AND A.rgd_code = 'LALABL'
1580: AND A.id = B.rgp_id

Line 2711: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2707: AND khs.ste_code = 'ACTIVE'
2708: AND kle.id (+) = stm.kle_id
2709: AND kls.code (+) = kle.sts_code
2710: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2711: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2712: , okc_rules_b rul
2713: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2714: AND rgp.cle_id = kle.id
2715: AND rgp.rgd_code = 'LAASTX'

Line 2771: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2767: AND khs.ste_code = 'ACTIVE'
2768: AND kle.id (+) = stm.kle_id
2769: AND kls.code (+) = kle.sts_code
2770: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2771: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2772: , okc_rules_b rul
2773: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2774: AND rgp.cle_id = kle.id
2775: AND rgp.rgd_code = 'LAASTX'

Line 2935: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2931: AND khs.ste_code = 'ACTIVE'
2932: AND kle.id (+) = stm.kle_id
2933: AND kls.code (+) = kle.sts_code
2934: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2935: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2936: , okc_rules_b rul
2937: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2938: AND rgp.cle_id = kle.id
2939: AND rgp.rgd_code = 'LAASTX'

Line 2995: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

2991: AND khs.ste_code = 'ACTIVE'
2992: AND kle.id (+) = stm.kle_id
2993: AND kls.code (+) = kle.sts_code
2994: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2995: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2996: , okc_rules_b rul
2997: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2998: AND rgp.cle_id = kle.id
2999: AND rgp.rgd_code = 'LAASTX'

Line 3167: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

3163: -- AND khs.ste_code = 'ACTIVE'
3164: AND kle.id (+) = stm.kle_id
3165: AND kls.code (+) = kle.sts_code
3166: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED', 'EXPIRED') -- Bug# 7475594
3167: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3168: , okc_rules_b rul
3169: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3170: AND rgp.cle_id = kle.id
3171: AND rgp.rgd_code = 'LAASTX'

Line 3230: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp

3226: AND khs.ste_code = 'ACTIVE'
3227: AND kle.id (+) = stm.kle_id
3228: AND kls.code (+) = kle.sts_code
3229: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
3230: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3231: , okc_rules_b rul
3232: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3233: AND rgp.cle_id = kle.id
3234: AND rgp.rgd_code = 'LAASTX'