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_CUST_PROFILE_AMTS

Line 255: , hz_cust_profile_amts cpa

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
259: WHERE cp.party_id = hn.parent_id

Line 294: , hz_cust_profile_amts cpa

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
298: WHERE cp.party_id = hn.parent_id

Line 336: , hz_cust_profile_amts cpa

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
340: AND cp.site_use_id IS NULL

Line 493: , hz_cust_profile_amts cpa

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
497: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 579: , hz_cust_profile_amts cpa

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
583: AND cp.site_use_id IS NULL

Line 611: , hz_cust_profile_amts cpa

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
615: AND cp.site_use_id IS NULL

Line 897: , hz_cust_profile_amts cpa

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
901: AND cp.site_use_id IS NULL

Line 1306: , hz_cust_profile_amts cpa

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
1310: AND cpa.currency_code = p_trx_curr_code ;

Line 1400: , hz_cust_profile_amts cpa

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
1404: -- AND cp.credit_checking = 'Y' bug 4582292

Line 1503: , hz_cust_profile_amts cpa

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
1507: WHERE cp.cust_account_id = p_entity_id

Line 1536: , hz_cust_profile_amts cpa

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
1540: WHERE cp.cust_account_id = p_entity_id

Line 1689: , hz_cust_profile_amts cpa

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
1693: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 1717: , hz_cust_profile_amts cpa

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
1721: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 3055: hz_cust_profile_amts amt

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
3059: AND prf.cust_account_id = -1

Line 3067: hz_cust_profile_amts amt

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
3071: AND prf.cust_account_id = p_entity_id

Line 3078: hz_cust_profile_amts amt

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
3082: AND prf.site_use_id = p_entity_id ;