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.AR_CMGT_DATA_POINTS_PKG dependencies on AR_TRX_SUMMARY

Line 462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;

458:
459: CURSOR c_currency IS
460: SELECT currency from ar_cmgt_curr_usage_gt;
461:
462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;

Line 463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;

459: CURSOR c_currency IS
460: SELECT currency from ar_cmgt_curr_usage_gt;
461:
462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;

Line 464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;

460: SELECT currency from ar_cmgt_curr_usage_gt;
461:
462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;

Line 465: l_final_inv_date ar_trx_summary.largest_inv_date%type;

461:
462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;

Line 466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;

462: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
470: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;

Line 467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;

463: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
470: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
471: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;

Line 468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;

464: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
470: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
471: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;
472: l_last_payment_number ar_trx_bal_summary.last_payment_number%type;

Line 469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;

465: l_final_inv_date ar_trx_summary.largest_inv_date%type;
466: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
467: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
468: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
469: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
470: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
471: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;
472: l_last_payment_number ar_trx_bal_summary.last_payment_number%type;
473: l_last_payment_currency ar_trx_bal_summary.currency%type;

Line 488: FROM AR_TRX_SUMMARY

484: largest_inv_amount)largest_inv_amount,
485: RANK() OVER (PARTITION BY currency
486: ORDER BY largest_inv_amount desc,
487: largest_inv_cust_trx_id desc) rank_amount
488: FROM AR_TRX_SUMMARY
489: where cust_account_id in (
490: select to_number(cust_account_id)
491: FROM hz_cust_accounts
492: WHERE party_id in

Line 530: FROM AR_TRX_SUMMARY

526: largest_inv_amount)largest_inv_amount,
527: RANK() OVER (PARTITION BY cust_account_id,currency
528: ORDER BY largest_inv_amount desc,
529: largest_inv_cust_trx_id desc) rank_amount
530: FROM AR_TRX_SUMMARY
531: where cust_account_id = :3
532: and org_id = decode(:4,''Y'', org_id, ''N'',
533: decode(:5,null, org_id, :6), null,
534: decode(:7,null, org_id, :8))

Line 550: FROM AR_TRX_SUMMARY

546: largest_inv_amount)largest_inv_amount,
547: RANK() OVER (PARTITION BY cust_account_id, site_use_id,currency
548: ORDER BY largest_inv_amount desc,
549: largest_inv_cust_trx_id desc) rank_amount
550: FROM AR_TRX_SUMMARY
551: where cust_account_id = :3
552: and site_use_id = :4
553: and currency = :5
554: and largest_inv_cust_trx_id is not null

Line 570: FROM AR_TRX_SUMMARY

566: op_bal_high_watermark)op_bal_high_watermark,
567: RANK() OVER (PARTITION BY currency
568: ORDER BY op_bal_high_watermark desc,
569: largest_inv_cust_trx_id desc) high_amount
570: FROM AR_TRX_SUMMARY
571: where cust_account_id in (
572: select to_number(cust_account_id)
573: FROM hz_cust_accounts
574: WHERE party_id in

Line 602: FROM AR_TRX_SUMMARY

598: op_bal_high_watermark)op_bal_high_watermark,
599: RANK() OVER (PARTITION BY cust_account_id,currency,org_id
600: ORDER BY op_bal_high_watermark desc,
601: largest_inv_cust_trx_id desc) high_amount
602: FROM AR_TRX_SUMMARY
603: where cust_account_id = :3
604: and org_id = decode(:4,''Y'', org_id, ''N'',
605: decode(:5,null, org_id, :6), null,
606: decode(:7,null, org_id, :8))

Line 622: FROM AR_TRX_SUMMARY

618: op_bal_high_watermark)op_bal_high_watermark,
619: RANK() OVER (PARTITION BY cust_account_id, site_use_id,currency
620: ORDER BY op_bal_high_watermark desc,
621: largest_inv_cust_trx_id desc) high_amount
622: FROM AR_TRX_SUMMARY
623: where cust_account_id = :3
624: and site_use_id = :4
625: and currency = :5
626: and largest_inv_cust_trx_id is not null

Line 746: logic returned the raw amount (in AR_TRX_SUMMARY currency)

742: /* 6513911 - revised sql to not require all currencies
743: This code now selects the converted amount and date
744: (max) at one time, then substr them out to individual
745: fields for the datapoint(s). Incidentally, the original
746: logic returned the raw amount (in AR_TRX_SUMMARY currency)
747: rather than the converted amount -- I considered this a bug
748: and now return the converted amount (to CF currency) */
749: SELECT max(ltrim(
750: to_char( gl_currency_api.convert_amount(currency,

Line 757: FROM ar_trx_summary

753: NVL(op_bal_high_watermark,0)),
754: '0999999999999999999D00')) || '~' ||
755: to_char(as_of_date, 'YYYYMMDD'))
756: INTO l_result
757: FROM ar_trx_summary
758: WHERE op_bal_high_watermark IS NOT NULL
759: AND as_of_date >= ADD_MONTHS(sysdate,(-p_period))
760: AND cust_account_id IN (
761: SELECT TO_NUMBER(cust_account_id) -- Fix for Bug 12670874

Line 816: FROM ar_trx_summary

812: NVL(op_bal_high_watermark,0)),
813: '0999999999999999999D00')) || '~' ||
814: to_char(as_of_date, 'YYYYMMDD'))
815: INTO l_result
816: FROM ar_trx_summary
817: WHERE op_bal_high_watermark IS NOT NULL
818: AND as_of_date >= ADD_MONTHS(sysdate,(-p_period))
819: AND cust_account_id = p_cust_account_id
820: AND site_use_id = DECODE(p_analysis_level, 'S', p_site_use_id,

Line 4867: FROM AR_TRX_SUMMARY

4863: l_limit_currency,sysdate,
4864: l_exchange_rate_type,
4865: SUM(NVL(TOTAL_DEPOSITS_VALUE,0))),2) total_deposits_value,
4866: SUM(NVL(TOTAL_deposits_COUNT,0)) TOTAL_deposits_count
4867: FROM AR_TRX_SUMMARY
4868: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
4869: FROM hz_cust_accounts
4870: WHERE party_id in
4871: ( SELECT child_id

Line 5011: FROM AR_TRX_SUMMARY

5007: l_limit_currency,sysdate,
5008: l_exchange_rate_type,
5009: SUM(NVL(TOTAL_DEPOSITS_VALUE,0))),2) total_deposits_value,
5010: SUM(NVL(TOTAL_deposits_COUNT,0)) TOTAL_deposits_count
5011: FROM AR_TRX_SUMMARY
5012: WHERE org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
5013: decode(p_org_id,null, org_id, p_org_id), null,
5014: decode(p_org_id,null, org_id, p_org_id))
5015: and CUST_ACCOUNT_ID = p_cust_account_id

Line 5132: FROM AR_TRX_SUMMARY

5128: l_limit_currency,sysdate,
5129: l_exchange_rate_type,
5130: SUM(NVL(TOTAL_DEPOSITS_VALUE,0))),2) total_deposits_value,
5131: SUM(NVL(TOTAL_deposits_COUNT,0)) TOTAL_deposits_count
5132: FROM AR_TRX_SUMMARY
5133: WHERE CUST_ACCOUNT_ID = p_cust_account_id
5134: and CURRENCY IN ( SELECT a.CURRENCY FROM
5135: ar_cmgt_curr_usage_gt a
5136: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

Line 5597: FROM ar_trx_summary

5593: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5594: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5595: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5596: )))) delinquent_dso
5597: FROM ar_trx_summary
5598: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5599: FROM hz_cust_accounts
5600: WHERE party_id in
5601: ( SELECT child_id

Line 5648: FROM ar_trx_summary

5644: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5645: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5646: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5647: ))) delinquent_dso
5648: FROM ar_trx_summary
5649: WHERE cust_account_id = p_cust_account_id
5650: and CURRENCY IN ( SELECT CURRENCY FROM
5651: ar_cmgt_curr_usage_gt
5652: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

Line 5679: FROM ar_trx_summary

5675: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5676: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5677: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5678: ))) delinquent_dso
5679: FROM ar_trx_summary
5680: WHERE cust_account_id = p_cust_account_id
5681: and CURRENCY IN ( SELECT CURRENCY FROM
5682: ar_cmgt_curr_usage_gt
5683: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

Line 6082: p_error_msg := 'Error While Getting Data from AR_TRX_SUMMARY, Probably exchange rate'||

6078: END LOOP;
6079: END IF;
6080: EXCEPTION
6081: WHEN OTHERS THEN
6082: p_error_msg := 'Error While Getting Data from AR_TRX_SUMMARY, Probably exchange rate'||
6083: ' is not set correctly '||'Sql Error:'||sqlerrm;
6084: p_resultout := 1;
6085: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '1');
6086: return;

Line 6281: FROM ar_trx_summary

6277: SYSDATE,l_exchange_rate_type,
6278: (NVL(SUM_APP_AMT,0))))),2) wt_average_pmt_days
6279: INTO l_wadpl,
6280: l_apd
6281: FROM ar_trx_summary
6282: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
6283: FROM hz_cust_accounts
6284: WHERE party_id in
6285: ( SELECT child_id

Line 6353: FROM ar_trx_summary

6349: SYSDATE,l_exchange_rate_type,
6350: (NVL(SUM_APP_AMT,0))))),2) wt_average_pmt_days
6351: INTO l_wadpl,
6352: l_apd
6353: FROM ar_trx_summary
6354: WHERE ORG_ID = decode(l_global_exposure_flag,'Y', org_id, 'N',
6355: decode(p_org_id,null, org_id, p_org_id), null,
6356: decode(p_org_id,null, org_id, p_org_id))
6357: AND CUST_ACCOUNT_ID = p_cust_account_id

Line 6404: FROM ar_trx_summary

6400: SYSDATE,l_exchange_rate_type,
6401: (NVL(SUM_APP_AMT,0))))),2) wt_average_pmt_days
6402: INTO l_wadpl,
6403: l_apd
6404: FROM ar_trx_summary
6405: WHERE CUST_ACCOUNT_ID = p_cust_account_id
6406: AND CURRENCY IN ( SELECT a.CURRENCY
6407: FROM ar_cmgt_curr_usage_gt a
6408: WHERE nvl(credit_request_id,p_credit_request_id) =