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_CMGT_CURR_USAGE_GT

Line 236: ar_cmgt_curr_usage_gt

232: (sysdate between start_date_active and end_date_active)
233: )
234: ))
235: AND currency_code IN ( SELECT CURRENCY FROM
236: ar_cmgt_curr_usage_gt
237: WHERE nvl(credit_request_id,p_credit_request_id)
238: = p_credit_request_id)
239: group by currency_code);
240: EXCEPTION

Line 270: ar_cmgt_curr_usage_gt

266: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
267: decode(p_org_id,null, org_id, p_org_id), null,
268: decode(p_org_id,null, org_id, p_org_id))
269: AND currency_code IN ( SELECT CURRENCY FROM
270: ar_cmgt_curr_usage_gt
271: WHERE nvl(credit_request_id,p_credit_request_id)
272: = p_credit_request_id)
273: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
274: group by currency_code );

Line 304: ar_cmgt_curr_usage_gt

300: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
301: AND cust_account_id = p_cust_account_id
302: AND cust_billto_acct_site_id = p_site_use_id
303: AND currency_code IN ( SELECT CURRENCY FROM
304: ar_cmgt_curr_usage_gt
305: WHERE nvl(credit_request_id,p_credit_request_id)
306: = p_credit_request_id)
307: group by currency_code );
308: EXCEPTION

Line 401: SELECT currency from ar_cmgt_curr_usage_gt;

397: p_errormsg out nocopy VARCHAR2,
398: p_resultout out nocopy VARCHAR2) IS
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;

Line 728: FROM ar_cmgt_curr_usage_gt

724: AND (end_date_active is null OR
725: (sysdate between start_date_active
726: and end_date_active))))
727: AND currency IN ( SELECT CURRENCY
728: FROM ar_cmgt_curr_usage_gt
729: WHERE nvl(credit_request_id,p_credit_request_id)
730: = p_credit_request_id);
731:
732: /* Now extract results, '~' is separator */

Line 767: FROM ar_cmgt_curr_usage_gt

763: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
764: decode(p_org_id,null, org_id, p_org_id), null,
765: decode(p_org_id,null, org_id, p_org_id))
766: AND currency IN ( SELECT CURRENCY
767: FROM ar_cmgt_curr_usage_gt
768: WHERE nvl(credit_request_id,p_credit_request_id)
769: = p_credit_request_id);
770:
771: /* Now extract results, '~' is separator */

Line 851: ar_cmgt_curr_usage_gt

847: (sysdate between start_date_active and end_date_active)
848: )
849: ))
850: and CURRENCY IN ( SELECT CURRENCY FROM
851: ar_cmgt_curr_usage_gt
852: WHERE nvl(credit_request_id,p_credit_request_id)
853: = p_credit_request_id)
854: and last_payment_number IS NOT NULL
855: and last_payment_date IS NOT NULL

Line 884: ar_cmgt_curr_usage_gt

880: (sysdate between start_date_active and end_date_active)
881: )
882: ))
883: and CURRENCY IN ( SELECT CURRENCY FROM
884: ar_cmgt_curr_usage_gt
885: WHERE nvl(credit_request_id,p_credit_request_id) =
886: p_credit_request_id)
887: and last_payment_date is not null
888: and last_payment_number is not null)

Line 904: ar_cmgt_curr_usage_gt

900: and org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
901: decode(p_org_id,null, p_org_id, p_org_id), null,
902: decode(p_org_id,null, org_id, p_org_id))
903: and currency in ( SELECT CURRENCY FROM
904: ar_cmgt_curr_usage_gt
905: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
906: and last_payment_date = ( select max(last_payment_date) from
907: ar_trx_bal_summary
908: where cust_account_id = p_cust_account_id

Line 912: ar_cmgt_curr_usage_gt

908: where cust_account_id = p_cust_account_id
909: and last_payment_date IS NOT NULL
910: and last_payment_number IS NOT NULL
911: and currency in ( SELECT CURRENCY FROM
912: ar_cmgt_curr_usage_gt
913: WHERE nvl(credit_request_id,p_credit_request_id) =
914: p_credit_request_id))
915: and rownum = 1;
916: ELSIF p_analysis_level = 'S'

Line 928: ar_cmgt_curr_usage_gt

924: and site_use_id = p_site_use_id
925: and last_payment_date IS NOT NULL
926: and last_payment_number IS NOT NULL
927: and currency in ( SELECT CURRENCY FROM
928: ar_cmgt_curr_usage_gt
929: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
930: and last_payment_date = ( select max(last_payment_date) from
931: ar_trx_bal_summary
932: where cust_account_id = p_cust_account_id

Line 937: ar_cmgt_curr_usage_gt

933: and site_use_id = p_site_use_id
934: and last_payment_date IS NOT NULL
935: and last_payment_number IS NOT NULL
936: and currency in ( SELECT CURRENCY FROM
937: ar_cmgt_curr_usage_gt
938: WHERE nvl(credit_request_id,p_credit_request_id) =
939: p_credit_request_id))
940: and rownum = 1;
941: END IF;

Line 4814: ar_cmgt_curr_usage_gt

4810: (sysdate between start_date_active and end_date_active)
4811: )
4812: ))
4813: and CURRENCY IN ( SELECT CURRENCY FROM
4814: ar_cmgt_curr_usage_gt
4815: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
4816: /*( SELECT * FROM
4817: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
4818: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))

Line 4953: ar_cmgt_curr_usage_gt

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
4952: and CURRENCY IN ( SELECT CURRENCY FROM
4953: ar_cmgt_curr_usage_gt
4954: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
4955: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))
4956: group by currency );
4957:

Line 5086: ar_cmgt_curr_usage_gt a

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)
5088: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))
5089: and site_use_id = p_cust_acct_site_id
5090: group by currency );

Line 5216: ar_cmgt_curr_usage_gt

5212: (sysdate between start_date_active and end_date_active)
5213: )
5214: ))
5215: and CURRENCY IN ( SELECT CURRENCY FROM
5216: ar_cmgt_curr_usage_gt
5217: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5218: group by currency);
5219:
5220:

Line 5318: ar_cmgt_curr_usage_gt

5314: decode(p_org_id,null, org_id, p_org_id), null,
5315: decode(p_org_id,null, org_id, p_org_id))
5316: and cust_account_id = p_cust_account_id
5317: and CURRENCY IN ( SELECT CURRENCY FROM
5318: ar_cmgt_curr_usage_gt
5319: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5320: /* ( SELECT * FROM
5321: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
5322: --and site_use_id = decode(l_analysis_level,'S',p_cust_acct_site_id,site_use_id)

Line 5419: ar_cmgt_curr_usage_gt

5415: SUM(nvl(op_invoices_count,0) - nvl(past_due_inv_inst_count,0)) current_invoice_count
5416: FROM AR_TRX_BAL_SUMMARY
5417: WHERE cust_account_id = p_cust_account_id
5418: and CURRENCY IN ( SELECT CURRENCY FROM
5419: ar_cmgt_curr_usage_gt
5420: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5421: /* ( SELECT * FROM
5422: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
5423: and site_use_id = p_cust_acct_site_id

Line 5470: ar_cmgt_curr_usage_gt

5466: (sysdate between start_date_active and end_date_active)
5467: )
5468: ))
5469: and CURRENCY IN ( SELECT CURRENCY FROM
5470: ar_cmgt_curr_usage_gt
5471: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5472: group by currency);
5473:
5474: CURSOR c_account_numerator_dso IS

Line 5498: ar_cmgt_curr_usage_gt

5494: and org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
5495: decode(p_org_id,null, org_id, p_org_id), null,
5496: decode(p_org_id,null, org_id, p_org_id))
5497: and CURRENCY IN ( SELECT CURRENCY FROM
5498: ar_cmgt_curr_usage_gt
5499: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5500: group by currency);
5501:
5502: CURSOR c_site_numerator_dso IS

Line 5524: ar_cmgt_curr_usage_gt

5520: FROM ar_trx_bal_summary
5521: WHERE cust_account_id = p_cust_account_id
5522: and site_use_id = p_cust_acct_site_id
5523: and CURRENCY IN ( SELECT CURRENCY FROM
5524: ar_cmgt_curr_usage_gt
5525: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5526: group by currency);
5527:
5528: CURSOR c_party_deno_dso IS

Line 5574: ar_cmgt_curr_usage_gt

5570: (sysdate between start_date_active and end_date_active)
5571: )
5572: ))
5573: and CURRENCY IN ( SELECT CURRENCY FROM
5574: ar_cmgt_curr_usage_gt
5575: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5576: and as_of_date >= (sysdate -l_certified_dso_days)
5577: group by currency);
5578:

Line 5602: ar_cmgt_curr_usage_gt

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)
5604: and org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
5605: decode(p_org_id,null, org_id, p_org_id), null,
5606: decode(p_org_id,null, org_id, p_org_id))

Line 5633: ar_cmgt_curr_usage_gt

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)
5635: and site_use_id = p_cust_acct_site_id
5636: and as_of_date >= (sysdate -l_certified_dso_days)
5637: group by currency);

Line 5785: INSERT INTO ar_cmgt_curr_usage_gt ( credit_request_id, currency) values

5781: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');
5782: END IF;
5783: END IF;
5784:
5785: INSERT INTO ar_cmgt_curr_usage_gt ( credit_request_id, currency) values
5786: ( p_credit_request_id, l_curr_tbl(i).usage_curr_code);
5787: END LOOP;
5788: ELSE
5789: -- populate temp table with all currency. may not be a good soulution

Line 5791: INSERT INTO ar_cmgt_curr_usage_gt(currency)

5787: END LOOP;
5788: ELSE
5789: -- populate temp table with all currency. may not be a good soulution
5790: -- to take this approach. Would be better to have another cursor.
5791: INSERT INTO ar_cmgt_curr_usage_gt(currency)
5792: ( select distinct currency from ar_trx_bal_summary);
5793: IF pg_wf_debug = 'Y'
5794: THEN
5795: ar_cmgt_util.wf_debug(l_tag,