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_RPT dependencies on HZ_CUSTOMER_PROFILES

Line 259: FROM HZ_CUSTOMER_PROFILES HCP,

255: IF p_cust_prof_class_name_from = p_cust_prof_class_name_to THEN
256: --14699527 appended HCP.STATUS=''A'' condition
257: v_cust_prof_class_clause := 'AND EXISTS
258: (SELECT HCP.cust_account_id
259: FROM HZ_CUSTOMER_PROFILES HCP,
260: HZ_CUST_PROFILE_CLASSES HCPC
261: WHERE HCP.profile_class_id = HCPC.profile_class_id
262: AND HCP.cust_account_id = OH.sold_to_org_id
263: AND HCP.STATUS=''A''

Line 269: FROM HZ_CUSTOMER_PROFILES HCP,

265: ELSIF p_cust_prof_class_name_to IS NULL THEN
266: --14699527 appended HCP.STATUS=''A'' condition
267: v_cust_prof_class_clause := 'AND EXISTS
268: (SELECT HCP.cust_account_id
269: FROM HZ_CUSTOMER_PROFILES HCP,
270: HZ_CUST_PROFILE_CLASSES HCPC
271: WHERE HCP.profile_class_id = HCPC.profile_class_id
272: AND HCP.cust_account_id = OH.sold_to_org_id
273: AND HCP.STATUS=''A''

Line 279: FROM HZ_CUSTOMER_PROFILES HCP,

275: ELSIF p_cust_prof_class_name_from IS NULL THEN
276: --14699527 appended HCP.STATUS=''A'' condition
277: v_cust_prof_class_clause := 'AND EXISTS
278: (SELECT HCP.cust_account_id
279: FROM HZ_CUSTOMER_PROFILES HCP,
280: HZ_CUST_PROFILE_CLASSES HCPC
281: WHERE HCP.profile_class_id = HCPC.profile_class_id
282: AND HCP.cust_account_id = OH.sold_to_org_id
283: AND HCP.STATUS=''A''

Line 289: FROM HZ_CUSTOMER_PROFILES HCP,

285: ELSE
286: --14699527 appended HCP.STATUS=''A'' condition
287: v_cust_prof_class_clause := 'AND EXISTS
288: (SELECT HCP.cust_account_id
289: FROM HZ_CUSTOMER_PROFILES HCP,
290: HZ_CUST_PROFILE_CLASSES HCPC
291: WHERE HCP.profile_class_id = HCPC.profile_class_id
292: AND HCP.cust_account_id = OH.sold_to_org_id
293: AND HCP.STATUS=''A''

Line 1810: hz_customer_profiles cp

1806: SELECT
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

Line 1852: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

1848: AND NVL(p_customer_name_high, party.party_name)
1849: AND c.account_number BETWEEN NVL(p_cust_number_low, c.account_number )
1850: AND NVL(p_cust_number_high, c.account_number )
1851: AND c.cust_account_id IN (SELECT cp.cust_account_id
1852: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
1853: WHERE cp.profile_class_id=cpc.profile_class_id
1854: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
1855: AND NVL(p_prof_class_high, cpc.name));
1856: */

Line 1865: hz_customer_profiles cp

1861: SELECT
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

Line 1896: hz_customer_profiles cp

1892: SELECT
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

Line 2238: hz_customer_profiles cp

2234: -----check if the party has any credit profiles
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

Line 2578: hz_customer_profiles cp

2574: -----check if the party has any credit profiles
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

Line 2876: hz_customer_profiles cp

2872: -----check if the customer has any credit profiles
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

Line 3181: hz_customer_profiles cp

3177: -----check if the party has any credit profiles
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

Line 3479: hz_customer_profiles cp

3475: -----check if the customer has any credit profiles
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

Line 3596: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3592: AND NVL(p_customer_name_high, party.party_name)
3593: AND c.account_number BETWEEN p_cust_number_low
3594: AND NVL(p_cust_number_high, c.account_number )
3595: AND c.cust_account_id IN (SELECT cp.cust_account_id
3596: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3597: WHERE cp.profile_class_id=cpc.profile_class_id
3598: AND cp.STATUS='A' --14699527
3599: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3600: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3619: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3615: AND party.party_name <= p_customer_name_high
3616: AND c.account_number BETWEEN p_cust_number_low
3617: AND NVL(p_cust_number_high, c.account_number )
3618: AND c.cust_account_id IN (SELECT cp.cust_account_id
3619: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3620: WHERE cp.profile_class_id=cpc.profile_class_id
3621: AND cp.STATUS='A' --14699527
3622: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3623: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3642: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3638: AND party.party_name BETWEEN p_customer_name_low
3639: AND NVL(p_customer_name_high, party.party_name)
3640: AND c.account_number <=p_cust_number_high
3641: AND c.cust_account_id IN (SELECT cp.cust_account_id
3642: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3643: WHERE cp.profile_class_id=cpc.profile_class_id
3644: AND cp.STATUS='A' --14699527
3645: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3646: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3664: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3660: AND c.party_id = party.party_id
3661: AND party.party_name <= p_customer_name_high
3662: AND c.account_number <= p_cust_number_high
3663: AND c.cust_account_id IN (SELECT cp.cust_account_id
3664: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3665: WHERE cp.profile_class_id=cpc.profile_class_id
3666: AND cp.STATUS='A' --14699527
3667: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3668: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3685: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3681: AND c.party_id = party.party_id
3682: AND party.party_name BETWEEN p_customer_name_low
3683: AND NVL(p_customer_name_high, party.party_name)
3684: AND c.cust_account_id IN (SELECT cp.cust_account_id
3685: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3686: WHERE cp.profile_class_id=cpc.profile_class_id
3687: AND cp.STATUS='A' --14699527
3688: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3689: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3705: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3701: WHERE c.status='A'
3702: AND c.party_id = party.party_id
3703: AND party.party_name <= p_customer_name_high
3704: AND c.cust_account_id IN (SELECT cp.cust_account_id
3705: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3706: WHERE cp.profile_class_id=cpc.profile_class_id
3707: AND cp.STATUS='A' --14699527
3708: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3709: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3726: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3722: AND c.party_id = party.party_id
3723: AND c.account_number BETWEEN p_cust_number_low
3724: AND NVL(p_cust_number_high, c.account_number )
3725: AND c.cust_account_id IN (SELECT cp.cust_account_id
3726: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3727: WHERE cp.profile_class_id=cpc.profile_class_id
3728: AND cp.STATUS='A' --14699527
3729: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3730: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3746: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3742: WHERE c.status='A'
3743: AND c.party_id = party.party_id
3744: AND c.account_number <= p_cust_number_high
3745: AND c.cust_account_id IN (SELECT cp.cust_account_id
3746: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3747: WHERE cp.profile_class_id=cpc.profile_class_id
3748: AND cp.STATUS='A' --14699527
3749: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3750: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3769: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3765: , hz_parties party
3766: WHERE c.status='A'
3767: AND c.party_id = party.party_id
3768: AND c.cust_account_id IN (SELECT cp.cust_account_id
3769: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3770: WHERE cp.profile_class_id=cpc.profile_class_id
3771: AND cp.STATUS='A' --14699527
3772: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3773: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3990: hz_customer_profiles cp

3986: -----check if the customer has any credit profiles
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

Line 4271: hz_customer_profiles cp

4267: -----check if the customer site has any credit profiles
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