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.

[Home] [Help]

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CURR_USAGE_GT

Line 295: ar_cmgt_curr_usage_gt

291: (sysdate between start_date_active and end_date_active)
292: )
293: ))
294: AND currency_code IN ( SELECT CURRENCY FROM
295: ar_cmgt_curr_usage_gt
296: WHERE nvl(credit_request_id,p_credit_request_id)
297: = p_credit_request_id)
298: group by currency_code);
299: EXCEPTION

Line 329: ar_cmgt_curr_usage_gt

325: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
326: decode(p_org_id,null, org_id, p_org_id), null,
327: decode(p_org_id,null, org_id, p_org_id))
328: AND currency_code IN ( SELECT CURRENCY FROM
329: ar_cmgt_curr_usage_gt
330: WHERE nvl(credit_request_id,p_credit_request_id)
331: = p_credit_request_id)
332: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
333: group by currency_code );

Line 363: ar_cmgt_curr_usage_gt

359: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
360: AND cust_account_id = p_cust_account_id
361: AND cust_billto_acct_site_id = p_site_use_id
362: AND currency_code IN ( SELECT CURRENCY FROM
363: ar_cmgt_curr_usage_gt
364: WHERE nvl(credit_request_id,p_credit_request_id)
365: = p_credit_request_id)
366: group by currency_code );
367: EXCEPTION

Line 460: SELECT currency from ar_cmgt_curr_usage_gt;

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

Line 787: FROM ar_cmgt_curr_usage_gt

783: AND (end_date_active is null OR
784: (sysdate between start_date_active
785: and end_date_active))))
786: AND currency IN ( SELECT CURRENCY
787: FROM ar_cmgt_curr_usage_gt
788: WHERE nvl(credit_request_id,p_credit_request_id)
789: = p_credit_request_id);
790:
791: /* Now extract results, '~' is separator */

Line 826: FROM ar_cmgt_curr_usage_gt

822: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
823: decode(p_org_id,null, org_id, p_org_id), null,
824: decode(p_org_id,null, org_id, p_org_id))
825: AND currency IN ( SELECT CURRENCY
826: FROM ar_cmgt_curr_usage_gt
827: WHERE nvl(credit_request_id,p_credit_request_id)
828: = p_credit_request_id);
829:
830: /* Now extract results, '~' is separator */

Line 910: ar_cmgt_curr_usage_gt

906: (sysdate between start_date_active and end_date_active)
907: )
908: ))
909: and CURRENCY IN ( SELECT CURRENCY FROM
910: ar_cmgt_curr_usage_gt
911: WHERE nvl(credit_request_id,p_credit_request_id)
912: = p_credit_request_id)
913: and last_payment_number IS NOT NULL
914: and last_payment_date IS NOT NULL

Line 943: ar_cmgt_curr_usage_gt

939: (sysdate between start_date_active and end_date_active)
940: )
941: ))
942: and CURRENCY IN ( SELECT CURRENCY FROM
943: ar_cmgt_curr_usage_gt
944: WHERE nvl(credit_request_id,p_credit_request_id) =
945: p_credit_request_id)
946: and last_payment_date is not null
947: and last_payment_number is not null)

Line 963: ar_cmgt_curr_usage_gt

959: and org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
960: decode(p_org_id,null, p_org_id, p_org_id), null,
961: decode(p_org_id,null, org_id, p_org_id))
962: and currency in ( SELECT CURRENCY FROM
963: ar_cmgt_curr_usage_gt
964: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
965: and last_payment_date = ( select max(last_payment_date) from
966: ar_trx_bal_summary
967: where cust_account_id = p_cust_account_id

Line 971: ar_cmgt_curr_usage_gt

967: where cust_account_id = p_cust_account_id
968: and last_payment_date IS NOT NULL
969: and last_payment_number IS NOT NULL
970: and currency in ( SELECT CURRENCY FROM
971: ar_cmgt_curr_usage_gt
972: WHERE nvl(credit_request_id,p_credit_request_id) =
973: p_credit_request_id))
974: and rownum = 1;
975: ELSIF p_analysis_level = 'S'

Line 987: ar_cmgt_curr_usage_gt

983: and site_use_id = p_site_use_id
984: and last_payment_date IS NOT NULL
985: and last_payment_number IS NOT NULL
986: and currency in ( SELECT CURRENCY FROM
987: ar_cmgt_curr_usage_gt
988: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
989: and last_payment_date = ( select max(last_payment_date) from
990: ar_trx_bal_summary
991: where cust_account_id = p_cust_account_id

Line 996: ar_cmgt_curr_usage_gt

992: and site_use_id = p_site_use_id
993: and last_payment_date IS NOT NULL
994: and last_payment_number IS NOT NULL
995: and currency in ( SELECT CURRENCY FROM
996: ar_cmgt_curr_usage_gt
997: WHERE nvl(credit_request_id,p_credit_request_id) =
998: p_credit_request_id))
999: and rownum = 1;
1000: END IF;

Line 4893: ar_cmgt_curr_usage_gt

4889: (sysdate between start_date_active and end_date_active)
4890: )
4891: ))
4892: and CURRENCY IN ( SELECT CURRENCY FROM
4893: ar_cmgt_curr_usage_gt
4894: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
4895: /*( SELECT * FROM
4896: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
4897: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))

Line 5017: ar_cmgt_curr_usage_gt

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
5016: and CURRENCY IN ( SELECT CURRENCY FROM
5017: ar_cmgt_curr_usage_gt
5018: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5019: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))
5020: group by currency );
5021:

Line 5135: ar_cmgt_curr_usage_gt a

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

Line 5265: ar_cmgt_curr_usage_gt

5261: (sysdate between start_date_active and end_date_active)
5262: )
5263: ))
5264: and CURRENCY IN ( SELECT CURRENCY FROM
5265: ar_cmgt_curr_usage_gt
5266: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5267: group by currency);
5268:
5269:

Line 5367: ar_cmgt_curr_usage_gt

5363: decode(p_org_id,null, org_id, p_org_id), null,
5364: decode(p_org_id,null, org_id, p_org_id))
5365: and cust_account_id = p_cust_account_id
5366: and CURRENCY IN ( SELECT CURRENCY FROM
5367: ar_cmgt_curr_usage_gt
5368: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5369: /* ( SELECT * FROM
5370: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
5371: --and site_use_id = decode(l_analysis_level,'S',p_cust_acct_site_id,site_use_id)

Line 5468: ar_cmgt_curr_usage_gt

5464: SUM(nvl(op_invoices_count,0) - nvl(past_due_inv_inst_count,0)) current_invoice_count
5465: FROM AR_TRX_BAL_SUMMARY
5466: WHERE cust_account_id = p_cust_account_id
5467: and CURRENCY IN ( SELECT CURRENCY FROM
5468: ar_cmgt_curr_usage_gt
5469: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5470: /* ( SELECT * FROM
5471: TABLE(CAST(l_curr_array_list AS curr_array_type))) */
5472: and site_use_id = p_cust_acct_site_id

Line 5519: ar_cmgt_curr_usage_gt

5515: (sysdate between start_date_active and end_date_active)
5516: )
5517: ))
5518: and CURRENCY IN ( SELECT CURRENCY FROM
5519: ar_cmgt_curr_usage_gt
5520: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5521: group by currency);
5522:
5523: CURSOR c_account_numerator_dso IS

Line 5547: ar_cmgt_curr_usage_gt

5543: and org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
5544: decode(p_org_id,null, org_id, p_org_id), null,
5545: decode(p_org_id,null, org_id, p_org_id))
5546: and CURRENCY IN ( SELECT CURRENCY FROM
5547: ar_cmgt_curr_usage_gt
5548: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5549: group by currency);
5550:
5551: CURSOR c_site_numerator_dso IS

Line 5573: ar_cmgt_curr_usage_gt

5569: FROM ar_trx_bal_summary
5570: WHERE cust_account_id = p_cust_account_id
5571: and site_use_id = p_cust_acct_site_id
5572: and CURRENCY IN ( SELECT CURRENCY FROM
5573: ar_cmgt_curr_usage_gt
5574: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5575: group by currency);
5576:
5577: CURSOR c_party_deno_dso IS

Line 5623: ar_cmgt_curr_usage_gt

5619: (sysdate between start_date_active and end_date_active)
5620: )
5621: ))
5622: and CURRENCY IN ( SELECT CURRENCY FROM
5623: ar_cmgt_curr_usage_gt
5624: WHERE nvl(credit_request_id,p_credit_request_id) = p_credit_request_id)
5625: and as_of_date >= (sysdate -l_certified_dso_days)
5626: group by currency);
5627:

Line 5651: ar_cmgt_curr_usage_gt

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)
5653: and org_id = decode(l_global_exposure_flag,'Y', org_id, 'N',
5654: decode(p_org_id,null, org_id, p_org_id), null,
5655: decode(p_org_id,null, org_id, p_org_id))

Line 5682: ar_cmgt_curr_usage_gt

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)
5684: and site_use_id = p_cust_acct_site_id
5685: and as_of_date >= (sysdate -l_certified_dso_days)
5686: group by currency);

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

5869: l_curr_tbl(i).usage_curr_code || ' MISSING RATE');
5870: END IF;
5871: END IF;
5872:
5873: INSERT INTO ar_cmgt_curr_usage_gt ( credit_request_id, currency) values
5874: ( p_credit_request_id, l_curr_tbl(i).usage_curr_code);
5875: END LOOP;
5876: ELSE
5877: -- Populate the GT table with the currencies of the Party active

Line 5882: INSERT INTO ar_cmgt_curr_usage_gt(credit_request_id, currency) VALUES

5878: -- accounts
5879: -- Added by rravikir (Bug 8581475)
5880: FOR c_party_currencies_rec IN c_party_currencies
5881: LOOP
5882: INSERT INTO ar_cmgt_curr_usage_gt(credit_request_id, currency) VALUES
5883: (p_credit_request_id, c_party_currencies_rec.currency);
5884: END LOOP;
5885: -- End (Bug 8581475)
5886:

Line 6307: FROM ar_cmgt_curr_usage_gt

6303: (sysdate between start_date_active and end_date_active)
6304: )
6305: ))
6306: AND CURRENCY IN ( SELECT CURRENCY
6307: FROM ar_cmgt_curr_usage_gt
6308: WHERE nvl(credit_request_id,p_credit_request_id) =
6309: p_credit_request_id)
6310: AND AS_OF_DATE >= ADD_MONTHS(sysdate,(-l_period));
6311:

Line 6359: FROM ar_cmgt_curr_usage_gt

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
6358: AND CURRENCY IN ( SELECT CURRENCY
6359: FROM ar_cmgt_curr_usage_gt
6360: WHERE nvl(credit_request_id,p_credit_request_id) =
6361: p_credit_request_id)
6362: AND AS_OF_DATE >= ADD_MONTHS(sysdate,(-l_period));
6363:

Line 6407: FROM ar_cmgt_curr_usage_gt a

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) =
6409: p_credit_request_id)
6410: AND AS_OF_DATE >= ADD_MONTHS(sysdate,(-l_period))
6411: AND SITE_USE_ID = p_cust_acct_site_id;