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 456: AND NOT EXISTS (SELECT '1' FROM RA_AR_GT

452: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
453: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
454: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
455: AND ctlgd.account_set_flag = 'N'
456: AND NOT EXISTS (SELECT '1' FROM RA_AR_GT
457: WHERE source_table = 'CTLGD'
458: AND REF_CUSTOMER_TRX_ID = p_trx_id );
459:
460: ELSIF p_mode = 'BATCH' THEN

Line 462: INSERT INTO RA_AR_GT

458: AND REF_CUSTOMER_TRX_ID = p_trx_id );
459:
460: ELSIF p_mode = 'BATCH' THEN
461:
462: INSERT INTO RA_AR_GT
463: ( GT_ID ,
464: AMT ,
465: ACCTD_AMT ,
466: ACCOUNT_CLASS ,

Line 738: INSERT INTO RA_AR_GT

734: log(' p_gt_id :'||p_gt_id);
735:
736: IF p_mode = 'BATCH' THEN
737:
738: INSERT INTO RA_AR_GT
739: ( GT_ID ,
740: AMT ,
741: ACCTD_AMT ,
742: ACCOUNT_CLASS ,

Line 975: INSERT INTO RA_AR_GT

971: log(' p_mode : '|| p_mode);
972: log(' p_trx_id : '|| p_trx_id);
973: log(' p_gt_id : '|| p_gt_id);
974: IF p_mode = 'OLTP' THEN
975: INSERT INTO RA_AR_GT
976: ( GT_ID ,
977: AMT ,
978: ACCTD_AMT ,
979: ACCOUNT_CLASS ,

Line 1230: FROM ra_ar_gt

1226: FROM ar_adjustments adj,
1227: ar_distributions ard,
1228: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1229: MAX(to_currency) invoice_currency_code
1230: FROM ra_ar_gt
1231: WHERE gt_id = p_gt_id
1232: GROUP BY ref_customer_trx_id, to_currency) trx
1233: WHERE adj.customer_trx_id= p_trx_id
1234: AND adj.customer_trx_id= trx.ref_customer_trx_id

Line 1259: INSERT INTO RA_AR_GT

1255: 'N') = 'Y';
1256:
1257: ELSIF p_mode = 'BATCH' THEN
1258:
1259: INSERT INTO RA_AR_GT
1260: ( GT_ID ,
1261: AMT ,
1262: ACCTD_AMT ,
1263: ACCOUNT_CLASS ,

Line 1517: FROM ra_ar_gt

1513: ar_distributions_all ard,
1514: ar_system_parameters_all ars,
1515: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1516: MAX(to_currency) invoice_currency_code
1517: FROM ra_ar_gt
1518: GROUP BY ref_customer_trx_id, to_currency) trx
1519: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1520: AND adj.status = 'A'
1521: AND adj.postable = 'Y'

Line 1566: INSERT INTO RA_AR_GT

1562: log(' p_mode : '||p_mode);
1563: log(' p_gt_id : '||p_gt_id);
1564:
1565: IF p_mode = 'BATCH' THEN
1566: INSERT INTO RA_AR_GT
1567: ( GT_ID ,
1568: AMT ,
1569: ACCTD_AMT ,
1570: ACCOUNT_CLASS ,

Line 1746: FROM ra_ar_gt

1742: FROM ar_adjustments_all adj,
1743: psa_mf_adj_dist_all psad,
1744: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1745: MAX(to_currency) invoice_currency_code
1746: FROM ra_ar_gt
1747: GROUP BY ref_customer_trx_id, to_currency) trx,
1748: ra_customer_trx_lines_all ctl,
1749: ra_cust_trx_line_gl_dist_all ctlgd
1750: WHERE adj.customer_trx_id = trx.ref_customer_trx_id

Line 1784: INSERT INTO RA_AR_GT

1780: log(' p_trx_id : '|| p_trx_id);
1781: log(' p_gt_id : '|| p_gt_id);
1782:
1783: IF p_mode = 'BATCH' THEN
1784: INSERT INTO RA_AR_GT
1785: ( GT_ID ,
1786: AMT ,
1787: ACCTD_AMT ,
1788: ACCOUNT_CLASS ,

Line 1990: FROM ra_ar_gt

1986: -- WHERE source_table = 'ADJ'
1987: -- GROUP BY source_id) ard,
1988: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1989: MAX(to_currency) invoice_currency_code
1990: FROM ra_ar_gt
1991: WHERE source_table = 'CTLGD'
1992: GROUP BY ref_customer_trx_id,
1993: to_currency) trx,
1994: gl_sets_of_books sob

Line 2008: INSERT INTO RA_AR_GT

2004:
2005: ELSIF p_mode = 'OLTP' THEN
2006:
2007:
2008: INSERT INTO RA_AR_GT
2009: ( GT_ID ,
2010: AMT ,
2011: ACCTD_AMT ,
2012: ACCOUNT_CLASS ,

Line 2205: FROM ra_ar_gt

2201: , NULL -- ref_line_id
2202: FROM ar_adjustments adj,
2203: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2204: MAX(to_currency) invoice_currency_code
2205: FROM ra_ar_gt
2206: WHERE gt_id = p_gt_id
2207: GROUP BY ref_customer_trx_id, to_currency) trx,
2208: gl_sets_of_books sob
2209: WHERE adj.customer_trx_id = p_trx_id

Line 2340: FROM ra_ar_gt b

2336: SUM(NVL(b.DIST_uned_tax_AMT,0)) sum_dist_uned_tax_amt,
2337: SUM(NVL(b.DIST_uned_tax_ACCTD_AMT,0)) sum_dist_uned_tax_acctd_amt,
2338: b.ref_customer_trx_id ref_customer_trx_id,
2339: b.gt_id gt_id
2340: FROM ra_ar_gt b
2341: GROUP BY b.ref_customer_trx_id,
2342: b.gt_id ) s,
2343: ra_ar_gt a
2344: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id

Line 2343: ra_ar_gt a

2339: b.gt_id gt_id
2340: FROM ra_ar_gt b
2341: GROUP BY b.ref_customer_trx_id,
2342: b.gt_id ) s,
2343: ra_ar_gt a
2344: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id
2345: AND a.gt_id = s.gt_id
2346: AND a.gt_id = NVL(p_gt_id,a.gt_id);
2347:

Line 2558: DELETE FROM ra_ar_gt;

2554: BEGIN
2555: log('create_cash_distributions +');
2556:
2557:
2558: DELETE FROM ra_ar_gt;
2559:
2560: -- Get the distributions ready
2561: get_direct_inv_dist(p_mode => 'BATCH');
2562:

Line 2731: DELETE FROM ra_ar_gt;

2727:
2728: log('create_mfar_distributions +');
2729:
2730:
2731: DELETE FROM ra_ar_gt;
2732:
2733: -- Get the distributions ready
2734: get_direct_mf_inv_dist(p_mode => 'BATCH');
2735: