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.OE_CREDIT_CHECK_UTIL dependencies on HZ_CREDIT_USAGE_RULES

Line 257: , hz_credit_usage_rules cur

253: , cp.party_id
254: FROM hz_customer_profiles cp
255: , hz_cust_profile_amts cpa
256: , hz_credit_usages cu
257: , hz_credit_usage_rules cur
258: , hz_hierarchy_nodes hn
259: WHERE cp.party_id = hn.parent_id
260: AND cp.cust_account_id = -1
261: AND cp.site_use_id IS NULL

Line 296: , hz_credit_usage_rules cur

292: , cp.party_id
293: FROM hz_customer_profiles cp
294: , hz_cust_profile_amts cpa
295: , hz_credit_usages cu
296: , hz_credit_usage_rules cur
297: , hz_hierarchy_nodes hn
298: WHERE cp.party_id = hn.parent_id
299: AND cp.cust_account_id = -1
300: AND cp.site_use_id IS NULL

Line 308: FROM hz_credit_usage_rules cur2

304: AND NVL(TRUNC(cpa.expiration_date) , TRUNC(SYSDATE) )
305: <= TRUNC(SYSDATE)
306: AND cur.include_all_flag = 'Y'
307: AND NOT EXISTS ( SELECT 'EXCLUDE'
308: FROM hz_credit_usage_rules cur2
309: WHERE cu.credit_usage_rule_set_id
310: = cur2.credit_usage_rule_set_id
311: AND cur2.exclude_flag = 'Y'
312: AND cur2.usage_type = 'CURRENCY'

Line 581: , hz_credit_usage_rules cur

577: , cp.party_id
578: FROM hz_customer_profiles cp
579: , hz_cust_profile_amts cpa
580: , hz_credit_usages cu
581: , hz_credit_usage_rules cur
582: WHERE cp.cust_account_id = -1
583: AND cp.site_use_id IS NULL
584: AND cp.party_id = p_party_id
585: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 613: , hz_credit_usage_rules cur

609: , cp.party_id
610: FROM hz_customer_profiles cp
611: , hz_cust_profile_amts cpa
612: , hz_credit_usages cu
613: , hz_credit_usage_rules cur
614: WHERE cp.cust_account_id = -1
615: AND cp.site_use_id IS NULL
616: AND cp.party_id = p_party_id
617: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 625: FROM hz_credit_usage_rules cur2

621: ) <= TRUNC(SYSDATE)
622: AND cur.include_all_flag = 'Y'
623: -- AND NVL(cp.credit_checking,'Y') = 'Y' --bug 4967828
624: AND NOT EXISTS ( SELECT 'EXCLUDE'
625: FROM hz_credit_usage_rules cur2
626: WHERE cu.credit_usage_rule_set_id
627: = cur2.credit_usage_rule_set_id
628: AND cur2.exclude_flag = 'Y'
629: AND cur2.usage_type = 'CURRENCY'

Line 1505: , hz_credit_usage_rules cur

1501: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1502: FROM hz_customer_profiles cp
1503: , hz_cust_profile_amts cpa
1504: , hz_credit_usages cu
1505: , hz_credit_usage_rules cur
1506: , hz_credit_usage_rule_sets_B curs
1507: WHERE cp.cust_account_id = p_entity_id
1508: AND cp.site_use_id IS NULL
1509: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 1538: , hz_credit_usage_rules cur

1534: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1535: FROM hz_customer_profiles cp
1536: , hz_cust_profile_amts cpa
1537: , hz_credit_usages cu
1538: , hz_credit_usage_rules cur
1539: , hz_credit_usage_rule_sets_B curs
1540: WHERE cp.cust_account_id = p_entity_id
1541: AND cp.site_use_id IS NULL
1542: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 1551: FROM hz_credit_usage_rules cur2

1547: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
1548: ) <= TRUNC(SYSDATE)
1549: AND cur.include_all_flag = 'Y'
1550: AND NOT EXISTS ( SELECT 'EXCLUDE'
1551: FROM hz_credit_usage_rules cur2
1552: WHERE cu.credit_usage_rule_set_id
1553: = cur2.credit_usage_rule_set_id
1554: AND cur2.exclude_flag = 'Y'
1555: AND cur2.usage_type = 'CURRENCY'

Line 1691: , hz_credit_usage_rules cur

1687: , cu.credit_usage_rule_set_id
1688: FROM hz_customer_profiles cp
1689: , hz_cust_profile_amts cpa
1690: , hz_credit_usages cu
1691: , hz_credit_usage_rules cur
1692: WHERE cp.site_use_id = p_entity_id
1693: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1694: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id
1695: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 1719: , hz_credit_usage_rules cur

1715: , cu.credit_usage_rule_set_id
1716: FROM hz_customer_profiles cp
1717: , hz_cust_profile_amts cpa
1718: , hz_credit_usages cu
1719: , hz_credit_usage_rules cur
1720: WHERE cp.site_use_id = p_entity_id
1721: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1722: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id
1723: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 1729: FROM hz_credit_usage_rules cur2

1725: ) <= TRUNC(SYSDATE)
1726: -- AND cp.credit_checking = 'Y' bug 4582292
1727: AND cur.include_all_flag = 'Y'
1728: AND NOT EXISTS ( SELECT 'EXCLUDE'
1729: FROM hz_credit_usage_rules cur2
1730: WHERE cu.credit_usage_rule_set_id
1731: = cur2.credit_usage_rule_set_id
1732: AND cur2.exclude_flag = 'Y'
1733: AND cur2.usage_type = 'CURRENCY'

Line 1952: , hz_credit_usage_rules cur

1948: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1949: FROM hz_credit_profiles cp
1950: , hz_credit_profile_amts cpa
1951: , hz_credit_usages cu
1952: , hz_credit_usage_rules cur
1953: , hz_credit_usage_rule_sets_B curs
1954: WHERE cp.organization_id = G_ORG_ID
1955: AND cp.credit_profile_id = cpa.credit_profile_id
1956: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id

Line 1989: , hz_credit_usage_rules cur

1985: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1986: FROM hz_credit_profiles cp
1987: , hz_credit_profile_amts cpa
1988: , hz_credit_usages cu
1989: , hz_credit_usage_rules cur
1990: , hz_credit_usage_rule_sets_B curs
1991: WHERE cp.organization_id = G_ORG_ID
1992: AND cp.credit_profile_id = cpa.credit_profile_id
1993: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id

Line 2006: FROM hz_credit_usage_rules cur2

2002: )
2003: AND cur.include_all_flag = 'Y'
2004: AND cp.credit_checking = 'Y'
2005: AND NOT EXISTS ( SELECT 'EXCLUDE'
2006: FROM hz_credit_usage_rules cur2
2007: WHERE cu.credit_usage_rule_set_id
2008: = cur2.credit_usage_rule_set_id
2009: AND cur2.exclude_flag = 'Y'
2010: AND cur2.usage_type = 'CURRENCY'

Line 2196: , hz_credit_usage_rules cur

2192: , cu.credit_usage_rule_set_id
2193: FROM hz_credit_profiles cp
2194: , hz_credit_profile_amts cpa
2195: , hz_credit_usages cu
2196: , hz_credit_usage_rules cur
2197: WHERE cp.credit_profile_id = cpa.credit_profile_id
2198: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
2199: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id
2200: AND cp.enable_flag = 'Y'

Line 2224: , hz_credit_usage_rules cur

2220: , cu.credit_usage_rule_set_id
2221: FROM hz_credit_profiles cp
2222: , hz_credit_profile_amts cpa
2223: , hz_credit_usages cu
2224: , hz_credit_usage_rules cur
2225: WHERE cp.credit_profile_id = cpa.credit_profile_id
2226: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id
2227: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id
2228: AND cp.enable_flag = 'Y'

Line 2236: FROM hz_credit_usage_rules cur2

2232: AND TRUNC( NVL(cp.effective_date_to, SYSDATE ) )
2233: )
2234: AND cur.include_all_flag = 'Y'
2235: AND NOT EXISTS ( SELECT 'EXCLUDE'
2236: FROM hz_credit_usage_rules cur2
2237: WHERE cu.credit_usage_rule_set_id
2238: = cur2.credit_usage_rule_set_id
2239: AND cur2.exclude_flag = 'Y'
2240: AND cur2.usage_type = 'CURRENCY'

Line 3108: FROM hz_credit_usage_rules

3104: --------------------------------------------------------
3105:
3106: CURSOR include_all_csr (c_credit_usage_rule_set_id IN NUMBER) IS
3107: SELECT 'X'
3108: FROM hz_credit_usage_rules
3109: WHERE credit_usage_rule_set_id = c_credit_usage_rule_set_id
3110: AND usage_type = 'CURRENCY'
3111: AND include_all_flag = 'Y';
3112:

Line 3120: FROM hz_credit_usage_rules cur

3116: --------------------------------------------------------
3117:
3118: CURSOR incl_curr_csr (c_credit_usage_rule_set_id IN NUMBER) IS
3119: SELECT user_code
3120: FROM hz_credit_usage_rules cur
3121: WHERE cur.credit_usage_rule_set_id = c_credit_usage_rule_set_id
3122: AND cur.usage_type = 'CURRENCY'
3123: AND cur.user_code IS NOT NULL
3124: AND NVL(cur.exclude_flag,'N') = 'N';

Line 3133: FROM hz_credit_usage_rules cur

3129: --------------------------------------------------------
3130:
3131: CURSOR excl_curr_csr (c_credit_usage_rule_set_id IN NUMBER) IS
3132: SELECT user_code
3133: FROM hz_credit_usage_rules cur
3134: WHERE cur.credit_usage_rule_set_id = c_credit_usage_rule_set_id
3135: AND cur.usage_type = 'CURRENCY'
3136: AND cur.user_code IS NOT NULL
3137: AND cur.exclude_flag = 'Y';