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_UPGRADE_CASH_ACCRUAL dependencies on RA_AR_GT

Line 259: INSERT INTO RA_AR_GT

255: log(' p_trx_id :'||p_trx_id);
256: log(' p_gt_id :'||p_gt_id);
257:
258: IF p_mode = 'OLTP' THEN
259: INSERT INTO RA_AR_GT
260: ( GT_ID ,
261: AMT ,
262: ACCTD_AMT ,
263: ACCOUNT_CLASS ,

Line 472: AND NOT EXISTS (SELECT '1' FROM RA_AR_GT

468: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
469: AND ctl.customer_trx_line_id = taxx.link_to_cust_trx_line_id(+)
470: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
471: AND ctlgd.account_set_flag = 'N'
472: AND NOT EXISTS (SELECT '1' FROM RA_AR_GT
473: WHERE source_table = 'CTLGD'
474: AND REF_CUSTOMER_TRX_ID = p_trx_id );
475:
476: ELSIF p_mode = 'BATCH' THEN

Line 478: INSERT INTO RA_AR_GT

474: AND REF_CUSTOMER_TRX_ID = p_trx_id );
475:
476: ELSIF p_mode = 'BATCH' THEN
477:
478: INSERT INTO RA_AR_GT
479: ( GT_ID ,
480: AMT ,
481: ACCTD_AMT ,
482: ACCOUNT_CLASS ,

Line 764: INSERT INTO RA_AR_GT

760: log(' p_gt_id :'||p_gt_id);
761:
762: IF p_mode = 'BATCH' THEN
763:
764: INSERT INTO RA_AR_GT
765: ( GT_ID ,
766: AMT ,
767: ACCTD_AMT ,
768: ACCOUNT_CLASS ,

Line 1001: INSERT INTO RA_AR_GT

997: log(' p_mode : '|| p_mode);
998: log(' p_trx_id : '|| p_trx_id);
999: log(' p_gt_id : '|| p_gt_id);
1000: IF p_mode = 'OLTP' THEN
1001: INSERT INTO RA_AR_GT
1002: ( GT_ID ,
1003: AMT ,
1004: ACCTD_AMT ,
1005: ACCOUNT_CLASS ,

Line 1344: FROM ra_ar_gt

1340: and rownum = 1
1341: ) taxx,
1342: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1343: MAX(to_currency) invoice_currency_code
1344: FROM ra_ar_gt
1345: WHERE gt_id = p_gt_id
1346: GROUP BY ref_customer_trx_id, to_currency) trx
1347: WHERE adj.customer_trx_id= p_trx_id
1348: AND adj.customer_trx_id= trx.ref_customer_trx_id

Line 1374: INSERT INTO RA_AR_GT

1370: 'N') = 'Y';
1371:
1372: ELSIF p_mode = 'BATCH' THEN
1373:
1374: INSERT INTO RA_AR_GT
1375: ( GT_ID ,
1376: AMT ,
1377: ACCTD_AMT ,
1378: ACCOUNT_CLASS ,

Line 1715: FROM ra_ar_gt

1711: ar_distributions_all ard,
1712: ar_system_parameters_all ars,
1713: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1714: MAX(to_currency) invoice_currency_code
1715: FROM ra_ar_gt
1716: GROUP BY ref_customer_trx_id, to_currency) trx
1717: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1718: AND adj.status = 'A'
1719: AND adj.postable = 'Y'

Line 1764: INSERT INTO RA_AR_GT

1760: log(' p_mode : '||p_mode);
1761: log(' p_gt_id : '||p_gt_id);
1762:
1763: IF p_mode = 'BATCH' THEN
1764: INSERT INTO RA_AR_GT
1765: ( GT_ID ,
1766: AMT ,
1767: ACCTD_AMT ,
1768: ACCOUNT_CLASS ,

Line 1944: FROM ra_ar_gt

1940: FROM ar_adjustments_all adj,
1941: psa_mf_adj_dist_all psad,
1942: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1943: MAX(to_currency) invoice_currency_code
1944: FROM ra_ar_gt
1945: GROUP BY ref_customer_trx_id, to_currency) trx,
1946: ra_customer_trx_lines_all ctl,
1947: ra_cust_trx_line_gl_dist_all ctlgd
1948: WHERE adj.customer_trx_id = trx.ref_customer_trx_id

Line 1982: INSERT INTO RA_AR_GT

1978: log(' p_trx_id : '|| p_trx_id);
1979: log(' p_gt_id : '|| p_gt_id);
1980:
1981: IF p_mode = 'BATCH' THEN
1982: INSERT INTO RA_AR_GT
1983: ( GT_ID ,
1984: AMT ,
1985: ACCTD_AMT ,
1986: ACCOUNT_CLASS ,

Line 2188: FROM ra_ar_gt

2184: -- WHERE source_table = 'ADJ'
2185: -- GROUP BY source_id) ard,
2186: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2187: MAX(to_currency) invoice_currency_code
2188: FROM ra_ar_gt
2189: WHERE source_table = 'CTLGD'
2190: GROUP BY ref_customer_trx_id,
2191: to_currency) trx,
2192: gl_sets_of_books sob

Line 2206: INSERT INTO RA_AR_GT

2202:
2203: ELSIF p_mode = 'OLTP' THEN
2204:
2205:
2206: INSERT INTO RA_AR_GT
2207: ( GT_ID ,
2208: AMT ,
2209: ACCTD_AMT ,
2210: ACCOUNT_CLASS ,

Line 2404: FROM ra_ar_gt

2400: FROM ar_adjustments adj,
2401: ar_system_parameters_all ars,
2402: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2403: MAX(to_currency) invoice_currency_code
2404: FROM ra_ar_gt
2405: WHERE gt_id = p_gt_id
2406: GROUP BY ref_customer_trx_id, to_currency) trx,
2407: gl_sets_of_books sob
2408: WHERE adj.customer_trx_id = p_trx_id

Line 2559: FROM ra_ar_gt b

2555: SUM(NVL(b.DIST_uned_tax_AMT,0)) sum_dist_uned_tax_amt,
2556: SUM(NVL(b.DIST_uned_tax_ACCTD_AMT,0)) sum_dist_uned_tax_acctd_amt,
2557: b.ref_customer_trx_id ref_customer_trx_id,
2558: b.gt_id gt_id
2559: FROM ra_ar_gt b
2560: GROUP BY b.ref_customer_trx_id,
2561: b.gt_id ) s,
2562: ra_ar_gt a
2563: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id

Line 2562: ra_ar_gt a

2558: b.gt_id gt_id
2559: FROM ra_ar_gt b
2560: GROUP BY b.ref_customer_trx_id,
2561: b.gt_id ) s,
2562: ra_ar_gt a
2563: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id
2564: AND a.gt_id = s.gt_id
2565: AND a.gt_id = NVL(p_gt_id,a.gt_id);
2566:

Line 2777: DELETE FROM ra_ar_gt;

2773: BEGIN
2774: log('create_cash_distributions +');
2775:
2776:
2777: DELETE FROM ra_ar_gt;
2778:
2779: -- Get the distributions ready
2780: get_direct_inv_dist(p_mode => 'BATCH');
2781:

Line 2950: DELETE FROM ra_ar_gt;

2946:
2947: log('create_mfar_distributions +');
2948:
2949:
2950: DELETE FROM ra_ar_gt;
2951:
2952: -- Get the distributions ready
2953: get_direct_mf_inv_dist(p_mode => 'BATCH');
2954: