APPS.OE_CREDIT_CHECK_RPT dependencies on HZ_CUST_PROFILE_AMTS

Line 1811: , hz_cust_profile_amts cpa

1807: cpa.currency_code party_currency_code
1808: , cpa.overall_credit_limit party_overall_limit
1809: FROM
1810: hz_customer_profiles cp
1811: , hz_cust_profile_amts cpa
1812: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1813: AND cp.site_use_id IS NULL
1814: AND cp.cust_account_id=-1
1815: AND cp.STATUS='A' --14699527

Line 1866: , hz_cust_profile_amts cpa

1862: cpa.currency_code cust_currency_code
1863: , cpa.overall_credit_limit cust_overall_limit
1864: FROM
1865: hz_customer_profiles cp
1866: , hz_cust_profile_amts cpa
1867: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1868: AND cp.site_use_id IS NULL
1869: AND cp.STATUS='A'--14699527
1870: AND cp.cust_account_id=p_customer_id;

Line 1897: , hz_cust_profile_amts cpa

1893: cpa.currency_code site_currency_code
1894: , cpa.overall_credit_limit site_overall_limit
1895: FROM
1896: hz_customer_profiles cp
1897: , hz_cust_profile_amts cpa
1898: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
1899: AND cp.site_use_id =p_site_id
1900: AND cp.STATUS='A' --14699527
1901: AND cp.cust_account_id=p_customer_id;

Line 2239: , hz_cust_profile_amts cpa

2235: SELECT COUNT(*)
2236: INTO l_prof_count
2237: FROM
2238: hz_customer_profiles cp
2239: , hz_cust_profile_amts cpa
2240: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2241: AND cp.site_use_id IS NULL
2242: AND cp.cust_account_id=-1
2243: AND cp.STATUS='A' --14699527

Line 2579: , hz_cust_profile_amts cpa

2575: SELECT COUNT(*)
2576: INTO l_prof_count
2577: FROM
2578: hz_customer_profiles cp
2579: , hz_cust_profile_amts cpa
2580: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2581: AND cp.site_use_id IS NULL
2582: AND cp.cust_account_id=-1
2583: AND cp.STATUS='A' --14699527

Line 2877: , hz_cust_profile_amts cpa

2873: SELECT COUNT(*)
2874: INTO l_prof_count
2875: FROM
2876: hz_customer_profiles cp
2877: , hz_cust_profile_amts cpa
2878: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
2879: AND cp.site_use_id IS NULL
2880: AND cp.STATUS ='A' --14699527
2881: AND cp.cust_account_id=party_cust_csr_rec.customer_id;

Line 3182: , hz_cust_profile_amts cpa

3178: SELECT COUNT(*)
3179: INTO l_prof_count
3180: FROM
3181: hz_customer_profiles cp
3182: , hz_cust_profile_amts cpa
3183: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3184: AND cp.site_use_id IS NULL
3185: AND cp.cust_account_id=-1
3186: AND cp.STATUS='A' --14699527

Line 3480: , hz_cust_profile_amts cpa

3476: SELECT COUNT(*)
3477: INTO l_prof_count
3478: FROM
3479: hz_customer_profiles cp
3480: , hz_cust_profile_amts cpa
3481: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3482: AND cp.site_use_id IS NULL
3483: AND cp.STATUS='A' --14699527
3484: AND cp.cust_account_id=party_cust_csr_rec.customer_id;

Line 3991: , hz_cust_profile_amts cpa

3987: SELECT COUNT(*)
3988: INTO l_prof_count
3989: FROM
3990: hz_customer_profiles cp
3991: , hz_cust_profile_amts cpa
3992: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
3993: AND cp.site_use_id IS NULL
3994: AND cp.STATUS='A' --14699527
3995: AND cp.cust_account_id=cust_csr_rec.customer_id;

Line 4272: , hz_cust_profile_amts cpa

4268: SELECT COUNT(*)
4269: INTO l_prof_count1
4270: FROM
4271: hz_customer_profiles cp
4272: , hz_cust_profile_amts cpa
4273: WHERE cp.cust_account_profile_id=cpa.cust_account_profile_id
4274: AND cp.site_use_id =site_csr_rec.site_id
4275: AND cp.STATUS='A' --14699527
4276: AND cp.cust_account_id=cust_csr_rec.customer_id;