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 403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;

399:
400: CURSOR c_currency IS
401: SELECT currency from ar_cmgt_curr_usage_gt;
402:
403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;

Line 404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;

400: CURSOR c_currency IS
401: SELECT currency from ar_cmgt_curr_usage_gt;
402:
403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;

Line 405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;

401: SELECT currency from ar_cmgt_curr_usage_gt;
402:
403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;

Line 406: l_final_inv_date ar_trx_summary.largest_inv_date%type;

402:
403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;

Line 407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;

403: l_largest_inv_date ar_trx_summary.largest_inv_date%type;
404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
411: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;

Line 408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;

404: l_largest_inv_amount ar_trx_summary.largest_inv_amount%type;
405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
411: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
412: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;

Line 409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;

405: l_final_inv_amount ar_trx_summary.largest_inv_amount%type;
406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
411: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
412: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;
413: l_last_payment_number ar_trx_bal_summary.last_payment_number%type;

Line 410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;

406: l_final_inv_date ar_trx_summary.largest_inv_date%type;
407: l_high_watermark_date ar_trx_summary.op_bal_high_watermark_date%type;
408: l_high_watermark ar_trx_summary.op_bal_high_watermark%type;
409: l_final_high_watermark ar_trx_summary.op_bal_high_watermark%type;
410: l_final_high_watermark_date ar_trx_summary.as_of_date%type;
411: l_last_payment_amount ar_trx_bal_summary.last_payment_amount%type;
412: l_last_payment_date ar_trx_bal_summary.last_payment_date%type;
413: l_last_payment_number ar_trx_bal_summary.last_payment_number%type;
414: l_last_payment_currency ar_trx_bal_summary.currency%type;

Line 429: FROM AR_TRX_SUMMARY

425: largest_inv_amount)largest_inv_amount,
426: RANK() OVER (PARTITION BY currency
427: ORDER BY largest_inv_amount desc,
428: largest_inv_cust_trx_id desc) rank_amount
429: FROM AR_TRX_SUMMARY
430: where cust_account_id in (
431: select cust_account_id
432: FROM hz_cust_accounts
433: WHERE party_id in

Line 471: FROM AR_TRX_SUMMARY

467: largest_inv_amount)largest_inv_amount,
468: RANK() OVER (PARTITION BY cust_account_id,currency
469: ORDER BY largest_inv_amount desc,
470: largest_inv_cust_trx_id desc) rank_amount
471: FROM AR_TRX_SUMMARY
472: where cust_account_id = :3
473: and org_id = decode(:4,''Y'', org_id, ''N'',
474: decode(:5,null, org_id, :6), null,
475: decode(:7,null, org_id, :8))

Line 491: FROM AR_TRX_SUMMARY

487: largest_inv_amount)largest_inv_amount,
488: RANK() OVER (PARTITION BY cust_account_id, site_use_id,currency
489: ORDER BY largest_inv_amount desc,
490: largest_inv_cust_trx_id desc) rank_amount
491: FROM AR_TRX_SUMMARY
492: where cust_account_id = :3
493: and site_use_id = :4
494: and currency = :5
495: and largest_inv_cust_trx_id is not null

Line 511: FROM AR_TRX_SUMMARY

507: op_bal_high_watermark)op_bal_high_watermark,
508: RANK() OVER (PARTITION BY currency
509: ORDER BY op_bal_high_watermark desc,
510: largest_inv_cust_trx_id desc) high_amount
511: FROM AR_TRX_SUMMARY
512: where cust_account_id in (
513: select cust_account_id
514: FROM hz_cust_accounts
515: WHERE party_id in

Line 543: FROM AR_TRX_SUMMARY

539: op_bal_high_watermark)op_bal_high_watermark,
540: RANK() OVER (PARTITION BY cust_account_id,currency,org_id
541: ORDER BY op_bal_high_watermark desc,
542: largest_inv_cust_trx_id desc) high_amount
543: FROM AR_TRX_SUMMARY
544: where cust_account_id = :3
545: and org_id = decode(:4,''Y'', org_id, ''N'',
546: decode(:5,null, org_id, :6), null,
547: decode(:7,null, org_id, :8))

Line 563: FROM AR_TRX_SUMMARY

559: op_bal_high_watermark)op_bal_high_watermark,
560: RANK() OVER (PARTITION BY cust_account_id, site_use_id,currency
561: ORDER BY op_bal_high_watermark desc,
562: largest_inv_cust_trx_id desc) high_amount
563: FROM AR_TRX_SUMMARY
564: where cust_account_id = :3
565: and site_use_id = :4
566: and currency = :5
567: and largest_inv_cust_trx_id is not null

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

683: /* 6513911 - revised sql to not require all currencies
684: This code now selects the converted amount and date
685: (max) at one time, then substr them out to individual
686: fields for the datapoint(s). Incidentally, the original
687: logic returned the raw amount (in AR_TRX_SUMMARY currency)
688: rather than the converted amount -- I considered this a bug
689: and now return the converted amount (to CF currency) */
690: SELECT max(ltrim(
691: to_char( gl_currency_api.convert_amount(currency,

Line 698: FROM ar_trx_summary

694: op_bal_high_watermark),
695: '0999999999999999999D00')) || '~' ||
696: to_char(as_of_date, 'YYYYMMDD'))
697: INTO l_result
698: FROM ar_trx_summary
699: WHERE op_bal_high_watermark IS NOT NULL
700: AND as_of_date >= ADD_MONTHS(sysdate,(-p_period))
701: AND cust_account_id IN (
702: SELECT cust_account_id

Line 757: FROM ar_trx_summary

753: op_bal_high_watermark),
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 = p_cust_account_id
761: AND site_use_id = DECODE(p_analysis_level, 'S', p_site_use_id,

Line 4788: FROM AR_TRX_SUMMARY

4784: l_limit_currency,sysdate,
4785: l_exchange_rate_type,
4786: SUM(TOTAL_DEPOSITS_VALUE)),2) total_deposits_value,
4787: SUM(TOTAL_deposits_COUNT) TOTAL_deposits_count
4788: FROM AR_TRX_SUMMARY
4789: WHERE CUST_ACCOUNT_ID in (select cust_account_id
4790: FROM hz_cust_accounts
4791: WHERE party_id in
4792: ( SELECT child_id

Line 4947: FROM AR_TRX_SUMMARY

4943: l_limit_currency,sysdate,
4944: l_exchange_rate_type,
4945: SUM(TOTAL_DEPOSITS_VALUE)),2) total_deposits_value,
4946: SUM(TOTAL_deposits_COUNT) TOTAL_deposits_count
4947: FROM AR_TRX_SUMMARY
4948: WHERE org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
4949: decode(p_org_id,null, org_id, p_org_id), null,
4950: decode(p_org_id,null, org_id, p_org_id))
4951: and CUST_ACCOUNT_ID = p_cust_account_id

Line 5083: FROM AR_TRX_SUMMARY

5079: l_limit_currency,sysdate,
5080: l_exchange_rate_type,
5081: SUM(TOTAL_DEPOSITS_VALUE)),2) total_deposits_value,
5082: SUM(TOTAL_deposits_COUNT) TOTAL_deposits_count
5083: FROM AR_TRX_SUMMARY
5084: WHERE CUST_ACCOUNT_ID = p_cust_account_id
5085: and CURRENCY IN ( SELECT a.CURRENCY FROM
5086: ar_cmgt_curr_usage_gt a
5087: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

Line 5548: FROM ar_trx_summary

5544: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5545: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5546: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5547: )))) delinquent_dso
5548: FROM ar_trx_summary
5549: WHERE cust_account_id in (select cust_account_id
5550: FROM hz_cust_accounts
5551: WHERE party_id in
5552: ( SELECT child_id

Line 5599: FROM ar_trx_summary

5595: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5596: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5597: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5598: ))) delinquent_dso
5599: FROM ar_trx_summary
5600: WHERE cust_account_id = p_cust_account_id
5601: and CURRENCY IN ( SELECT CURRENCY FROM
5602: ar_cmgt_curr_usage_gt
5603: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

Line 5630: FROM ar_trx_summary

5626: nvl(TOTAL_DEPOSITS_VALUE,0) + nvl(TOTAL_BILLS_RECEIVABLES_VALUE,0) +
5627: nvl(TOTAL_CHARGEBACK_VALUE,0) + nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
5628: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5629: ))) delinquent_dso
5630: FROM ar_trx_summary
5631: WHERE cust_account_id = p_cust_account_id
5632: and CURRENCY IN ( SELECT CURRENCY FROM
5633: ar_cmgt_curr_usage_gt
5634: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)

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

5976: END LOOP;
5977: END IF;
5978: EXCEPTION
5979: WHEN OTHERS THEN
5980: p_error_msg := 'Error While Getting Data from AR_TRX_SUMMARY, Probably exchange rate'||
5981: ' is not set correctly '||'Sql Error:'||sqlerrm;
5982: p_resultout := 1;
5983: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg || '1');
5984: return;