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

Line 770: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP

766: -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636) + fixes for bug 5634652 logic to check for print lead days
767: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) +
768: --Bug# 7701159 - Susbtitute SQL query for PL/SQL call
769: NVL( NVL(
770: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP
771: WHERE RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
772: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
773: ),
774: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP,

Line 957: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP, okc_k_headers_b khr

953: (p_date_from is null)
954: ) AND
955: STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) +
956: NVL( NVL(
957: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP, okc_k_headers_b khr
958: WHERE opp.khr_id = khr.id AND RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
959: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
960: ),
961: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr

Line 967: OKC_RULE_GROUPS_B RGP,

963: ),0)
964: --Bug# 7701159 - Susbtitute SQL query for PL//*/*SQL call
965: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)
966: FROM OKC_RULES_B RULE,
967: OKC_RULE_GROUPS_B RGP,
968: HZ_CUSTOMER_PROFILES CP,
969: RA_TERMS TERM
970: ,okc_k_headers_b khr
971: WHERE opp.khr_id = khr.id and

Line 1368: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP, okc_k_headers_b khr

1364: SET volume = volume* (SELECT CEIL((lp_date_to
1365: -- rmunjulu R12 Forward Port bug 5634652 logic to check print lead days
1366: +
1367: NVL( NVL(
1368: (SELECT RULE.RULE_INFORMATION3 FROM OKC_RULES_B RULE, OKC_RULE_GROUPS_B RGP, okc_k_headers_b khr
1369: WHERE opp.khr_id = khr.id AND RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
1370: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
1371: ),
1372: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr

Line 1378: OKC_RULE_GROUPS_B RGP,

1374: ),0)
1375: --Bug# 7701159 - Susbtitute SQL query for PL/SQL call
1376: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)
1377: FROM OKC_RULES_B RULE,
1378: OKC_RULE_GROUPS_B RGP,
1379: HZ_CUSTOMER_PROFILES CP,
1380: RA_TERMS TERM
1381: ,okc_k_headers_b khr
1382: WHERE opp.khr_id = khr.id and