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_CREDIT_USAGE_RULES

Line 206: FROM HZ_CREDIT_USAGE_RULES

202: -------------------------
203:
204: CURSOR SELECT_USAGE_CURR_CSR IS
205: SELECT user_code
206: FROM HZ_CREDIT_USAGE_RULES
207: WHERE credit_usage_rule_set_id = p_rule_set_id
208: AND usage_type = 'CURRENCY'
209: AND NVL (include_all_flag, 'N') = 'N'
210: AND NVL(exclude_flag,'N') = 'N' ;

Line 224: , hz_credit_usage_rules cur

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
227: AND cp.cust_account_id =-1
228: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 238: hz_credit_usage_rules cr2

234: AND NVL (cur.include_all_flag, 'N') = 'N'
235: AND cur.usage_type = 'CURRENCY'
236: AND cur.user_code IN (
237: SELECT cr2.user_code from
238: hz_credit_usage_rules cr2
239: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
240: AND cr2.usage_type = 'CURRENCY' and
241: NVL (cr2.include_all_flag, 'N') = 'N'
242: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 255: , hz_credit_usage_rules cur

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
258: AND cp.site_use_id IS NULL
259: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 267: FROM hz_credit_usage_rules cur2

263: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
264: ) <= TRUNC(SYSDATE)
265: AND NVL (cur.include_all_flag, 'N') = 'Y'
266: AND NOT EXISTS ( SELECT 'EXCLUDE'
267: FROM hz_credit_usage_rules cur2
268: WHERE cu.credit_usage_rule_set_id
269: = cur2.credit_usage_rule_set_id
270: AND NVL(cur2.exclude_flag,'N') = 'Y'
271: AND cur2.usage_type = 'CURRENCY'

Line 286: , hz_credit_usage_rules cur

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
289: AND cp.site_use_id IS NULL
290: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 300: hz_credit_usage_rules cr2

296: AND NVL (cur.include_all_flag, 'N') = 'N'
297: AND cur.usage_type = 'CURRENCY'
298: AND cur.user_code NOT IN (
299: SELECT cr2.user_code from
300: hz_credit_usage_rules cr2
301: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
302: AND cr2.usage_type = 'CURRENCY' and
303: NVL (cr2.include_all_flag, 'N') = 'N'
304: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 318: , hz_credit_usage_rules cur

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
321: AND cp.site_use_id IS NULL
322: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 345: , hz_credit_usage_rules cur

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
348: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
349: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 358: hz_credit_usage_rules cr2

354: AND NVL (cur.include_all_flag, 'N') = 'N'
355: AND cur.usage_type = 'CURRENCY'
356: AND cur.user_code IN (
357: SELECT cr2.user_code from
358: hz_credit_usage_rules cr2
359: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
360: AND cr2.usage_type = 'CURRENCY' and
361: NVL (cr2.include_all_flag, 'N') = 'N'
362: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 375: , hz_credit_usage_rules cur

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
378: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
379: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 386: FROM hz_credit_usage_rules cur2

382: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
383: ) <= TRUNC(SYSDATE)
384: AND NVL (cur.include_all_flag, 'N') = 'Y'
385: AND NOT EXISTS ( SELECT 'EXCLUDE'
386: FROM hz_credit_usage_rules cur2
387: WHERE cu.credit_usage_rule_set_id
388: = cur2.credit_usage_rule_set_id
389: AND NVL(cur2.exclude_flag,'N') = 'Y'
390: AND cur2.usage_type = 'CURRENCY'

Line 404: , hz_credit_usage_rules cur

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
407: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
408: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 417: hz_credit_usage_rules cr2

413: AND NVL (cur.include_all_flag, 'N') = 'N'
414: AND cur.usage_type = 'CURRENCY'
415: AND cur.user_code NOT IN (
416: SELECT cr2.user_code from
417: hz_credit_usage_rules cr2
418: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
419: AND cr2.usage_type = 'CURRENCY' and
420: NVL (cr2.include_all_flag, 'N') = 'N'
421: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 434: , hz_credit_usage_rules cur

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
437: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
438: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 464: , hz_credit_usage_rules cur

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
467: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
468: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 477: hz_credit_usage_rules cr2

473: AND NVL (cur.include_all_flag, 'N') = 'N'
474: AND cur.usage_type = 'CURRENCY'
475: AND cur.user_code IN (
476: SELECT cr2.user_code from
477: hz_credit_usage_rules cr2
478: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
479: AND cr2.usage_type = 'CURRENCY' and
480: NVL (cr2.include_all_flag, 'N') = 'N'
481: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 494: , hz_credit_usage_rules cur

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

Line 505: FROM hz_credit_usage_rules cur2

501: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
502: ) <= TRUNC(SYSDATE)
503: AND NVL (cur.include_all_flag, 'N') = 'Y'
504: AND NOT EXISTS ( SELECT 'EXCLUDE'
505: FROM hz_credit_usage_rules cur2
506: WHERE cu.credit_usage_rule_set_id
507: = cur2.credit_usage_rule_set_id
508: AND NVL(cur2.exclude_flag,'N') = 'Y'
509: AND cur2.usage_type = 'CURRENCY'

Line 524: , hz_credit_usage_rules cur

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
527: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
528: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 537: hz_credit_usage_rules cr2

533: AND NVL (cur.include_all_flag, 'N') = 'N'
534: AND cur.usage_type = 'CURRENCY'
535: AND cur.user_code NOT IN (
536: SELECT cr2.user_code from
537: hz_credit_usage_rules cr2
538: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
539: AND cr2.usage_type = 'CURRENCY' and
540: NVL (cr2.include_all_flag, 'N') = 'N'
541: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 555: , hz_credit_usage_rules cur

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
558: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
559: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 1107: FROM hz_credit_usage_rules

1103: LOOP
1104: BEGIN
1105: SELECT credit_usage_rule_id
1106: INTO l_id
1107: FROM hz_credit_usage_rules
1108: WHERE credit_usage_rule_set_id
1109: = rule_set_csr_rec.credit_usage_rule_set_id
1110: AND user_code IS NULL;
1111: