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_CUST_PROFILE_AMTS

Line 222: , hz_cust_profile_amts cpa

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

Line 253: , hz_cust_profile_amts cpa

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
257: AND cp.cust_account_id =-1

Line 284: , hz_cust_profile_amts cpa

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
288: AND cp.cust_account_id =-1

Line 316: , hz_cust_profile_amts cpa

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
320: AND cp.cust_account_id =-1

Line 343: , hz_cust_profile_amts cpa

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
347: AND cp.site_use_id = p_entity_id

Line 373: , hz_cust_profile_amts cpa

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
377: AND cp.site_use_id = p_entity_id

Line 402: , hz_cust_profile_amts cpa

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
406: AND cp.site_use_id = p_entity_id

Line 432: , hz_cust_profile_amts cpa

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
436: AND cp.site_use_id = p_entity_id

Line 462: , hz_cust_profile_amts cpa

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

Line 492: , hz_cust_profile_amts cpa

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

Line 522: , hz_cust_profile_amts cpa

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

Line 553: , hz_cust_profile_amts cpa

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

Line 1138: hz_cust_profile_amts

1134: , l_entity
1135: , l_entity_id
1136: , l_cust_account_profile_id
1137: FROM
1138: hz_cust_profile_amts
1139: WHERE cust_acct_profile_amt_id =
1140: p_cust_acct_profile_amt_id ;
1141:
1142: IF l_cust_account_id=-1

Line 1398: FROM hz_cust_profile_amts cpa

1394: , cp.cust_account_profile_id
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) ;