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.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_CUSTOMER_PROFILES

Line 221: FROM hz_customer_profiles cp

217: CURSOR party_check_case1_no_incl_csr IS
218: SELECT cu.credit_usage_id
219: , substrb(cur.user_code,1,5) curr
220: , cpa.currency_code prof_curr
221: FROM hz_customer_profiles cp
222: , hz_cust_profile_amts cpa
223: , hz_credit_usages cu
224: , hz_credit_usage_rules cur
225: WHERE cp.party_id = p_entity_id

Line 252: FROM hz_customer_profiles cp

248:
249: CURSOR party_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
250: SELECT cpa.currency_code profile_curr
251: , cu.credit_usage_id
252: FROM hz_customer_profiles cp
253: , hz_cust_profile_amts cpa
254: , hz_credit_usages cu
255: , hz_credit_usage_rules cur
256: WHERE cp.party_id = p_entity_id

Line 283: FROM hz_customer_profiles cp

279: CURSOR party_check_case2_no_incl_csr IS
280: SELECT cu.credit_usage_id
281: , substrb(cur.user_code,1,5) curr
282: , cpa.currency_code prof_curr
283: FROM hz_customer_profiles cp
284: , hz_cust_profile_amts cpa
285: , hz_credit_usages cu
286: , hz_credit_usage_rules cur
287: WHERE cp.party_id = p_entity_id

Line 315: FROM hz_customer_profiles cp

311:
312: CURSOR party_check_case2_incl_csr IS
313: SELECT cpa.currency_code profile_curr
314: , cu.credit_usage_id
315: FROM hz_customer_profiles cp
316: , hz_cust_profile_amts cpa
317: , hz_credit_usages cu
318: , hz_credit_usage_rules cur
319: WHERE cp.party_id = p_entity_id

Line 342: FROM hz_customer_profiles cp

338: CURSOR site_check_case1_no_incl_csr IS
339: SELECT cu.credit_usage_id
340: , substrb(cur.user_code,1,5) curr
341: , cpa.currency_code prof_curr
342: FROM hz_customer_profiles cp
343: , hz_cust_profile_amts cpa
344: , hz_credit_usages cu
345: , hz_credit_usage_rules cur
346: WHERE cp.cust_account_id = p_cust_account_id

Line 372: FROM hz_customer_profiles cp

368:
369: CURSOR site_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
370: SELECT cpa.currency_code profile_curr
371: , cu.credit_usage_id
372: FROM hz_customer_profiles cp
373: , hz_cust_profile_amts cpa
374: , hz_credit_usages cu
375: , hz_credit_usage_rules cur
376: WHERE cp.cust_account_id = p_cust_account_id

Line 401: FROM hz_customer_profiles cp

397: CURSOR site_check_case2_no_incl_csr IS
398: SELECT cu.credit_usage_id
399: , substrb(cur.user_code,1,5) curr
400: , cpa.currency_code prof_curr
401: FROM hz_customer_profiles cp
402: , hz_cust_profile_amts cpa
403: , hz_credit_usages cu
404: , hz_credit_usage_rules cur
405: WHERE cp.cust_account_id = p_cust_account_id

Line 431: FROM hz_customer_profiles cp

427:
428: CURSOR site_check_case2_incl_csr IS
429: SELECT cpa.currency_code profile_curr
430: , cu.credit_usage_id
431: FROM hz_customer_profiles cp
432: , hz_cust_profile_amts cpa
433: , hz_credit_usages cu
434: , hz_credit_usage_rules cur
435: WHERE cp.cust_account_id = p_cust_account_id

Line 461: FROM hz_customer_profiles cp

457: CURSOR cust_check_case1_no_incl_csr IS
458: SELECT cu.credit_usage_id
459: , substrb(cur.user_code,1,5) curr
460: , cpa.currency_code prof_curr
461: FROM hz_customer_profiles cp
462: , hz_cust_profile_amts cpa
463: , hz_credit_usages cu
464: , hz_credit_usage_rules cur
465: WHERE cp.cust_account_id = p_entity_id

Line 491: FROM hz_customer_profiles cp

487:
488: CURSOR cust_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
489: SELECT cpa.currency_code profile_curr
490: , cu.credit_usage_id
491: FROM hz_customer_profiles cp
492: , hz_cust_profile_amts cpa
493: , hz_credit_usages cu
494: , hz_credit_usage_rules cur
495: WHERE cp.cust_account_id = p_entity_id

Line 521: FROM hz_customer_profiles cp

517: CURSOR cust_check_case2_no_incl_csr IS
518: SELECT cu.credit_usage_id
519: , substrb(cur.user_code,1,5) curr
520: , cpa.currency_code prof_curr
521: FROM hz_customer_profiles cp
522: , hz_cust_profile_amts cpa
523: , hz_credit_usages cu
524: , hz_credit_usage_rules cur
525: WHERE cp.cust_account_id = p_entity_id

Line 552: FROM hz_customer_profiles cp

548:
549: CURSOR cust_check_case2_incl_csr IS
550: SELECT cpa.currency_code profile_curr
551: , cu.credit_usage_id
552: FROM hz_customer_profiles cp
553: , hz_cust_profile_amts cpa
554: , hz_credit_usages cu
555: , hz_credit_usage_rules cur
556: WHERE cp.cust_account_id = p_entity_id

Line 1150: FROM hz_customer_profiles

1146:
1147: SELECT party_id
1148: INTO
1149: l_entity_id
1150: FROM hz_customer_profiles
1151: WHERE cust_account_profile_id=l_cust_account_profile_id;
1152:
1153: END IF;
1154:

Line 1399: , hz_customer_profiles cp

1395: , NVL(cp.site_use_id, cp.cust_account_id) entity_id
1396: , cp.cust_account_id
1397: , DECODE(cp.site_use_id,NULL,'CUSTOMER','SITE') entity_type
1398: FROM hz_cust_profile_amts cpa
1399: , hz_customer_profiles cp
1400: WHERE cp.cust_account_profile_id = cpa.cust_account_profile_id
1401: AND cp.profile_class_id = p_profile_class_id
1402: AND cpa.currency_code = NVL(p_currency_code,currency_code) ;
1403: