APPS.JL_ZZ_TAX dependencies on RA_CUSTOMER_TRX

Line 2243: FROM ra_customer_trx r1

2239: ,nvl(rlt1.global_attribute19,0) charged_tax
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

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 2276: FROM ra_customer_trx r1

2272: ,nvl(rlt1.global_attribute19,0) charged_tax
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

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 2309: FROM ra_customer_trx r1

2305: ,nvl(rlt1.global_attribute19,0) charged_tax
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

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 2342: FROM ra_customer_trx r1

2338: ,nvl(rlt1.global_attribute19,0) charged_tax
2339: ,nvl(rlt1.global_attribute20,0) calculated_tax
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

Line 2343: ,ra_customer_trx r2

2339: ,nvl(rlt1.global_attribute20,0) calculated_tax
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

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 2382: FROM ra_customer_trx r1

2378: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
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

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 2415: FROM ra_customer_trx r1

2411: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
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

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 2448: FROM ra_customer_trx r1

2444: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
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

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 2481: FROM ra_customer_trx r1

2477: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2478: calculated_tax
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

Line 2482: ,ra_customer_trx r2

2478: calculated_tax
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

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 2516: FROM ra_customer_trx r1

2512: ,nvl(rlt1.global_attribute19,0) charged_tax
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

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'

Line 4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

4005: l_org_id NUMBER;
4006: l_country_code varchar2(2);
4007:
4008: -- bug#6834705
4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c

Line 4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

4006: l_country_code varchar2(2);
4007:
4008: -- bug#6834705
4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

Line 4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL

Line 4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)

4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL
4019: WHERE org_id = c_org_id

Line 4018: FROM RA_CUSTOMER_TRX_ALL

4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL
4019: WHERE org_id = c_org_id
4020: AND customer_trx_id = c_customer_trx_id ;
4021:
4022: BEGIN