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.JL_ZZ_TAX dependencies on RA_CUSTOMER_TRX_LINES

Line 2244: ,ra_customer_trx_lines rl1

2240: ,nvl(rlt1.global_attribute20,0) calculated_tax
2241: ,rl1.customer_trx_line_id inv_line_number
2242: ,r1.customer_trx_id header_trx_id
2243: FROM ra_customer_trx r1
2244: ,ra_customer_trx_lines rl1
2245: ,ra_customer_trx_lines rlt1
2246: ,ar_vat_tax v1
2247: ,jl_zz_ar_tx_att_cls tcl1
2248: ,jl_zz_ar_tx_categ tc1

Line 2245: ,ra_customer_trx_lines rlt1

2241: ,rl1.customer_trx_line_id inv_line_number
2242: ,r1.customer_trx_id header_trx_id
2243: FROM ra_customer_trx r1
2244: ,ra_customer_trx_lines rl1
2245: ,ra_customer_trx_lines rlt1
2246: ,ar_vat_tax v1
2247: ,jl_zz_ar_tx_att_cls tcl1
2248: ,jl_zz_ar_tx_categ tc1
2249: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2277: ,ra_customer_trx_lines rl1

2273: ,nvl(rlt1.global_attribute20,0) calculated_tax
2274: ,rl1.customer_trx_line_id inv_line_number
2275: ,r1.customer_trx_id header_trx_id
2276: FROM ra_customer_trx r1
2277: ,ra_customer_trx_lines rl1
2278: ,ra_customer_trx_lines rlt1
2279: ,ar_vat_tax v1
2280: ,jl_zz_ar_tx_att_cls tcl1
2281: ,jl_zz_ar_tx_categ tc1

Line 2278: ,ra_customer_trx_lines rlt1

2274: ,rl1.customer_trx_line_id inv_line_number
2275: ,r1.customer_trx_id header_trx_id
2276: FROM ra_customer_trx r1
2277: ,ra_customer_trx_lines rl1
2278: ,ra_customer_trx_lines rlt1
2279: ,ar_vat_tax v1
2280: ,jl_zz_ar_tx_att_cls tcl1
2281: ,jl_zz_ar_tx_categ tc1
2282: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2310: ,ra_customer_trx_lines rl1

2306: ,nvl(rlt1.global_attribute20,0) calculated_tax
2307: ,rl1.customer_trx_line_id inv_line_number
2308: ,r1.customer_trx_id header_trx_id
2309: FROM ra_customer_trx r1
2310: ,ra_customer_trx_lines rl1
2311: ,ra_customer_trx_lines rlt1
2312: ,ar_vat_tax v1
2313: ,jl_zz_ar_tx_att_cls tcl1
2314: ,jl_zz_ar_tx_categ tc1

Line 2311: ,ra_customer_trx_lines rlt1

2307: ,rl1.customer_trx_line_id inv_line_number
2308: ,r1.customer_trx_id header_trx_id
2309: FROM ra_customer_trx r1
2310: ,ra_customer_trx_lines rl1
2311: ,ra_customer_trx_lines rlt1
2312: ,ar_vat_tax v1
2313: ,jl_zz_ar_tx_att_cls tcl1
2314: ,jl_zz_ar_tx_categ tc1
2315: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2344: ,ra_customer_trx_lines rl1

2340: ,rl1.customer_trx_line_id inv_line_number
2341: ,r1.customer_trx_id header_trx_id
2342: FROM ra_customer_trx r1
2343: ,ra_customer_trx r2
2344: ,ra_customer_trx_lines rl1
2345: ,ra_customer_trx_lines rlt1
2346: ,ar_vat_tax v1
2347: ,jl_zz_ar_tx_att_cls tcl1
2348: ,jl_zz_ar_tx_categ tc1

Line 2345: ,ra_customer_trx_lines rlt1

2341: ,r1.customer_trx_id header_trx_id
2342: FROM ra_customer_trx r1
2343: ,ra_customer_trx r2
2344: ,ra_customer_trx_lines rl1
2345: ,ra_customer_trx_lines rlt1
2346: ,ar_vat_tax v1
2347: ,jl_zz_ar_tx_att_cls tcl1
2348: ,jl_zz_ar_tx_categ tc1
2349: WHERE r2.related_customer_trx_id = p_prev_cust_trx_id

Line 2383: ,ra_customer_trx_lines rl1

2379: calculated_tax
2380: ,rl1.customer_trx_line_id inv_line_number
2381: ,r1.customer_trx_id header_trx_id
2382: FROM ra_customer_trx r1
2383: ,ra_customer_trx_lines rl1
2384: ,ra_customer_trx_lines rlt1
2385: ,ar_vat_tax v1
2386: ,jl_zz_ar_tx_att_cls tcl1
2387: ,jl_zz_ar_tx_categ tc1

Line 2384: ,ra_customer_trx_lines rlt1

2380: ,rl1.customer_trx_line_id inv_line_number
2381: ,r1.customer_trx_id header_trx_id
2382: FROM ra_customer_trx r1
2383: ,ra_customer_trx_lines rl1
2384: ,ra_customer_trx_lines rlt1
2385: ,ar_vat_tax v1
2386: ,jl_zz_ar_tx_att_cls tcl1
2387: ,jl_zz_ar_tx_categ tc1
2388: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2416: ,ra_customer_trx_lines rl1

2412: calculated_tax
2413: ,rl1.customer_trx_line_id inv_line_number
2414: ,r1.customer_trx_id header_trx_id
2415: FROM ra_customer_trx r1
2416: ,ra_customer_trx_lines rl1
2417: ,ra_customer_trx_lines rlt1
2418: ,ar_vat_tax v1
2419: ,jl_zz_ar_tx_att_cls tcl1
2420: ,jl_zz_ar_tx_categ tc1

Line 2417: ,ra_customer_trx_lines rlt1

2413: ,rl1.customer_trx_line_id inv_line_number
2414: ,r1.customer_trx_id header_trx_id
2415: FROM ra_customer_trx r1
2416: ,ra_customer_trx_lines rl1
2417: ,ra_customer_trx_lines rlt1
2418: ,ar_vat_tax v1
2419: ,jl_zz_ar_tx_att_cls tcl1
2420: ,jl_zz_ar_tx_categ tc1
2421: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2449: ,ra_customer_trx_lines rl1

2445: calculated_tax
2446: ,rl1.customer_trx_line_id inv_line_number
2447: ,r1.customer_trx_id header_trx_id
2448: FROM ra_customer_trx r1
2449: ,ra_customer_trx_lines rl1
2450: ,ra_customer_trx_lines rlt1
2451: ,ar_vat_tax v1
2452: ,jl_zz_ar_tx_att_cls tcl1
2453: ,jl_zz_ar_tx_categ tc1

Line 2450: ,ra_customer_trx_lines rlt1

2446: ,rl1.customer_trx_line_id inv_line_number
2447: ,r1.customer_trx_id header_trx_id
2448: FROM ra_customer_trx r1
2449: ,ra_customer_trx_lines rl1
2450: ,ra_customer_trx_lines rlt1
2451: ,ar_vat_tax v1
2452: ,jl_zz_ar_tx_att_cls tcl1
2453: ,jl_zz_ar_tx_categ tc1
2454: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2483: ,ra_customer_trx_lines rl1

2479: ,rl1.customer_trx_line_id inv_line_number
2480: ,r1.customer_trx_id header_trx_id
2481: FROM ra_customer_trx r1
2482: ,ra_customer_trx r2
2483: ,ra_customer_trx_lines rl1
2484: ,ra_customer_trx_lines rlt1
2485: ,ar_vat_tax v1
2486: ,jl_zz_ar_tx_att_cls tcl1
2487: ,jl_zz_ar_tx_categ tc1

Line 2484: ,ra_customer_trx_lines rlt1

2480: ,r1.customer_trx_id header_trx_id
2481: FROM ra_customer_trx r1
2482: ,ra_customer_trx r2
2483: ,ra_customer_trx_lines rl1
2484: ,ra_customer_trx_lines rlt1
2485: ,ar_vat_tax v1
2486: ,jl_zz_ar_tx_att_cls tcl1
2487: ,jl_zz_ar_tx_categ tc1
2488: WHERE r2.related_customer_trx_id = p_rel_cust_trx_id

Line 2517: ,ra_customer_trx_lines rl1

2513: ,nvl(rlt1.global_attribute20,0) calculated_tax
2514: ,rl1.customer_trx_line_id inv_line_number
2515: ,r1.customer_trx_id header_trx_id
2516: FROM ra_customer_trx r1
2517: ,ra_customer_trx_lines rl1
2518: ,ra_customer_trx_lines rlt1
2519: ,ar_vat_tax v1
2520: ,jl_zz_ar_tx_att_cls tcl1
2521: ,jl_zz_ar_tx_categ tc1

Line 2518: ,ra_customer_trx_lines rlt1

2514: ,rl1.customer_trx_line_id inv_line_number
2515: ,r1.customer_trx_id header_trx_id
2516: FROM ra_customer_trx r1
2517: ,ra_customer_trx_lines rl1
2518: ,ra_customer_trx_lines rlt1
2519: ,ar_vat_tax v1
2520: ,jl_zz_ar_tx_att_cls tcl1
2521: ,jl_zz_ar_tx_categ tc1
2522: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2543: FROM ra_customer_trx_lines rlt1

2539: ORDER BY 7, 6, 1;
2540:
2541: cursor rel_trx_categ is
2542: SELECT tc1.tax_category_id tax_category_id
2543: FROM ra_customer_trx_lines rlt1
2544: ,ar_vat_tax v1
2545: ,jl_zz_ar_tx_categ tc1
2546: WHERE rlt1.customer_trx_id = p_rel_cust_trx_id
2547: AND rlt1.line_type= 'TAX'

Line 2555: FROM ra_customer_trx_lines rlt1

2551: AND tc1.threshold_check_grp_by = 'DOCUMENT';
2552:
2553: cursor cur_trx_categ is
2554: SELECT tc1.tax_category_id tax_category_id
2555: FROM ra_customer_trx_lines rlt1
2556: ,ar_vat_tax v1
2557: ,jl_zz_ar_tx_categ tc1
2558: WHERE rlt1.customer_trx_id = p_curr_cust_trx_id
2559: AND rlt1.line_type= 'TAX'