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_CUSTOMER_PROFILES

Line 254: FROM hz_customer_profiles cp

250: trx_limit
251: , cp.credit_checking credit_checking --bug 4967828
252: , cu.credit_usage_rule_set_id
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

Line 293: FROM hz_customer_profiles cp

289: trx_limit
290: , cp.credit_checking credit_checking --bug 4967828
291: , cu.credit_usage_rule_set_id
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

Line 335: FROM hz_customer_profiles cp

331: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
332: trx_limit
333: , cp.credit_checking credit_checking --bug 4967828
334: , cp.party_id
335: FROM hz_customer_profiles cp
336: , hz_cust_profile_amts cpa
337: , hz_hierarchy_nodes hn
338: WHERE cp.party_id = hn.parent_id
339: AND cp.cust_account_id = -1

Line 492: FROM hz_customer_profiles cp

488: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
489: trx_limit
490: , cp.credit_checking credit_checking --bug 4967828
491: , cp.party_id
492: FROM hz_customer_profiles cp
493: , hz_cust_profile_amts cpa
494: WHERE cp.cust_account_id = -1
495: AND cp.site_use_id IS NULL
496: AND cp.party_id = p_party_id

Line 578: FROM hz_customer_profiles cp

574: trx_limit
575: , cp.credit_checking credit_checking --bug 4967828
576: , cu.credit_usage_rule_set_id
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

Line 610: FROM hz_customer_profiles cp

606: trx_limit
607: , cp.credit_checking credit_checking --bug 4967828
608: , cu.credit_usage_rule_set_id
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

Line 896: FROM hz_customer_profiles cp

892:
893: CURSOR cust_global_exposure_csr IS
894: SELECT NVL(curs.global_exposure_flag,'N') global_exposure_flag
895: , curs.credit_usage_rule_set_id credit_usage_rule_set_id
896: FROM hz_customer_profiles cp
897: , hz_cust_profile_amts cpa
898: , hz_credit_usages cu
899: , hz_credit_usage_rule_sets_B curs
900: WHERE cp.cust_account_id = p_entity_id

Line 1204: -- from HZ_CUSTOMER_PROFILES

1200:
1201: ------------------------------------------------------------------------------
1202: -- FUNCTION : GET_Credit_check_Flag PRIVATE
1203: -- COMMENT : Returns the Credit Checking flag
1204: -- from HZ_CUSTOMER_PROFILES
1205: --
1206: --------------------------------------------------------------------------------
1207: FUNCTION GET_Credit_check_Flag
1208: ( p_entity_id IN NUMBER

Line 1226: HZ_CUSTOMER_PROFILES

1222: credit_checking
1223: INTO
1224: l_credit_checking
1225: FROM
1226: HZ_CUSTOMER_PROFILES
1227: WHERE cust_account_id = p_entity_id
1228: AND site_use_id IS NULL ;
1229:
1230: EXCEPTION

Line 1244: HZ_CUSTOMER_PROFILES

1240: credit_checking
1241: INTO
1242: l_credit_checking
1243: FROM
1244: HZ_CUSTOMER_PROFILES
1245: WHERE site_use_id = p_entity_id ;
1246:
1247: EXCEPTION
1248: WHEN NO_DATA_FOUND THEN

Line 1305: FROM hz_customer_profiles cp

1301: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
1302: trx_limit
1303: , cp.credit_checking credit_checking --bug 5071518
1304: , 0 credit_usage_rule_set_id
1305: FROM hz_customer_profiles cp
1306: , hz_cust_profile_amts cpa
1307: WHERE cp.cust_account_id = p_entity_id
1308: AND cp.site_use_id IS NULL
1309: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 1399: FROM hz_customer_profiles cp

1395: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
1396: trx_limit
1397: , cp.credit_checking credit_checking --bug 4582292
1398: , 0 credit_usage_rule_set_id
1399: FROM hz_customer_profiles cp
1400: , hz_cust_profile_amts cpa
1401: WHERE cp.site_use_id = p_entity_id
1402: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
1403: AND cpa.currency_code = p_trx_curr_code

Line 1502: FROM hz_customer_profiles cp

1498: , cp.credit_checking credit_checking --bug 5071518
1499: , curs.credit_usage_rule_set_id
1500: , cu.credit_usage_id
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

Line 1535: FROM hz_customer_profiles cp

1531: trx_limit
1532: , cp.credit_checking credit_checking --bug 5071518
1533: , cu.credit_usage_rule_set_id
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

Line 1688: FROM hz_customer_profiles cp

1684: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
1685: trx_limit
1686: , cp.credit_checking credit_checking --bug 4582292
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

Line 1716: FROM hz_customer_profiles cp

1712: , cpa.trx_credit_limit * ((100 + NVL(cp.tolerance,0))/100)
1713: trx_limit
1714: , cp.credit_checking credit_checking --bug 4582292
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

Line 3054: hz_customer_profiles prf,

3050:
3051: CURSOR party_rule_set_csr IS
3052: SELECT credit_usage_rule_set_id
3053: FROM hz_credit_usages usg,
3054: hz_customer_profiles prf,
3055: hz_cust_profile_amts amt
3056: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3057: AND prf.cust_account_profile_id = amt.cust_account_profile_id
3058: AND amt.currency_code = p_limit_curr_code

Line 3066: hz_customer_profiles prf,

3062:
3063: CURSOR cust_rule_set_csr IS
3064: SELECT credit_usage_rule_set_id
3065: FROM hz_credit_usages usg,
3066: hz_customer_profiles prf,
3067: hz_cust_profile_amts amt
3068: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3069: AND prf.cust_account_profile_id = amt.cust_account_profile_id
3070: AND amt.currency_code = p_limit_curr_code

Line 3077: hz_customer_profiles prf,

3073:
3074: CURSOR site_rule_set_csr IS
3075: SELECT credit_usage_rule_set_id
3076: FROM hz_credit_usages usg,
3077: hz_customer_profiles prf,
3078: hz_cust_profile_amts amt
3079: WHERE usg.cust_acct_profile_amt_id = amt.cust_acct_profile_amt_id
3080: AND prf.cust_account_profile_id = amt.cust_account_profile_id
3081: AND amt.currency_code = p_limit_curr_code