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_PROFILES

Line 914: FROM hz_credit_profiles cp

910:
911: CURSOR dflt_global_exposure_csr IS
912: SELECT NVL(curs.global_exposure_flag,'N') global_exposure_flag
913: , curs.credit_usage_rule_set_id credit_usage_rule_set_id
914: FROM hz_credit_profiles cp
915: , hz_credit_profile_amts cpa
916: , hz_credit_usages cu
917: , hz_credit_usage_rule_sets_B curs
918: WHERE cp.organization_id = p_entity_id

Line 1850: FROM hz_credit_profiles cp

1846: overall_limit
1847: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
1848: trx_limit
1849: , cp.credit_checking
1850: FROM hz_credit_profiles cp
1851: , hz_credit_profile_amts cpa
1852: WHERE cp.organization_id = G_ORG_ID
1853: AND cp.credit_profile_id = cpa.credit_profile_id
1854: AND cpa.currency_code = p_trx_curr_code

Line 1949: FROM hz_credit_profiles cp

1945: trx_limit
1946: , cp.credit_checking
1947: , cu.credit_usage_rule_set_id
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

Line 1986: FROM hz_credit_profiles cp

1982: trx_limit
1983: , cp.credit_checking
1984: , cu.credit_usage_rule_set_id
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

Line 2121: FROM hz_credit_profiles cp

2117: CURSOR single_Item_limit_csr IS
2118: SELECT cpa.currency_code limit_curr_code
2119: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2120: trx_limit
2121: FROM hz_credit_profiles cp
2122: , hz_credit_profile_amts cpa
2123: WHERE cp.item_category_id = p_category_id
2124: AND cp.credit_profile_id = cpa.credit_profile_id
2125: AND cpa.currency_code = p_trx_curr_code

Line 2193: FROM hz_credit_profiles cp

2189: SELECT cpa.currency_code limit_curr_code
2190: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2191: trx_limit
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

Line 2221: FROM hz_credit_profiles cp

2217: SELECT cpa.currency_code limit_curr_code
2218: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2219: trx_limit
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

Line 2382: hz_credit_profiles cp

2378: CURSOR C_SELECT_CTG_CREDIT_PROFILE IS
2379: SELECT
2380: cp.credit_profile_id
2381: FROM
2382: hz_credit_profiles cp
2383: WHERE cp.item_category_id is NOT NULL
2384: AND cp.enable_flag = 'Y'
2385: AND ( TRUNC(SYSDATE) BETWEEN
2386: TRUNC( NVL(cp.effective_date_from, SYSDATE ) )

Line 3092: hz_credit_profiles prf,

3088: --------------------------------------------------------
3089: CURSOR dflt_rule_set_csr IS
3090: SELECT credit_usage_rule_set_id
3091: FROM hz_credit_usages usg,
3092: hz_credit_profiles prf,
3093: hz_credit_profile_amts amt
3094: WHERE usg.credit_profile_amt_id = amt.credit_profile_amt_id
3095: AND prf.credit_profile_id = amt.credit_profile_id
3096: AND amt.currency_code = p_limit_curr_code