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 8473: INSERT INTO AR_BASE_DIST_AMTS_GT

8469: END IF; -- g_mode_process <> 'R12_11iCASH'
8470: END IF;
8471:
8472: --Populate base distribution amounts
8473: INSERT INTO AR_BASE_DIST_AMTS_GT
8474: ( gt_id
8475: ,gp_level
8476: ,ref_customer_trx_id
8477: ,ref_customer_trx_line_id

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

8550: --
8551:
8552: l_rows := sql%rowcount;
8553: IF PG_DEBUG = 'Y' THEN
8554: localdebug(' rows inserted(ar_base_dist_amts_gt) = ' || l_rows);
8555:
8556: localdebug('arp_det_dist_pkg.get_inv_dist()-');
8557: END IF;
8558: END get_inv_dist;

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

8565: IS
8566: l_rows NUMBER;
8567:
8568: CURSOR c_read_for_line IS
8569: SELECT /*+ leading (A) index(A ra_ar_n1) INDEX(B ar_base_dist_amts_gt_n1)*/
8570: line_type||'-'||a.ref_customer_trx_id||'-'||a.ref_customer_trx_line_id groupe,
8571: -- ADJ and APP
8572: --Base
8573: b.BASE_dist_AMT, --Base for Revenue distributions

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

8658: FROM_CURRENCY ,
8659: -- Rowid
8660: a.rowid,
8661: a.line_type
8662: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]
8663: WHERE a.gt_id = p_gt_id
8664: -- AND se_gt_id = g_se_gt_id
8665: AND a.ref_customer_trx_id = p_customer_trx_id
8666: AND a.ref_cust_trx_line_gl_dist_id IS NOT NULL

Line 8679: --source_table is populated in AR_BASE_DIST_AMTS_GT only for online_lazy_apply flow,the condition

8675: AND a.ref_customer_trx_line_id = b.ref_customer_trx_line_id
8676: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id
8677: AND (b.sob_type = p_ae_sys_rec.sob_type OR (
8678: b.sob_type IS NULL AND p_ae_sys_rec.sob_type IS NULL))
8679: --source_table is populated in AR_BASE_DIST_AMTS_GT only for online_lazy_apply flow,the condition
8680: --is modified to restrict duplicate matching pairs [bug 8359020]
8681: AND nvl( a.source_type,'#$%') =
8682: DECODE( b.source_table,'CTLGD',nvl(b.source_type,'#$%'),
8683: DECODE(b.source_type,null,nvl(a.source_type,'#$%'),b.source_type))

Line 10332: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,

10328:
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;

Line 10591: INSERT INTO AR_BASE_DIST_AMTS_GT

10587: localdebug(' rows inserted = ' || l_rows);
10588: END IF;
10589:
10590:
10591: INSERT INTO AR_BASE_DIST_AMTS_GT
10592: (
10593: gt_id
10594: ,gp_level
10595: ,ref_customer_trx_id

Line 10613: ,p_ar_base_dist_amts_gt.base_dist_amt

10609: p_ra_ar_gt.gt_id
10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt

Line 10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt

10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt

Line 10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt

10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID

Line 10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt

10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE

Line 10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt

10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE

Line 10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt

10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE
10622: );

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

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);
10823: END IF;
10824: END insert_ra_ar_gt;
10825:
10826:

Line 10903: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

10899: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
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

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

10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';

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

10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
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:

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

10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';

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

10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
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:

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

11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';

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

11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
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;

Line 11086: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;

11082: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
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

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

11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11127: p_ae_sys_rec.base_currency);*/
11128: l_ra_ar_gt.tl_tax_alloc_acctd_amt := p_adj_rec.acctd_amount ;
11129: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
11130:
11131: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11133: p_ae_sys_rec.base_currency);*/

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

11128: l_ra_ar_gt.tl_tax_alloc_acctd_amt := p_adj_rec.acctd_amount ;
11129: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
11130:
11131: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11133: p_ae_sys_rec.base_currency);*/
11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';

Line 11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;

11130:
11131: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11133: p_ae_sys_rec.base_currency);*/
11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';

Line 11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
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;

Line 17397: UPDATE ar_base_dist_amts_gt

17393: , source_table ='RA'
17394: , base_currency = p_ae_sys_rec.base_currency
17395: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;
17396:
17397: UPDATE ar_base_dist_amts_gt
17398: set gt_id = p_gt_id
17399: , source_id = p_app_rec.receivable_application_id
17400: , source_table ='RA'
17401: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;

Line 17440: UPDATE ar_base_dist_amts_gt

17436: ,source_table = 'RA'
17437: ,base_currency = p_ae_sys_rec.base_currency
17438: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;
17439:
17440: UPDATE ar_base_dist_amts_gt
17441: set gt_id = p_gt_id
17442: , source_id = p_app_rec.receivable_application_id
17443: , source_table ='RA'
17444: WHERE ref_customer_trx_id = g_cust_inv_rec.customer_trx_id;

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

18037:
18038:
18039: CURSOR cu_cm_balance(p_customer_trx_id IN NUMBER, p_gt_id IN VARCHAR2)
18040: IS
18041: SELECT /*+INDEX (a ra_ar_n1) INDEX(ar_base_dist_amts_gt b)*/
18042: b.base_dist_amt line_balance,
18043: b.base_dist_tax_amt tax_balance,
18044: b.base_dist_frt_amt freight_balance,
18045: b.base_dist_chrg_amt charges_balance,

Line 18047: FROM ra_ar_gt a,ar_base_dist_amts_gt b

18043: b.base_dist_tax_amt tax_balance,
18044: b.base_dist_frt_amt freight_balance,
18045: b.base_dist_chrg_amt charges_balance,
18046: a.to_currency invoice_currency_code
18047: FROM ra_ar_gt a,ar_base_dist_amts_gt b
18048: WHERE a.ref_customer_trx_id = p_customer_trx_id
18049: AND b.gt_id = a.gt_id
18050: AND b.gp_level = 'D'
18051: AND a.ref_customer_trx_id = b.ref_customer_trx_id