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_LINE_APP_DETAIL_GT

Line 9023: INSERT INTO AR_LINE_APP_DETAIL_GT

9019: END IF;
9020:
9021: --Monoparsing
9022: IF g_upgrade_mode = 'Y' THEN
9023: INSERT INTO AR_LINE_APP_DETAIL_GT
9024: ( DET_ID
9025: ,APP_LEVEL
9026: ,GROUP_ID
9027: ,source_data_key1

Line 9208: INSERT INTO AR_LINE_APP_DETAIL_GT

9204:
9205: -- l_rows := sql%rowcount;
9206: -- localdebug(' rows inserted = ' || l_rows);
9207: ELSE
9208: INSERT INTO AR_LINE_APP_DETAIL_GT
9209: ( DET_ID ,
9210: APP_LEVEL ,
9211: GROUP_ID ,
9212: source_data_key1 ,

Line 9403: UPDATE /+INDEX (APP_OUT AR_LINE_APP_DETAIL_GT_N1) /

9399: p_customer_trx_id => p_customer_trx_id,
9400: p_ae_sys_rec => p_ae_sys_rec);*/
9401: --}
9402:
9403: UPDATE /*+INDEX (APP_OUT AR_LINE_APP_DETAIL_GT_N1) */
9404: AR_LINE_APP_DETAIL_GT app_out
9405: SET (taxable_amount, taxable_acctd_amount)
9406: =
9407: (SELECT /*+INDEX (APP_IN AR_LINE_APP_DETAIL_GT_N1) */

Line 9404: AR_LINE_APP_DETAIL_GT app_out

9400: p_ae_sys_rec => p_ae_sys_rec);*/
9401: --}
9402:
9403: UPDATE /*+INDEX (APP_OUT AR_LINE_APP_DETAIL_GT_N1) */
9404: AR_LINE_APP_DETAIL_GT app_out
9405: SET (taxable_amount, taxable_acctd_amount)
9406: =
9407: (SELECT /*+INDEX (APP_IN AR_LINE_APP_DETAIL_GT_N1) */
9408: DECODE(app_out.activity_bucket, 'APP_TAX',

Line 9407: (SELECT /+INDEX (APP_IN AR_LINE_APP_DETAIL_GT_N1) /

9403: UPDATE /*+INDEX (APP_OUT AR_LINE_APP_DETAIL_GT_N1) */
9404: AR_LINE_APP_DETAIL_GT app_out
9405: SET (taxable_amount, taxable_acctd_amount)
9406: =
9407: (SELECT /*+INDEX (APP_IN AR_LINE_APP_DETAIL_GT_N1) */
9408: DECODE(app_out.activity_bucket, 'APP_TAX',
9409: SUM(DECODE(activity_bucket,'APP_LINE',amount,
9410: 'ADJ_LINE',amount,
9411: 'APP_CHRG',amount,

Line 9452: FROM AR_LINE_APP_DETAIL_GT app_in

9448: 'UNED_TAX',
9449: SUM(DECODE(activity_bucket,'UNED_LINE',acctd_amount,
9450: 'UNED_CHRG',acctd_amount,
9451: 'UNED_FRT' ,acctd_amount, 0)),0) taxable_acctd_amount
9452: FROM AR_LINE_APP_DETAIL_GT app_in
9453: WHERE gt_id = p_gt_id
9454: AND ref_customer_trx_id = p_customer_trx_id
9455: AND tax_link_id IS NOT NULL
9456: AND tax_link_id = app_out.tax_link_id)

Line 15254: SELECT /+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)/

15250: p_gt_id IN VARCHAR2 DEFAULT NULL,
15251: p_inv_currency IN VARCHAr2 DEFAULT NULL)
15252: IS
15253: CURSOR cu1(p_gt_id IN NUMBER) IS
15254: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
15255: SUM(NVL(amount,0)),
15256: SUM(NVL(acctd_amount,0))
15257: FROM AR_LINE_APP_DETAIL_GT
15258: WHERE gt_id = p_gt_id

Line 15257: FROM AR_LINE_APP_DETAIL_GT

15253: CURSOR cu1(p_gt_id IN NUMBER) IS
15254: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
15255: SUM(NVL(amount,0)),
15256: SUM(NVL(acctd_amount,0))
15257: FROM AR_LINE_APP_DETAIL_GT
15258: WHERE gt_id = p_gt_id
15259: AND activity_bucket IN ('APP_LINE','APP_CHRG','APP_TAX','APP_FRT',
15260: 'ADJ_LINE','ADJ_TAX','ADJ_CHRG','ADJ_FRT')
15261: AND ( NVL(amount,0) <> 0

Line 15300: from ar_line_app_detail_gt

15296: /*Bug7391957, Added following SELECT statement within a BEGIN..END block */
15297: BEGIN
15298: select distinct source_id
15299: into l_source_id
15300: from ar_line_app_detail_gt
15301: where gt_id = l_gt_id
15302: AND source_table ='RA';
15303:
15304: select count(*)

Line 15467: UPDATE AR_LINE_APP_DETAIL_GT a

15463: localdebug(' l_curr_rnd_flag : '||l_curr_rnd_flag);
15464: END IF;
15465:
15466:
15467: UPDATE AR_LINE_APP_DETAIL_GT a
15468: SET(FROM_AMOUNT ,
15469: FROM_ACCTD_AMOUNT ) =
15470: (SELECT DECODE(l_pro_base,0,0,
15471: Accting_Proration_Fct

Line 15490: FROM AR_LINE_APP_DETAIL_GT b

15486: l_inv_currency,
15487: l_from_curr_code,
15488: 'FROM_ACCTD_AMT',
15489: l_curr_rnd_flag))
15490: FROM AR_LINE_APP_DETAIL_GT b
15491: WHERE a.rowid = b.rowid
15492: AND b.gt_id = l_gt_id
15493: AND b.activity_bucket IN
15494: ('APP_LINE','APP_CHRG','APP_TAX','APP_FRT',

Line 15957: from (SELECT /+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)/

15953: TO_CURRENCY ,
15954: FROM_CURRENCY ,
15955: --
15956: rowid
15957: from (SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
15958: tax_link_id groupe,
15959: -- ADJ and APP
15960: --Base
15961: 0 base_pro_amt, --Base for Revenue distributions

Line 16098: FROM AR_LINE_APP_DETAIL_GT

16094: g_cust_inv_rec.invoice_currency_code TO_CURRENCY ,
16095: '' FROM_CURRENCY , --Not usefull in this case as taxable is not calculated with from currency
16096: -- Rowid
16097: rowid
16098: FROM AR_LINE_APP_DETAIL_GT
16099: WHERE gt_id = p_gt_id
16100: AND ref_customer_trx_id = p_customer_trx_id
16101: AND tax_link_id IS NOT NULL
16102: AND DECODE(ref_account_class,'REV' ,tax_inc_flag,

Line 16370: UPDATE AR_LINE_APP_DETAIL_GT

16366: x_run_uned_tax_acctd_amt => l_run_uned_tax_acctd_amt,
16367: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc);
16368:
16369: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
16370: UPDATE AR_LINE_APP_DETAIL_GT
16371: SET taxable_amount = DECODE(activity_bucket, 'APP_TAX', l_tab.tl_tax_alloc_amt(i),
16372: 'ADJ_TAX', l_tab.tl_tax_alloc_amt(i),
16373: 'ED_TAX', l_tab.tl_ed_tax_alloc_amt(i),
16374: 'UNED_TAX', l_tab.tl_uned_tax_alloc_amt(i)),

Line 16407: SELECT /+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)/

16403: p_acctd_ed IN NUMBER,
16404: p_acctd_uned IN NUMBER,
16405: p_from_curr_code IN VARCHAR2)
16406: IS
16407: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
16408: DECODE(activity_bucket, 'ADJ_LINE', 'ADJ',
16409: 'ADJ_TAX' , 'ADJ',
16410: 'ADJ_FRT' , 'ADJ',
16411: 'ADJ_CHRG', 'ADJ',

Line 16583: FROM AR_LINE_APP_DETAIL_GT

16579: --HYU
16580: p_from_curr_code FROM_CURRENCY,
16581: -- Rowid
16582: rowid
16583: FROM AR_LINE_APP_DETAIL_GT
16584: WHERE gt_id = p_gt_id
16585: AND ref_customer_trx_id = p_customer_trx_id
16586: ORDER BY DECODE(activity_bucket, 'ADJ_LINE', 'ADJ',
16587: 'ADJ_TAX' , 'ADJ',

Line 16901: localdebug(' update AR_LINE_APP_DETAIL_GT RSOB:'||p_ae_sys_rec.set_of_books_id);

16897: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc
16898: );
16899:
16900: IF PG_DEBUG = 'Y' THEN
16901: localdebug(' update AR_LINE_APP_DETAIL_GT RSOB:'||p_ae_sys_rec.set_of_books_id);
16902: END IF;
16903: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
16904: UPDATE AR_LINE_APP_DETAIL_GT a
16905: SET ACCTD_AMOUNT = DECODE(a.activity_bucket, 'APP_LINE', l_tab.tl_alloc_acctd_amt(i),

Line 16904: UPDATE AR_LINE_APP_DETAIL_GT a

16900: IF PG_DEBUG = 'Y' THEN
16901: localdebug(' update AR_LINE_APP_DETAIL_GT RSOB:'||p_ae_sys_rec.set_of_books_id);
16902: END IF;
16903: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
16904: UPDATE AR_LINE_APP_DETAIL_GT a
16905: SET ACCTD_AMOUNT = DECODE(a.activity_bucket, 'APP_LINE', l_tab.tl_alloc_acctd_amt(i),
16906: 'APP_TAX' , l_tab.tl_alloc_acctd_amt(i),
16907: 'APP_FRT' , l_tab.tl_alloc_acctd_amt(i),
16908: 'APP_CHRG', l_tab.tl_alloc_acctd_amt(i),

Line 16940: localdebug(' update iAR_LINE_APP_DETAIL_GT ');

16936: 'UNED_CHRG', l_tab.tl_uned_tax_alloc_acctd_amt(i)),
16937: ledger_id = p_ae_sys_rec.set_of_books_id
16938: WHERE rowid = l_tab.ROWID_ID(i);
16939: IF PG_DEBUG = 'Y' THEN
16940: localdebug(' update iAR_LINE_APP_DETAIL_GT ');
16941: END IF;
16942:
16943: END LOOP;
16944: CLOSE c_mrc;

Line 16988: --UPDATE AR_LINE_APP_DETAIL_GT a SET

16984: g_num := 0;
16985: END IF;
16986: CLOSE c1;
16987:
16988: --UPDATE AR_LINE_APP_DETAIL_GT a SET
16989: --(a.DET_ID ) =
16990: --(SELECT next_val(g_num)
16991: -- FROM AR_LINE_APP_DETAIL_GT b
16992: -- WHERE a.rowid = b.rowid

Line 16991: -- FROM AR_LINE_APP_DETAIL_GT b

16987:
16988: --UPDATE AR_LINE_APP_DETAIL_GT a SET
16989: --(a.DET_ID ) =
16990: --(SELECT next_val(g_num)
16991: -- FROM AR_LINE_APP_DETAIL_GT b
16992: -- WHERE a.rowid = b.rowid
16993: -- AND a.gt_id = p_gt_id);
16994: --IF SQL%FOUND THEN
16995: -- x_exec_status := 'Y';

Line 17150: FROM AR_LINE_APP_DETAIL_GT lad,

17146: 'ADJ_FRT',lad.acctd_amount,
17147: -1* lad.acctd_amount)) * ABS(lad.from_acctd_amount) --FROM_ACCTD_AMOUNT
17148: , lad.ledger_id --LEDGER_ID
17149: , lad.base_currency --BASE_CURRENCY
17150: FROM AR_LINE_APP_DETAIL_GT lad,
17151: ar_payment_schedules_all sch
17152: WHERE lad.ref_customer_trx_id = sch.customer_trx_id
17153: AND lad.gt_id = p_gt_id;
17154: l_rows := sql%rowcount;

Line 17831: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;

17827: p_app_rec => p_app_rec);
17828: --}
17829:
17830: --delete from hy_line_application_detail;
17831: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
17832:
17833: IF g_mode_process = 'R12_MERGE' THEN
17834: UPDATE ar_receivable_applications_all
17835: SET upgrade_method = 'R12_MERGE'

Line 18736: FROM AR_LINE_APP_DETAIL_GT

18732: IS
18733: CURSOR cu1(p_gt_id IN NUMBER) IS
18734: SELECT SUM(NVL(amount,0)),
18735: SUM(NVL(acctd_amount,0))
18736: FROM AR_LINE_APP_DETAIL_GT
18737: WHERE gt_id = p_gt_id;
18738: l_sum NUMBER;
18739: l_acctd_sum NUMBER;
18740:

Line 18745: FROM AR_LINE_APP_DETAIL_GT

18741: CURSOR cu2(p_gt_id IN NUMBER) IS
18742: SELECT SUM(NVL(amount,0)),
18743: SUM(NVL(acctd_amount,0)),
18744: activity_bucket
18745: FROM AR_LINE_APP_DETAIL_GT
18746: WHERE gt_id = p_gt_id
18747: GROUP BY activity_bucket;
18748: l_activity VARCHAR2(30);
18749: l_act_amount NUMBER;

Line 19131: FROM AR_LINE_APP_DETAIL_GT

19127: CREATED_BY,
19128: CREATION_DATE,
19129: DET_ID,
19130: FROM_ACCTD_AMOUNT
19131: FROM AR_LINE_APP_DETAIL_GT
19132: WHERE GT_ID = l_gt_id;
19133:
19134: l c%ROWTYPE;
19135: l_text VARCHAR2(4000);

Line 19230: FROM AR_LINE_APP_DETAIL_GT

19226: TAX_INC_FLAG ,
19227: TAX_LINK_ID ,
19228: TO_CURRENCY ,
19229: REF_MF_DIST_FLAG
19230: FROM AR_LINE_APP_DETAIL_GT
19231: WHERE GT_ID = l_gt_id;
19232:
19233: INSERT INTO ra_ar_tmp
19234: (ACCOUNT_CLASS ,