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 HZ_CUSTOMER_PROFILES

Line 774: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP,

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,
775: RA_TERMS TERM where KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
776: ),0)
777: )
778:

Line 961: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr

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
962: WHERE opp.khr_id = khr.id AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
963: ),0)
964: --Bug# 7701159 - Susbtitute SQL query for PL//*/*SQL call
965: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)

Line 968: HZ_CUSTOMER_PROFILES CP,

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
972: RGP.ID = RULE.RGP_ID

Line 1372: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr

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
1373: WHERE opp.khr_id = khr.id AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
1374: ),0)
1375: --Bug# 7701159 - Susbtitute SQL query for PL/SQL call
1376: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)

Line 1379: HZ_CUSTOMER_PROFILES CP,

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
1383: RGP.ID = RULE.RGP_ID