APPS.ARP_DET_DIST_PKG dependencies on RA_AR_AMOUNTS_GT

Line 2915: SELECT /*+ leading(b) INDEX (b ra_ar_n1) INDEX( d RA_AR_AMOUNTS_GT_N1 )

2911: p_customer_trx_id IN NUMBER,
2912: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
2913: IS
2914: CURSOR c_read_for_line IS
2915: SELECT /*+ leading(b) INDEX (b ra_ar_n1) INDEX( d RA_AR_AMOUNTS_GT_N1 )
2916: use_nl(D) */
2917: b.group_id||'-'||b.line_type||'-'||
2918: b.ref_customer_trx_id || '-' ||
2919: b.ref_customer_trx_line_id groupe,

Line 3013: RA_AR_AMOUNTS_GT d

3009: -- Rowid
3010: b.rowid,
3011: b.line_type
3012: FROM RA_AR_GT b,
3013: RA_AR_AMOUNTS_GT d
3014: WHERE b.gt_id = p_gt_id
3015: AND b.ref_customer_trx_id = p_customer_trx_id
3016: AND b.gp_level = 'L'
3017: AND d.gt_id = b.gt_id

Line 4513: INSERT INTO RA_AR_AMOUNTS_GT (

4509:
4510: ---------------------------------
4511: -- Determine the bucket for group
4512: ---------------------------------
4513: INSERT INTO RA_AR_AMOUNTS_GT (
4514: gt_id
4515: ,gp_level
4516: ,base_rec_rowid
4517: ,ref_customer_trx_id

Line 5510: INSERT INTO RA_AR_AMOUNTS_GT (

5506: -- update_group_line(p_gt_id => p_gt_id,
5507: -- p_customer_trx_id => p_customer_trx_id);
5508:
5509: --replaced the update with an insert for better performance[Bug 6454022]
5510: INSERT INTO RA_AR_AMOUNTS_GT (
5511: gt_id ,
5512: gp_level,
5513: base_rec_rowid,
5514: ref_customer_trx_id ,

Line 5601: SELECT /*+INDEX(c ra_ar_n1) INDEX(b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/

5597: buc_uned_chrg_alloc_acctd_amt
5598: )
5599:
5600:
5601: SELECT /*+INDEX(c ra_ar_n1) INDEX(b ra_ar_n1) INDEX(d RA_AR_AMOUNTS_GT_N1)*/
5602: c.gt_id
5603: ,b.gp_level
5604: ,b.rowid
5605: ,c.ref_customer_trx_id

Line 5890: RA_AR_AMOUNTS_GT d

5886: ,c.TL_UNED_CHRG_ALLOC_AMT
5887: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
5888: FROM RA_AR_GT b,
5889: RA_AR_GT c,
5890: RA_AR_AMOUNTS_GT d
5891: WHERE b.gt_id = p_gt_id
5892: -- AND b.se_gt_id = g_se_gt_id
5893: AND b.ref_customer_trx_id = p_customer_trx_id
5894: AND b.gp_level = 'L'

Line 10333: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE

10329:
10330: PROCEDURE insert_ra_ar_gt
10331: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
10332: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
10333: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
10334: )
10335: IS
10336: l_rows NUMBER;
10337: l_base_rowid ROWID;

Line 10624: INSERT INTO RA_AR_AMOUNTS_GT

10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE
10622: );
10623:
10624: INSERT INTO RA_AR_AMOUNTS_GT
10625: (
10626: gt_id
10627: ,gp_level
10628: ,base_rec_rowid

Line 10730: ,p_ra_ar_amounts_gt.base_pro_amt

10726: ,l_base_rowid
10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --

Line 10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt

10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT

Line 10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT

10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT

Line 10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT

10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT

Line 10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT

10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --

Line 10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT

10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt

Line 10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT

10733: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_ACCTD_AMT
10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt

Line 10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT

10734: --
10735: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_AMT
10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT

Line 10740: ,p_ra_ar_amounts_gt.elmt_pro_amt

10736: ,p_ra_ar_amounts_gt.BASE_FRT_PRO_ACCTD_AMT
10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --

Line 10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt

10737: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_AMT
10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT

Line 10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT

10738: ,p_ra_ar_amounts_gt.BASE_TAX_PRO_ACCTD_AMT
10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT

Line 10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT

10739: --
10740: ,p_ra_ar_amounts_gt.elmt_pro_amt
10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT

Line 10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT

10741: ,p_ra_ar_amounts_gt.elmt_pro_acctd_amt
10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --

Line 10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT

10742: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_AMT
10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt

Line 10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT

10743: ,p_ra_ar_amounts_gt.ELMT_CHRG_PRO_ACCTD_AMT
10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt

Line 10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT

10744: --
10745: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_AMT
10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt

Line 10750: ,p_ra_ar_amounts_gt.buc_alloc_amt

10746: ,p_ra_ar_amounts_gt.ELMT_FRT_PRO_ACCTD_AMT
10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --

Line 10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt

10747: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_AMT
10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt

Line 10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt

10748: ,p_ra_ar_amounts_gt.ELMT_TAX_PRO_ACCTD_AMT
10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt

Line 10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt

10749: --
10750: ,p_ra_ar_amounts_gt.buc_alloc_amt
10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt

Line 10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt

10751: ,p_ra_ar_amounts_gt.buc_alloc_acctd_amt
10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:

Line 10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt

10752: ,p_ra_ar_amounts_gt.buc_chrg_alloc_amt
10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT

Line 10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt

10753: ,p_ra_ar_amounts_gt.buc_chrg_alloc_acctd_amt
10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT

Line 10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt

10754: --
10755: ,p_ra_ar_amounts_gt.buc_frt_alloc_amt
10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT

Line 10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT

10756: ,p_ra_ar_amounts_gt.buc_frt_alloc_acctd_amt
10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --

Line 10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT

10757: ,p_ra_ar_amounts_gt.buc_tax_alloc_amt
10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT

Line 10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT

10758: ,p_ra_ar_amounts_gt.buc_tax_alloc_acctd_amt
10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT

Line 10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT

10759:
10760: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_AMT
10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT

Line 10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT

10761: ,p_ra_ar_amounts_gt.BUC_ED_ALLOC_ACCTD_AMT
10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --

Line 10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT

10762: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_AMT
10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT

Line 10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT

10763: ,p_ra_ar_amounts_gt.BUC_ED_CHRG_ALLOC_ACCTD_AMT
10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT

Line 10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT

10764: --
10765: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_AMT
10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT

Line 10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT

10766: ,p_ra_ar_amounts_gt.BUC_ED_FRT_ALLOC_ACCTD_AMT
10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --

Line 10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT

10767: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_AMT
10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT

Line 10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT

10768: ,p_ra_ar_amounts_gt.BUC_ED_TAX_ALLOC_ACCTD_AMT
10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT

Line 10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT

10769: --
10770: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_AMT
10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT

Line 10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT

10771: ,p_ra_ar_amounts_gt.ELMT_ED_PRO_ACCTD_AMT
10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --

Line 10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT

10772: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_AMT
10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT

Line 10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT

10773: ,p_ra_ar_amounts_gt.ELMT_ED_CHRG_PRO_ACCTD_AMT
10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT

Line 10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT

10774: --
10775: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_AMT
10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT

Line 10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT

10776: ,p_ra_ar_amounts_gt.ELMT_ED_FRT_PRO_ACCTD_AMT
10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --

Line 10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT

10777: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_AMT
10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT

Line 10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT

10778: ,p_ra_ar_amounts_gt.ELMT_ED_TAX_PRO_ACCTD_AMT
10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT

Line 10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT

10779: --
10780: ,p_ra_ar_amounts_gt.BASE_ED_PRO_AMT
10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT

Line 10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT

10781: ,p_ra_ar_amounts_gt.BASE_ED_PRO_ACCTD_AMT
10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:

Line 10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT

10782: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_AMT
10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT

Line 10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT

10783: ,p_ra_ar_amounts_gt.BASE_ED_CHRG_PRO_ACCTD_AMT
10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT

Line 10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT

10784: --
10785: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_AMT
10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT

Line 10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT

10786: ,p_ra_ar_amounts_gt.BASE_ED_FRT_PRO_ACCTD_AMT
10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --

Line 10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT

10787: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_AMT
10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT

Line 10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT

10788: ,p_ra_ar_amounts_gt.BASE_ED_TAX_PRO_ACCTD_AMT
10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT

Line 10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT

10789:
10790: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_AMT
10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT

Line 10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT

10791: ,p_ra_ar_amounts_gt.BUC_UNED_ALLOC_ACCTD_AMT
10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --

Line 10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT

10792: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_AMT
10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT

Line 10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT

10793: ,p_ra_ar_amounts_gt.BUC_UNED_CHRG_ALLOC_ACCTD_AMT
10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT

Line 10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT

10794: --
10795: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_AMT
10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT

Line 10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT

10796: ,p_ra_ar_amounts_gt.BUC_UNED_FRT_ALLOC_ACCTD_AMT
10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --

Line 10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT

10797: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_AMT
10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT

Line 10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT

10798: ,p_ra_ar_amounts_gt.BUC_UNED_TAX_ALLOC_ACCTD_AMT
10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT

Line 10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT

10799: --
10800: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_AMT
10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT

Line 10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT

10801: ,p_ra_ar_amounts_gt.ELMT_UNED_PRO_ACCTD_AMT
10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --

Line 10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT

10802: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_AMT
10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT

Line 10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT

10803: ,p_ra_ar_amounts_gt.ELMT_UNED_CHRG_PRO_ACCTD_AMT
10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT

Line 10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT

10804: --
10805: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_AMT
10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT

Line 10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT

10806: ,p_ra_ar_amounts_gt.ELMT_UNED_FRT_PRO_ACCTD_AMT
10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --

Line 10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT

10807: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_AMT
10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT

Line 10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT

10808: ,p_ra_ar_amounts_gt.ELMT_UNED_TAX_PRO_ACCTD_AMT
10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT

Line 10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT

10809: --
10810: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_AMT
10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT

Line 10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT

10811: ,p_ra_ar_amounts_gt.BASE_UNED_PRO_ACCTD_AMT
10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
10818: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
10819: );

Line 10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT

10812: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_AMT
10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
10818: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
10819: );
10820: l_rows := sql%rowcount;

Line 10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT

10813: ,p_ra_ar_amounts_gt.BASE_UNED_CHRG_PRO_ACCTD_AMT
10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
10818: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
10819: );
10820: l_rows := sql%rowcount;
10821: IF PG_DEBUG = 'Y' THEN

Line 10818: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT

10814: --
10815: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_AMT
10816: ,p_ra_ar_amounts_gt.BASE_UNED_FRT_PRO_ACCTD_AMT
10817: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_AMT
10818: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
10819: );
10820: l_rows := sql%rowcount;
10821: IF PG_DEBUG = 'Y' THEN
10822: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);

Line 10904: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;

10900: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
10901: IS
10902: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10903: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
10904: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
10905: BEGIN
10906: --Rev line boundary
10907: IF NVL(p_adj_rec.line_adjusted,0) <> 0 AND
10908: NVL(p_sum_line_orig_amt,0) = 0 AND

Line 10958: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
10958: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
10959: );
10960: END IF;
10961:
10962: --Charge boundary is part of line boundary estimation because frt over revenue line

Line 11014: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11014: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11015: );
11016: END IF;
11017:
11018: --Frt boundary is part of line boundary estimation because frt over revenue line

Line 11070: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11070: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11071: );
11072: END IF;
11073: END line_boundary;
11074:

Line 11087: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;

11083: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
11084: IS
11085: l_ra_ar_gt ra_ar_gt%ROWTYPE;
11086: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
11087: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
11088: BEGIN
11089: IF NVL(p_adj_rec.tax_adjusted,0) <> 0 AND
11090: NVL(p_sum_line_tax_orig_amt,0) = 0 AND
11091: NVL(p_sum_line_tax_rem_amt,0) = 0

Line 11153: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11153: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11154: );
11155: END IF;
11156: END tax_boundary;
11157: /*

Line 11387: SELECT /*+ leading(B) INDEX(B ra_ar_n1) INDEX(D RA_AR_AMOUNTS_GT_N1)*/

11383: p_customer_trx_id IN NUMBER,
11384: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11385: IS
11386: CURSOR c_read_for_gline IS
11387: SELECT /*+ leading(B) INDEX(B ra_ar_n1) INDEX(D RA_AR_AMOUNTS_GT_N1)*/
11388: b.group_id groupe,
11389: -- ADJ AND APP
11390: --Base
11391: d.base_pro_amt,

Line 11482: RA_AR_AMOUNTS_GT d

11478: -- Rowid
11479: b.rowid,
11480: b.line_type
11481: FROM RA_AR_GT b,
11482: RA_AR_AMOUNTS_GT d
11483: WHERE b.gt_id = p_gt_id
11484: AND b.ref_customer_trx_id = p_customer_trx_id
11485: AND b.gp_level = 'GPL'
11486: AND d.gt_id = b.gt_id