APPS.AR_UNPOSTED_ITEM_UPG dependencies on RA_AR_GT

Line 150: INSERT INTO RA_AR_GT

146:
147: -------------------------------------------
148: -- Get all invoices for the applications
149: -------------------------------------------
150: INSERT INTO RA_AR_GT
151: ( GT_ID ,
152: AMT ,
153: ACCTD_AMT ,
154: ACCOUNT_CLASS ,

Line 363: INSERT INTO RA_AR_GT

359:
360: -------------------------------------------------------
361: -- Get the adjustments on those invoice being applied
362: -------------------------------------------------------
363: INSERT INTO RA_AR_GT
364: ( GT_ID ,
365: AMT ,
366: ACCTD_AMT ,
367: ACCOUNT_CLASS ,

Line 622: FROM ra_ar_gt

618: ar_distributions_all ard,
619: ar_system_parameters_all ars,
620: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
621: MAX(to_currency) invoice_currency_code
622: FROM ra_ar_gt
623: GROUP BY ref_customer_trx_id, to_currency) trx
624: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
625: AND adj.status = 'A'
626: AND adj.postable = 'Y'

Line 751: FROM ra_ar_gt b

747: SUM(NVL(b.DIST_uned_tax_AMT,0)) sum_dist_uned_tax_amt,
748: SUM(NVL(b.DIST_uned_tax_ACCTD_AMT,0)) sum_dist_uned_tax_acctd_amt,
749: b.ref_customer_trx_id ref_customer_trx_id,
750: b.gt_id gt_id
751: FROM ra_ar_gt b
752: GROUP BY b.ref_customer_trx_id,
753: b.gt_id ) s,
754: ra_ar_gt a
755: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id

Line 754: ra_ar_gt a

750: b.gt_id gt_id
751: FROM ra_ar_gt b
752: GROUP BY b.ref_customer_trx_id,
753: b.gt_id ) s,
754: ra_ar_gt a
755: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id
756: AND a.gt_id = s.gt_id;
757:
758: -- Cash Basis

Line 936: INSERT INTO RA_AR_GT

932:
933: -------------------------------------------
934: -- Get all invoices for the applications
935: -------------------------------------------
936: INSERT INTO RA_AR_GT
937: ( GT_ID ,
938: AMT ,
939: ACCTD_AMT ,
940: ACCOUNT_CLASS ,

Line 1251: FROM ra_ar_gt b

1247: SUM(NVL(b.DIST_uned_tax_AMT,0)) sum_dist_uned_tax_amt,
1248: SUM(NVL(b.DIST_uned_tax_ACCTD_AMT,0)) sum_dist_uned_tax_acctd_amt,
1249: b.ref_customer_trx_id ref_customer_trx_id,
1250: b.gt_id gt_id
1251: FROM ra_ar_gt b
1252: GROUP BY b.ref_customer_trx_id,
1253: b.gt_id ) s,
1254: ra_ar_gt a
1255: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id

Line 1254: ra_ar_gt a

1250: b.gt_id gt_id
1251: FROM ra_ar_gt b
1252: GROUP BY b.ref_customer_trx_id,
1253: b.gt_id ) s,
1254: ra_ar_gt a
1255: WHERE a.ref_customer_trx_id = s.ref_customer_trx_id
1256: AND a.gt_id = s.gt_id;
1257:
1258: -- Cash Basis