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 RA_CUSTOMER_TRX_LINES_GT

Line 2874: SELECT /+INDEX (ctl ra_customer_trx_lines_gt_n1)/

2870: ,SUM_INT_UNED_LINE_AMOUNT
2871: ,SUM_INT_UNED_TAX_AMOUNT
2872: --}
2873: )
2874: SELECT /*+INDEX (ctl ra_customer_trx_lines_gt_n1)*/
2875: p_gt_id , --GT_ID
2876: p_ae_sys_rec.base_currency , --BASE_CURRENCY
2877: trx.invoice_currency_code , --TO_CURRENCY
2878: trx.customer_trx_id , --REF_CUSTOMER_TRX_ID

Line 3186: ra_customer_trx_lines_gt ctl,

3182: ,CASE WHEN g_uned_line_flag = 'INTERFACE' THEN it.sum_uned_line_amount ELSE NULL END -- SUM_INT_UNED_LINE_AMOUNT
3183: ,CASE WHEN g_uned_tax_flag = 'INTERFACE' THEN it.sum_uned_tax_amount ELSE NULL END -- SUM_INT_UNED_TAX_AMOUNT
3184: --}
3185: FROM ra_customer_trx trx,
3186: ra_customer_trx_lines_gt ctl,
3187: (SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3188: gt_id gt_id
3189: ,customer_trx_id customer_trx_id
3190: ,customer_trx_line_id customer_trx_line_id

Line 5036: localdebug(' Update rem amount in ra_customer_trx_lines_gt for regular transaction');

5032: localdebug(' p_source_data_key2 :'||p_source_data_key2);
5033: localdebug(' p_source_data_key3 :'||p_source_data_key3);
5034: localdebug(' p_source_data_key4 :'||p_source_data_key4);
5035: localdebug(' p_source_data_key5 :'||p_source_data_key5);
5036: localdebug(' Update rem amount in ra_customer_trx_lines_gt for regular transaction');
5037: END IF;
5038: IF p_customer_trx_line_id IS NOT NULL THEN
5039: IF p_log_inv_line = 'N' THEN
5040:

Line 5041: UPDATE /+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)/ ra_customer_trx_lines_gt a

5037: END IF;
5038: IF p_customer_trx_line_id IS NOT NULL THEN
5039: IF p_log_inv_line = 'N' THEN
5040:
5041: UPDATE /*+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)*/ ra_customer_trx_lines_gt a
5042: SET (a.AMOUNT_DUE_REMAINING ,
5043: a.ACCTD_AMOUNT_DUE_REMAINING ,
5044: a.AMOUNT_DUE_ORIGINAL ,
5045: a.ACCTD_AMOUNT_DUE_ORIGINAL ,

Line 5210: UPDATE /+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)/ ra_customer_trx_lines_gt a

5206: --}
5207: AND a.line_type IN ('LINE','FREIGHT','TAX','CB','CHARGES');
5208:
5209: ELSE
5210: UPDATE /*+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)*/ ra_customer_trx_lines_gt a
5211: SET (a.AMOUNT_DUE_REMAINING ,
5212: a.ACCTD_AMOUNT_DUE_REMAINING ,
5213: a.AMOUNT_DUE_ORIGINAL ,
5214: a.ACCTD_AMOUNT_DUE_ORIGINAL ,

Line 5378: UPDATE /+ index(A RA_CUSTOMER_TRX_LINES_GT_N2)/ ra_customer_trx_lines_gt a

5374: = DECODE(p_source_data_key5, NULL, '-99', a.source_data_key5)
5375: --}
5376: AND a.line_type IN ('LINE','CB');
5377:
5378: UPDATE /*+ index(A RA_CUSTOMER_TRX_LINES_GT_N2)*/ ra_customer_trx_lines_gt a
5379: SET (a.AMOUNT_DUE_REMAINING ,
5380: a.ACCTD_AMOUNT_DUE_REMAINING ,
5381: a.AMOUNT_DUE_ORIGINAL ,
5382: a.ACCTD_AMOUNT_DUE_ORIGINAL ,

Line 5547: UPDATE /+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)/ ra_customer_trx_lines_gt a

5543: --}
5544: AND a.line_type IN ('FREIGHT','TAX','CHARGES');
5545: END IF; -- End of p_log_inv_line check
5546: ELSE
5547: UPDATE /*+ index(A RA_CUSTOMER_TRX_LINES_GT_N1)*/ ra_customer_trx_lines_gt a
5548: SET (a.AMOUNT_DUE_REMAINING ,
5549: a.ACCTD_AMOUNT_DUE_REMAINING ,
5550: a.AMOUNT_DUE_ORIGINAL ,
5551: a.ACCTD_AMOUNT_DUE_ORIGINAL ,

Line 10454: SELECT /+INDEX (ctl ra_customer_trx_lines_gt_n1)/

10450: set_of_books_id,
10451: sob_type
10452: -- se_gt_id
10453: )
10454: SELECT /*+INDEX (ctl ra_customer_trx_lines_gt_n1)*/
10455: p_gt_id , --GT_ID
10456: p_ae_sys_rec.base_currency , --BASE_CURRENCY
10457: trx.invoice_currency_code , --TO_CURRENCY
10458: trx.customer_trx_id , --REF_CUSTOMER_TRX_ID

Line 10692: ra_customer_trx_lines_gt ctl

10688: p_ae_sys_rec.set_of_books_id,
10689: p_ae_sys_rec.sob_type
10690: -- g_se_gt_id
10691: FROM ra_customer_trx trx,
10692: ra_customer_trx_lines_gt ctl
10693: WHERE trx.customer_trx_id = p_customer_trx_id
10694: AND trx.customer_trx_id = ctl.customer_trx_id
10695: -- AND NVL(ctl.group_id,'00') = p_group_id
10696: --{HYUBPAGP

Line 10793: SELECT /+INDEX (ctl ra_customer_trx_lines_gt_n1)/

10789: --
10790: set_of_books_id,
10791: sob_type)
10792: -- se_gt_id)
10793: SELECT /*+INDEX (ctl ra_customer_trx_lines_gt_n1)*/
10794: p_gt_id , --GT_ID
10795: p_ae_sys_rec.base_currency , --BASE_CURRENCY
10796: trx.invoice_currency_code , --TO_CURRENCY
10797: trx.customer_trx_id , --REF_CUSTOMER_TRX_ID

Line 10938: from ra_customer_trx_lines_gt ctl2

10934: p_ae_sys_rec.sob_type
10935: -- g_se_gt_id
10936: FROM ra_customer_trx trx,
10937: ( select *
10938: from ra_customer_trx_lines_gt ctl2
10939: where ctl2.customer_trx_id = p_customer_trx_id
10940: and ctl2.customer_trx_line_id = p_customer_trx_line_id
10941: union all
10942: select *

Line 10943: from ra_customer_trx_lines_gt ctl2

10939: where ctl2.customer_trx_id = p_customer_trx_id
10940: and ctl2.customer_trx_line_id = p_customer_trx_line_id
10941: union all
10942: select *
10943: from ra_customer_trx_lines_gt ctl2
10944: where ctl2.customer_trx_id = p_customer_trx_id
10945: and ctl2.LINK_TO_CUST_TRX_LINE_ID = p_customer_trx_line_id
10946: ) ctl
10947: WHERE trx.customer_trx_id = p_customer_trx_id;

Line 11633: FROM ra_customer_trx_lines_gt

11629: IS
11630: CURSOR cu_line_loaded (p_customer_trx_id IN NUMBER,
11631: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE ) IS
11632: SELECT 'x'
11633: FROM ra_customer_trx_lines_gt
11634: WHERE customer_trx_id = p_customer_trx_id
11635: AND customer_trx_line_id = NVL(p_customer_trx_line_id, customer_trx_line_id);
11636: l_exist VARCHAR2(1);
11637:

Line 11640: FROM ra_customer_trx_lines_gt

11636: l_exist VARCHAR2(1);
11637:
11638: CURSOR c_frt_chrg IS
11639: SELECT MAX(line_type)
11640: FROM ra_customer_trx_lines_gt
11641: WHERE line_type IN ('CHARGES','FREIGHT')
11642: AND customer_trx_id = p_customer_trx_id
11643: GROUP BY line_type;
11644:

Line 11671: INSERT INTO ra_customer_trx_lines_gt

11667: localdebug(' g_mode_process = :'||g_mode_process);
11668: localdebug(' g_adj_yn = :'||g_adj_yn );
11669: END IF;
11670:
11671: INSERT INTO ra_customer_trx_lines_gt
11672: (customer_trx_line_id,
11673: link_to_cust_trx_line_id,
11674: customer_trx_id ,
11675: set_of_books_id ,

Line 11796: INSERT INTO ra_customer_trx_lines_gt

11792: l_rows := sql%rowcount;
11793: localdebug(' rows inserted = ' || l_rows);
11794: ELSE
11795:
11796: INSERT INTO ra_customer_trx_lines_gt
11797: (CUSTOMER_TRX_LINE_ID,
11798: LINK_TO_CUST_TRX_LINE_ID,
11799: CUSTOMER_TRX_ID ,
11800: SET_OF_BOOKS_ID ,

Line 11929: SELECT /+INDEX (ctl ra_customer_trx_lines_gt_n1)/

11925: PROCEDURE final_update_inv_ctl_rem_orig
11926: (p_customer_trx IN ra_customer_trx%ROWTYPE)
11927: IS
11928: CURSOR c(p_customer_trx_id IN NUMBER) IS
11929: SELECT /*+INDEX (ctl ra_customer_trx_lines_gt_n1)*/
11930: b.AMOUNT_DUE_REMAINING ,
11931: b.ACCTD_AMOUNT_DUE_REMAINING,
11932: b.AMOUNT_DUE_ORIGINAL ,
11933: b.ACCTD_AMOUNT_DUE_ORIGINAL ,

Line 11943: FROM ra_customer_trx_lines_gt b

11939: b.frt_ed_acctd_amount,
11940: b.frt_uned_amount,
11941: b.frt_uned_acctd_amount,
11942: b.customer_trx_line_id
11943: FROM ra_customer_trx_lines_gt b
11944: WHERE b.customer_trx_id = p_customer_trx_id;
11945:
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 12728: (p_record IN ra_customer_trx_lines_gt%ROWTYPE)

12724: END;
12725:
12726:
12727: PROCEDURE display_cust_trx_row
12728: (p_record IN ra_customer_trx_lines_gt%ROWTYPE)
12729: IS
12730: BEGIN
12731: IF PG_DEBUG = 'Y' THEN
12732: localdebug('arp_det_dist_pkg.display_cust_trx_row()+');

Line 12763: FROM ra_customer_trx_lines_gt

12759: PROCEDURE display_cust_trx_gt(p_customer_trx_id IN NUMBER)
12760: IS
12761: CURSOR c IS
12762: SELECT *
12763: FROM ra_customer_trx_lines_gt
12764: WHERE customer_trx_id = p_customer_trx_id;
12765: l_record c%ROWTYPE;
12766: BEGIN
12767: IF PG_DEBUG = 'Y' THEN

Line 16154: | Read the remaining amount on ra_customer_trx_lines_gt |

16150: | x_freight_rem The remaining freight amount for the level TRANSACTION only|
16151: | x_charges_rem The remaining charges amount for the level TRANSACTION only|
16152: +-----------------------------------------------------------------------------+
16153: | Action : |
16154: | Read the remaining amount on ra_customer_trx_lines_gt |
16155: +-----------------------------------------------------------------------------*/
16156: PROCEDURE get_latest_amount_remaining
16157: (p_customer_trx_id IN NUMBER,
16158: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',

Line 16174: SELECT /+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)/

16170: x_msg_data OUT NOCOPY VARCHAR2,
16171: x_msg_count OUT NOCOPY NUMBER)
16172: IS
16173: CURSOR c_trx IS
16174: SELECT /*+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)*/
16175: SUM(DECODE(line_type,'LINE',NVL(AMOUNT_DUE_REMAINING,0))) line_rem,
16176: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
16177: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16178: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,

Line 16181: FROM ra_customer_trx_lines_gt

16177: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16178: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,
16179: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
16180: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
16181: FROM ra_customer_trx_lines_gt
16182: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
16183:
16184: CURSOR c_line IS
16185: SELECT /*+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)*/

Line 16185: SELECT /+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)/

16181: FROM ra_customer_trx_lines_gt
16182: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
16183:
16184: CURSOR c_line IS
16185: SELECT /*+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)*/
16186: SUM(DECODE(line_type,'LINE',NVL(AMOUNT_DUE_REMAINING,0))) line_rem,
16187: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
16188: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16189: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,

Line 16192: FROM ra_customer_trx_lines_gt

16188: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16189: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,
16190: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
16191: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
16192: FROM ra_customer_trx_lines_gt
16193: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
16194: AND DECODE(line_type,'LINE',customer_trx_line_id, LINK_TO_CUST_TRX_LINE_ID) = p_ctl_id;
16195:
16196: CURSOR c_gp IS

Line 16197: SELECT /+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)/

16193: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
16194: AND DECODE(line_type,'LINE',customer_trx_line_id, LINK_TO_CUST_TRX_LINE_ID) = p_ctl_id;
16195:
16196: CURSOR c_gp IS
16197: SELECT /*+INDEX (ra_customer_trx_lines_gt ra_customer_trx_lines_gt_n1)*/
16198: SUM(DECODE(line_type,'LINE',NVL(AMOUNT_DUE_REMAINING,0))) line_rem,
16199: SUM(DECODE(line_type,'TAX' ,NVL(AMOUNT_DUE_REMAINING,0))) tax_rem,
16200: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16201: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,

Line 16204: FROM ra_customer_trx_lines_gt

16200: SUM(DECODE(line_type,'LINE',NVL(CHRG_AMOUNT_REMAINING,0))) +
16201: SUM(DECODE(line_type,'CHARGES',NVL(AMOUNT_DUE_REMAINING,0))) chrg_rem,
16202: SUM(DECODE(line_type,'LINE',NVL(FRT_ADJ_REMAINING,0))) +
16203: SUM(DECODE(line_type,'FREIGHT',NVL(AMOUNT_DUE_REMAINING,0))) frt_rem
16204: FROM ra_customer_trx_lines_gt
16205: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
16206: AND source_data_key1 = p_source_data_key1
16207: AND source_data_key2 = p_source_data_key2
16208: AND source_data_key3 = p_source_data_key3