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.ARP_DET_DIST_PKG dependencies on AR_BASE_DIST_AMTS_GT

Line 7134: INSERT INTO AR_BASE_DIST_AMTS_GT

7130: END IF; -- g_mode_process <> 'R12_11iCASH'
7131: END IF;
7132:
7133: --Populate base distribution amounts
7134: INSERT INTO AR_BASE_DIST_AMTS_GT
7135: ( gt_id
7136: ,gp_level
7137: ,ref_customer_trx_id
7138: ,ref_customer_trx_line_id

Line 7215: localdebug(' rows inserted(ar_base_dist_amts_gt) = ' || l_rows);

7211: --
7212:
7213: l_rows := sql%rowcount;
7214: IF PG_DEBUG = 'Y' THEN
7215: localdebug(' rows inserted(ar_base_dist_amts_gt) = ' || l_rows);
7216:
7217: localdebug('arp_det_dist_pkg.get_inv_dist()-');
7218: END IF;
7219: END get_inv_dist;

Line 7230: SELECT /+ leading (A) index(A ra_ar_n1) INDEX(B ar_base_dist_amts_gt_n1)/

7226: IS
7227: l_rows NUMBER;
7228:
7229: CURSOR c_read_for_line IS
7230: SELECT /*+ leading (A) index(A ra_ar_n1) INDEX(B ar_base_dist_amts_gt_n1)*/
7231: line_type||'-'||a.ref_customer_trx_id||'-'||a.ref_customer_trx_line_id groupe,
7232: -- ADJ and APP
7233: --Base
7234: b.BASE_dist_AMT, --Base for Revenue distributions

Line 7322: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]

7318: TO_CURRENCY ,
7319: FROM_CURRENCY ,
7320: -- Rowid
7321: a.rowid
7322: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]
7323: WHERE a.gt_id = p_gt_id
7324: -- AND se_gt_id = g_se_gt_id
7325: AND a.ref_customer_trx_id = p_customer_trx_id
7326: AND a.ref_cust_trx_line_gl_dist_id IS NOT NULL

Line 8903: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,

8899:
8900:
8901: PROCEDURE insert_ra_ar_gt
8902: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
8903: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
8904: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
8905: )
8906: IS
8907: l_rows NUMBER;

Line 9161: INSERT INTO AR_BASE_DIST_AMTS_GT

9157: localdebug(' rows inserted = ' || l_rows);
9158: END IF;
9159:
9160:
9161: INSERT INTO AR_BASE_DIST_AMTS_GT
9162: (
9163: gt_id
9164: ,gp_level
9165: ,ref_customer_trx_id

Line 9183: ,p_ar_base_dist_amts_gt.base_dist_amt

9179: p_ra_ar_gt.gt_id
9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt

Line 9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt

9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt

Line 9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt

9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID

Line 9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt

9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE

Line 9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt

9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE

Line 9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt

9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE
9192: );

Line 9392: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);

9388: ,p_ra_ar_amounts_gt.BASE_UNED_TAX_PRO_ACCTD_AMT
9389: );
9390: l_rows := sql%rowcount;
9391: IF PG_DEBUG = 'Y' THEN
9392: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);
9393: END IF;
9394: END insert_ra_ar_gt;
9395:
9396:

Line 9473: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

9469: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
9470: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9471: IS
9472: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9473: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9474: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9475: BEGIN
9476: --Rev line boundary
9477: IF NVL(p_adj_rec.line_adjusted,0) <> 0 AND

Line 9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;

9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';

Line 9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9529: );
9530: END IF;
9531:

Line 9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;

9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';

Line 9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9585: );
9586: END IF;
9587:

Line 9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;

9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';

Line 9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,

9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9641: );
9642: END IF;
9643: END line_boundary;

Line 9656: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

9652: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
9653: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9654: IS
9655: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9656: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9657: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9658: BEGIN
9659: IF NVL(p_adj_rec.tax_adjusted,0) <> 0 AND
9660: NVL(p_sum_line_tax_orig_amt,0) = 0 AND

Line 9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;

9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';

Line 9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9711: );
9712: END IF;
9713: END tax_boundary;

Line 15685: UPDATE ar_base_dist_amts_gt

15681: , source_table ='RA'
15682: , base_currency = p_ae_sys_rec.base_currency
15683: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;
15684:
15685: UPDATE ar_base_dist_amts_gt
15686: set gt_id = p_gt_id
15687: , source_id = p_app_rec.receivable_application_id
15688: , source_table ='RA'
15689: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;

Line 15728: UPDATE ar_base_dist_amts_gt

15724: ,source_table = 'RA'
15725: ,base_currency = p_ae_sys_rec.base_currency
15726: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;
15727:
15728: UPDATE ar_base_dist_amts_gt
15729: set gt_id = p_gt_id
15730: , source_id = p_app_rec.receivable_application_id
15731: , source_table ='RA'
15732: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;

Line 16322: SELECT /+INDEX (a ra_ar_n1) INDEX(ar_base_dist_amts_gt b)/

16318:
16319:
16320: CURSOR cu_cm_balance(p_customer_trx_id IN NUMBER, p_gt_id IN VARCHAR2)
16321: IS
16322: SELECT /*+INDEX (a ra_ar_n1) INDEX(ar_base_dist_amts_gt b)*/
16323: b.base_dist_amt line_balance,
16324: b.base_dist_tax_amt tax_balance,
16325: b.base_dist_frt_amt freight_balance,
16326: b.base_dist_chrg_amt charges_balance,

Line 16328: FROM ra_ar_gt a,ar_base_dist_amts_gt b

16324: b.base_dist_tax_amt tax_balance,
16325: b.base_dist_frt_amt freight_balance,
16326: b.base_dist_chrg_amt charges_balance,
16327: a.to_currency invoice_currency_code
16328: FROM ra_ar_gt a,ar_base_dist_amts_gt b
16329: WHERE a.ref_customer_trx_id = p_customer_trx_id
16330: AND b.gt_id = a.gt_id
16331: AND b.gp_level = 'D'
16332: AND a.ref_customer_trx_id = b.ref_customer_trx_id