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 7679: INSERT INTO AR_LINE_APP_DETAIL_GT

7675: END IF;
7676:
7677: --Monoparsing
7678: IF g_upgrade_mode = 'Y' THEN
7679: INSERT INTO AR_LINE_APP_DETAIL_GT
7680: ( DET_ID
7681: ,APP_LEVEL
7682: ,GROUP_ID
7683: ,source_data_key1

Line 7858: INSERT INTO AR_LINE_APP_DETAIL_GT

7854:
7855: -- l_rows := sql%rowcount;
7856: -- localdebug(' rows inserted = ' || l_rows);
7857: ELSE
7858: INSERT INTO AR_LINE_APP_DETAIL_GT
7859: ( DET_ID ,
7860: APP_LEVEL ,
7861: GROUP_ID ,
7862: source_data_key1 ,

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

13602: p_gt_id IN VARCHAR2 DEFAULT NULL,
13603: p_inv_currency IN VARCHAr2 DEFAULT NULL)
13604: IS
13605: CURSOR cu1(p_gt_id IN NUMBER) IS
13606: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
13607: SUM(NVL(amount,0)),
13608: SUM(NVL(acctd_amount,0))
13609: FROM AR_LINE_APP_DETAIL_GT
13610: WHERE gt_id = p_gt_id

Line 13609: FROM AR_LINE_APP_DETAIL_GT

13605: CURSOR cu1(p_gt_id IN NUMBER) IS
13606: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
13607: SUM(NVL(amount,0)),
13608: SUM(NVL(acctd_amount,0))
13609: FROM AR_LINE_APP_DETAIL_GT
13610: WHERE gt_id = p_gt_id
13611: AND activity_bucket IN ('APP_LINE','APP_CHRG','APP_TAX','APP_FRT',
13612: 'ADJ_LINE','ADJ_TAX','ADJ_CHRG','ADJ_FRT')
13613: AND ( NVL(amount,0) <> 0

Line 13646: from ar_line_app_detail_gt

13642: /*Bug7391957, Added following SELECT statement within a BEGIN..END block */
13643: BEGIN
13644: select distinct source_id
13645: into l_source_id
13646: from ar_line_app_detail_gt
13647: where gt_id = l_gt_id
13648: AND source_table ='RA';
13649:
13650: select count(*)

Line 13746: UPDATE AR_LINE_APP_DETAIL_GT a

13742: localdebug(' l_pro_acctd_base : '|| l_pro_acctd_base);
13743: END IF;
13744:
13745:
13746: UPDATE AR_LINE_APP_DETAIL_GT a
13747: SET(FROM_AMOUNT ,
13748: FROM_ACCTD_AMOUNT ) =
13749: (SELECT DECODE(l_pro_base,0,0,
13750: Accting_Proration_Fct

Line 13778: FROM AR_LINE_APP_DETAIL_GT b

13774: p_ae_sys_rec.base_currency,
13775: l_inv_currency,
13776: l_from_curr_code,
13777: 'FROM_ACCTD_AMT'))
13778: FROM AR_LINE_APP_DETAIL_GT b
13779: WHERE a.rowid = b.rowid
13780: AND b.gt_id = l_gt_id
13781: AND b.activity_bucket IN
13782: ('APP_LINE','APP_CHRG','APP_TAX','APP_FRT',

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

14241: TO_CURRENCY ,
14242: FROM_CURRENCY ,
14243: --
14244: rowid
14245: from (SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
14246: tax_link_id groupe,
14247: -- ADJ and APP
14248: --Base
14249: 0 base_pro_amt, --Base for Revenue distributions

Line 14386: FROM AR_LINE_APP_DETAIL_GT

14382: g_cust_inv_rec.invoice_currency_code TO_CURRENCY ,
14383: '' FROM_CURRENCY , --Not usefull in this case as taxable is not calculated with from currency
14384: -- Rowid
14385: rowid
14386: FROM AR_LINE_APP_DETAIL_GT
14387: WHERE gt_id = p_gt_id
14388: AND ref_customer_trx_id = p_customer_trx_id
14389: AND tax_link_id IS NOT NULL
14390: AND DECODE(ref_account_class,'REV' ,tax_inc_flag,

Line 14658: UPDATE AR_LINE_APP_DETAIL_GT

14654: x_run_uned_tax_acctd_amt => l_run_uned_tax_acctd_amt,
14655: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc);
14656:
14657: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
14658: UPDATE AR_LINE_APP_DETAIL_GT
14659: SET taxable_amount = DECODE(activity_bucket, 'APP_TAX', l_tab.tl_tax_alloc_amt(i),
14660: 'ADJ_TAX', l_tab.tl_tax_alloc_amt(i),
14661: 'ED_TAX', l_tab.tl_ed_tax_alloc_amt(i),
14662: 'UNED_TAX', l_tab.tl_uned_tax_alloc_amt(i)),

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

14691: p_acctd_ed IN NUMBER,
14692: p_acctd_uned IN NUMBER,
14693: p_from_curr_code IN VARCHAR2)
14694: IS
14695: SELECT /*+INDEX (AR_LINE_APP_DETAIL_GT AR_LINE_APP_DETAIL_GT_N1)*/
14696: DECODE(activity_bucket, 'ADJ_LINE', 'ADJ',
14697: 'ADJ_TAX' , 'ADJ',
14698: 'ADJ_FRT' , 'ADJ',
14699: 'ADJ_CHRG', 'ADJ',

Line 14871: FROM AR_LINE_APP_DETAIL_GT

14867: --HYU
14868: p_from_curr_code FROM_CURRENCY,
14869: -- Rowid
14870: rowid
14871: FROM AR_LINE_APP_DETAIL_GT
14872: WHERE gt_id = p_gt_id
14873: AND ref_customer_trx_id = p_customer_trx_id
14874: ORDER BY DECODE(activity_bucket, 'ADJ_LINE', 'ADJ',
14875: 'ADJ_TAX' , 'ADJ',

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

15185: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc
15186: );
15187:
15188: IF PG_DEBUG = 'Y' THEN
15189: localdebug(' update AR_LINE_APP_DETAIL_GT RSOB:'||p_ae_sys_rec.set_of_books_id);
15190: END IF;
15191: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
15192: UPDATE AR_LINE_APP_DETAIL_GT a
15193: SET ACCTD_AMOUNT = DECODE(a.activity_bucket, 'APP_LINE', l_tab.tl_alloc_acctd_amt(i),

Line 15192: UPDATE AR_LINE_APP_DETAIL_GT a

15188: IF PG_DEBUG = 'Y' THEN
15189: localdebug(' update AR_LINE_APP_DETAIL_GT RSOB:'||p_ae_sys_rec.set_of_books_id);
15190: END IF;
15191: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
15192: UPDATE AR_LINE_APP_DETAIL_GT a
15193: SET ACCTD_AMOUNT = DECODE(a.activity_bucket, 'APP_LINE', l_tab.tl_alloc_acctd_amt(i),
15194: 'APP_TAX' , l_tab.tl_alloc_acctd_amt(i),
15195: 'APP_FRT' , l_tab.tl_alloc_acctd_amt(i),
15196: 'APP_CHRG', l_tab.tl_alloc_acctd_amt(i),

Line 15228: localdebug(' update iAR_LINE_APP_DETAIL_GT ');

15224: 'UNED_CHRG', l_tab.tl_uned_tax_alloc_acctd_amt(i)),
15225: ledger_id = p_ae_sys_rec.set_of_books_id
15226: WHERE rowid = l_tab.ROWID_ID(i);
15227: IF PG_DEBUG = 'Y' THEN
15228: localdebug(' update iAR_LINE_APP_DETAIL_GT ');
15229: END IF;
15230:
15231: END LOOP;
15232: CLOSE c_mrc;

Line 15276: --UPDATE AR_LINE_APP_DETAIL_GT a SET

15272: g_num := 0;
15273: END IF;
15274: CLOSE c1;
15275:
15276: --UPDATE AR_LINE_APP_DETAIL_GT a SET
15277: --(a.DET_ID ) =
15278: --(SELECT next_val(g_num)
15279: -- FROM AR_LINE_APP_DETAIL_GT b
15280: -- WHERE a.rowid = b.rowid

Line 15279: -- FROM AR_LINE_APP_DETAIL_GT b

15275:
15276: --UPDATE AR_LINE_APP_DETAIL_GT a SET
15277: --(a.DET_ID ) =
15278: --(SELECT next_val(g_num)
15279: -- FROM AR_LINE_APP_DETAIL_GT b
15280: -- WHERE a.rowid = b.rowid
15281: -- AND a.gt_id = p_gt_id);
15282: --IF SQL%FOUND THEN
15283: -- x_exec_status := 'Y';

Line 15438: FROM AR_LINE_APP_DETAIL_GT lad,

15434: 'ADJ_FRT',lad.acctd_amount,
15435: -1* lad.acctd_amount)) * ABS(lad.from_acctd_amount) --FROM_ACCTD_AMOUNT
15436: , lad.ledger_id --LEDGER_ID
15437: , lad.base_currency --BASE_CURRENCY
15438: FROM AR_LINE_APP_DETAIL_GT lad,
15439: ar_payment_schedules_all sch
15440: WHERE lad.ref_customer_trx_id = sch.customer_trx_id
15441: AND lad.gt_id = p_gt_id;
15442: l_rows := sql%rowcount;

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

16115: p_app_rec => p_app_rec);
16116: --}
16117:
16118: --delete from hy_line_application_detail;
16119: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
16120:
16121:
16122: UPDATE ar_receivable_applications_all
16123: SET upgrade_method = 'R12_11ICASH'

Line 16986: FROM AR_LINE_APP_DETAIL_GT

16982: IS
16983: CURSOR cu1(p_gt_id IN NUMBER) IS
16984: SELECT SUM(NVL(amount,0)),
16985: SUM(NVL(acctd_amount,0))
16986: FROM AR_LINE_APP_DETAIL_GT
16987: WHERE gt_id = p_gt_id;
16988: l_sum NUMBER;
16989: l_acctd_sum NUMBER;
16990:

Line 16995: FROM AR_LINE_APP_DETAIL_GT

16991: CURSOR cu2(p_gt_id IN NUMBER) IS
16992: SELECT SUM(NVL(amount,0)),
16993: SUM(NVL(acctd_amount,0)),
16994: activity_bucket
16995: FROM AR_LINE_APP_DETAIL_GT
16996: WHERE gt_id = p_gt_id
16997: GROUP BY activity_bucket;
16998: l_activity VARCHAR2(30);
16999: l_act_amount NUMBER;

Line 17205: FROM AR_LINE_APP_DETAIL_GT

17201: CREATED_BY,
17202: CREATION_DATE,
17203: DET_ID,
17204: FROM_ACCTD_AMOUNT
17205: FROM AR_LINE_APP_DETAIL_GT
17206: WHERE GT_ID = l_gt_id;
17207:
17208: l c%ROWTYPE;
17209: l_text VARCHAR2(4000);

Line 17304: FROM AR_LINE_APP_DETAIL_GT

17300: TAX_INC_FLAG ,
17301: TAX_LINK_ID ,
17302: TO_CURRENCY ,
17303: REF_MF_DIST_FLAG
17304: FROM AR_LINE_APP_DETAIL_GT
17305: WHERE GT_ID = l_gt_id;
17306:
17307: INSERT INTO ra_ar_tmp
17308: (ACCOUNT_CLASS ,