APPS.JL_ZZ_TAX dependencies on RA_CUSTOMER_TRX

Line 2223: FROM ra_customer_trx r1

2219: ,nvl(rlt1.global_attribute19,0) charged_tax
2220: ,nvl(rlt1.global_attribute20,0) calculated_tax
2221: ,rl1.customer_trx_line_id inv_line_number
2222: ,r1.customer_trx_id header_trx_id
2223: FROM ra_customer_trx r1
2224: ,ra_customer_trx_lines rl1
2225: ,ra_customer_trx_lines rlt1
2226: ,ar_vat_tax v1
2227: ,jl_zz_ar_tx_att_cls tcl1

Line 2224: ,ra_customer_trx_lines rl1

2220: ,nvl(rlt1.global_attribute20,0) calculated_tax
2221: ,rl1.customer_trx_line_id inv_line_number
2222: ,r1.customer_trx_id header_trx_id
2223: FROM ra_customer_trx r1
2224: ,ra_customer_trx_lines rl1
2225: ,ra_customer_trx_lines rlt1
2226: ,ar_vat_tax v1
2227: ,jl_zz_ar_tx_att_cls tcl1
2228: ,jl_zz_ar_tx_categ tc1

Line 2225: ,ra_customer_trx_lines rlt1

2221: ,rl1.customer_trx_line_id inv_line_number
2222: ,r1.customer_trx_id header_trx_id
2223: FROM ra_customer_trx r1
2224: ,ra_customer_trx_lines rl1
2225: ,ra_customer_trx_lines rlt1
2226: ,ar_vat_tax v1
2227: ,jl_zz_ar_tx_att_cls tcl1
2228: ,jl_zz_ar_tx_categ tc1
2229: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2256: FROM ra_customer_trx r1

2252: ,nvl(rlt1.global_attribute19,0) charged_tax
2253: ,nvl(rlt1.global_attribute20,0) calculated_tax
2254: ,rl1.customer_trx_line_id inv_line_number
2255: ,r1.customer_trx_id header_trx_id
2256: FROM ra_customer_trx r1
2257: ,ra_customer_trx_lines rl1
2258: ,ra_customer_trx_lines rlt1
2259: ,ar_vat_tax v1
2260: ,jl_zz_ar_tx_att_cls tcl1

Line 2257: ,ra_customer_trx_lines rl1

2253: ,nvl(rlt1.global_attribute20,0) calculated_tax
2254: ,rl1.customer_trx_line_id inv_line_number
2255: ,r1.customer_trx_id header_trx_id
2256: FROM ra_customer_trx r1
2257: ,ra_customer_trx_lines rl1
2258: ,ra_customer_trx_lines rlt1
2259: ,ar_vat_tax v1
2260: ,jl_zz_ar_tx_att_cls tcl1
2261: ,jl_zz_ar_tx_categ tc1

Line 2258: ,ra_customer_trx_lines rlt1

2254: ,rl1.customer_trx_line_id inv_line_number
2255: ,r1.customer_trx_id header_trx_id
2256: FROM ra_customer_trx r1
2257: ,ra_customer_trx_lines rl1
2258: ,ra_customer_trx_lines rlt1
2259: ,ar_vat_tax v1
2260: ,jl_zz_ar_tx_att_cls tcl1
2261: ,jl_zz_ar_tx_categ tc1
2262: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2289: FROM ra_customer_trx r1

2285: ,nvl(rlt1.global_attribute19,0) charged_tax
2286: ,nvl(rlt1.global_attribute20,0) calculated_tax
2287: ,rl1.customer_trx_line_id inv_line_number
2288: ,r1.customer_trx_id header_trx_id
2289: FROM ra_customer_trx r1
2290: ,ra_customer_trx_lines rl1
2291: ,ra_customer_trx_lines rlt1
2292: ,ar_vat_tax v1
2293: ,jl_zz_ar_tx_att_cls tcl1

Line 2290: ,ra_customer_trx_lines rl1

2286: ,nvl(rlt1.global_attribute20,0) calculated_tax
2287: ,rl1.customer_trx_line_id inv_line_number
2288: ,r1.customer_trx_id header_trx_id
2289: FROM ra_customer_trx r1
2290: ,ra_customer_trx_lines rl1
2291: ,ra_customer_trx_lines rlt1
2292: ,ar_vat_tax v1
2293: ,jl_zz_ar_tx_att_cls tcl1
2294: ,jl_zz_ar_tx_categ tc1

Line 2291: ,ra_customer_trx_lines rlt1

2287: ,rl1.customer_trx_line_id inv_line_number
2288: ,r1.customer_trx_id header_trx_id
2289: FROM ra_customer_trx r1
2290: ,ra_customer_trx_lines rl1
2291: ,ra_customer_trx_lines rlt1
2292: ,ar_vat_tax v1
2293: ,jl_zz_ar_tx_att_cls tcl1
2294: ,jl_zz_ar_tx_categ tc1
2295: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2322: FROM ra_customer_trx r1

2318: ,nvl(rlt1.global_attribute19,0) charged_tax
2319: ,nvl(rlt1.global_attribute20,0) calculated_tax
2320: ,rl1.customer_trx_line_id inv_line_number
2321: ,r1.customer_trx_id header_trx_id
2322: FROM ra_customer_trx r1
2323: ,ra_customer_trx r2
2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1

Line 2323: ,ra_customer_trx r2

2319: ,nvl(rlt1.global_attribute20,0) calculated_tax
2320: ,rl1.customer_trx_line_id inv_line_number
2321: ,r1.customer_trx_id header_trx_id
2322: FROM ra_customer_trx r1
2323: ,ra_customer_trx r2
2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1
2327: ,jl_zz_ar_tx_att_cls tcl1

Line 2324: ,ra_customer_trx_lines rl1

2320: ,rl1.customer_trx_line_id inv_line_number
2321: ,r1.customer_trx_id header_trx_id
2322: FROM ra_customer_trx r1
2323: ,ra_customer_trx r2
2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1
2327: ,jl_zz_ar_tx_att_cls tcl1
2328: ,jl_zz_ar_tx_categ tc1

Line 2325: ,ra_customer_trx_lines rlt1

2321: ,r1.customer_trx_id header_trx_id
2322: FROM ra_customer_trx r1
2323: ,ra_customer_trx r2
2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1
2327: ,jl_zz_ar_tx_att_cls tcl1
2328: ,jl_zz_ar_tx_categ tc1
2329: WHERE r2.related_customer_trx_id = p_prev_cust_trx_id

Line 2362: FROM ra_customer_trx r1

2358: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2359: calculated_tax
2360: ,rl1.customer_trx_line_id inv_line_number
2361: ,r1.customer_trx_id header_trx_id
2362: FROM ra_customer_trx r1
2363: ,ra_customer_trx_lines rl1
2364: ,ra_customer_trx_lines rlt1
2365: ,ar_vat_tax v1
2366: ,jl_zz_ar_tx_att_cls tcl1

Line 2363: ,ra_customer_trx_lines rl1

2359: calculated_tax
2360: ,rl1.customer_trx_line_id inv_line_number
2361: ,r1.customer_trx_id header_trx_id
2362: FROM ra_customer_trx r1
2363: ,ra_customer_trx_lines rl1
2364: ,ra_customer_trx_lines rlt1
2365: ,ar_vat_tax v1
2366: ,jl_zz_ar_tx_att_cls tcl1
2367: ,jl_zz_ar_tx_categ tc1

Line 2364: ,ra_customer_trx_lines rlt1

2360: ,rl1.customer_trx_line_id inv_line_number
2361: ,r1.customer_trx_id header_trx_id
2362: FROM ra_customer_trx r1
2363: ,ra_customer_trx_lines rl1
2364: ,ra_customer_trx_lines rlt1
2365: ,ar_vat_tax v1
2366: ,jl_zz_ar_tx_att_cls tcl1
2367: ,jl_zz_ar_tx_categ tc1
2368: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2395: FROM ra_customer_trx r1

2391: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2392: calculated_tax
2393: ,rl1.customer_trx_line_id inv_line_number
2394: ,r1.customer_trx_id header_trx_id
2395: FROM ra_customer_trx r1
2396: ,ra_customer_trx_lines rl1
2397: ,ra_customer_trx_lines rlt1
2398: ,ar_vat_tax v1
2399: ,jl_zz_ar_tx_att_cls tcl1

Line 2396: ,ra_customer_trx_lines rl1

2392: calculated_tax
2393: ,rl1.customer_trx_line_id inv_line_number
2394: ,r1.customer_trx_id header_trx_id
2395: FROM ra_customer_trx r1
2396: ,ra_customer_trx_lines rl1
2397: ,ra_customer_trx_lines rlt1
2398: ,ar_vat_tax v1
2399: ,jl_zz_ar_tx_att_cls tcl1
2400: ,jl_zz_ar_tx_categ tc1

Line 2397: ,ra_customer_trx_lines rlt1

2393: ,rl1.customer_trx_line_id inv_line_number
2394: ,r1.customer_trx_id header_trx_id
2395: FROM ra_customer_trx r1
2396: ,ra_customer_trx_lines rl1
2397: ,ra_customer_trx_lines rlt1
2398: ,ar_vat_tax v1
2399: ,jl_zz_ar_tx_att_cls tcl1
2400: ,jl_zz_ar_tx_categ tc1
2401: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2428: FROM ra_customer_trx r1

2424: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2425: calculated_tax
2426: ,rl1.customer_trx_line_id inv_line_number
2427: ,r1.customer_trx_id header_trx_id
2428: FROM ra_customer_trx r1
2429: ,ra_customer_trx_lines rl1
2430: ,ra_customer_trx_lines rlt1
2431: ,ar_vat_tax v1
2432: ,jl_zz_ar_tx_att_cls tcl1

Line 2429: ,ra_customer_trx_lines rl1

2425: calculated_tax
2426: ,rl1.customer_trx_line_id inv_line_number
2427: ,r1.customer_trx_id header_trx_id
2428: FROM ra_customer_trx r1
2429: ,ra_customer_trx_lines rl1
2430: ,ra_customer_trx_lines rlt1
2431: ,ar_vat_tax v1
2432: ,jl_zz_ar_tx_att_cls tcl1
2433: ,jl_zz_ar_tx_categ tc1

Line 2430: ,ra_customer_trx_lines rlt1

2426: ,rl1.customer_trx_line_id inv_line_number
2427: ,r1.customer_trx_id header_trx_id
2428: FROM ra_customer_trx r1
2429: ,ra_customer_trx_lines rl1
2430: ,ra_customer_trx_lines rlt1
2431: ,ar_vat_tax v1
2432: ,jl_zz_ar_tx_att_cls tcl1
2433: ,jl_zz_ar_tx_categ tc1
2434: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2461: FROM ra_customer_trx r1

2457: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2458: calculated_tax
2459: ,rl1.customer_trx_line_id inv_line_number
2460: ,r1.customer_trx_id header_trx_id
2461: FROM ra_customer_trx r1
2462: ,ra_customer_trx r2
2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1

Line 2462: ,ra_customer_trx r2

2458: calculated_tax
2459: ,rl1.customer_trx_line_id inv_line_number
2460: ,r1.customer_trx_id header_trx_id
2461: FROM ra_customer_trx r1
2462: ,ra_customer_trx r2
2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1
2466: ,jl_zz_ar_tx_att_cls tcl1

Line 2463: ,ra_customer_trx_lines rl1

2459: ,rl1.customer_trx_line_id inv_line_number
2460: ,r1.customer_trx_id header_trx_id
2461: FROM ra_customer_trx r1
2462: ,ra_customer_trx r2
2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1
2466: ,jl_zz_ar_tx_att_cls tcl1
2467: ,jl_zz_ar_tx_categ tc1

Line 2464: ,ra_customer_trx_lines rlt1

2460: ,r1.customer_trx_id header_trx_id
2461: FROM ra_customer_trx r1
2462: ,ra_customer_trx r2
2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1
2466: ,jl_zz_ar_tx_att_cls tcl1
2467: ,jl_zz_ar_tx_categ tc1
2468: WHERE r2.related_customer_trx_id = p_rel_cust_trx_id

Line 2496: FROM ra_customer_trx r1

2492: ,nvl(rlt1.global_attribute19,0) charged_tax
2493: ,nvl(rlt1.global_attribute20,0) calculated_tax
2494: ,rl1.customer_trx_line_id inv_line_number
2495: ,r1.customer_trx_id header_trx_id
2496: FROM ra_customer_trx r1
2497: ,ra_customer_trx_lines rl1
2498: ,ra_customer_trx_lines rlt1
2499: ,ar_vat_tax v1
2500: ,jl_zz_ar_tx_att_cls tcl1

Line 2497: ,ra_customer_trx_lines rl1

2493: ,nvl(rlt1.global_attribute20,0) calculated_tax
2494: ,rl1.customer_trx_line_id inv_line_number
2495: ,r1.customer_trx_id header_trx_id
2496: FROM ra_customer_trx r1
2497: ,ra_customer_trx_lines rl1
2498: ,ra_customer_trx_lines rlt1
2499: ,ar_vat_tax v1
2500: ,jl_zz_ar_tx_att_cls tcl1
2501: ,jl_zz_ar_tx_categ tc1

Line 2498: ,ra_customer_trx_lines rlt1

2494: ,rl1.customer_trx_line_id inv_line_number
2495: ,r1.customer_trx_id header_trx_id
2496: FROM ra_customer_trx r1
2497: ,ra_customer_trx_lines rl1
2498: ,ra_customer_trx_lines rlt1
2499: ,ar_vat_tax v1
2500: ,jl_zz_ar_tx_att_cls tcl1
2501: ,jl_zz_ar_tx_categ tc1
2502: WHERE r1.customer_trx_id = rl1.customer_trx_id

Line 2523: FROM ra_customer_trx_lines rlt1

2519: ORDER BY 7, 6, 1;
2520:
2521: cursor rel_trx_categ is
2522: SELECT tc1.tax_category_id tax_category_id
2523: FROM ra_customer_trx_lines rlt1
2524: ,ar_vat_tax v1
2525: ,jl_zz_ar_tx_categ tc1
2526: WHERE rlt1.customer_trx_id = p_rel_cust_trx_id
2527: AND rlt1.line_type= 'TAX'

Line 2535: FROM ra_customer_trx_lines rlt1

2531: AND tc1.threshold_check_grp_by = 'DOCUMENT';
2532:
2533: cursor cur_trx_categ is
2534: SELECT tc1.tax_category_id tax_category_id
2535: FROM ra_customer_trx_lines rlt1
2536: ,ar_vat_tax v1
2537: ,jl_zz_ar_tx_categ tc1
2538: WHERE rlt1.customer_trx_id = p_curr_cust_trx_id
2539: AND rlt1.line_type= 'TAX'

Line 3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

3917: l_org_id NUMBER;
3918: l_country_code varchar2(2);
3919:
3920: -- bug#6834705
3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c

Line 3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

3918: l_country_code varchar2(2);
3919:
3920: -- bug#6834705
3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

Line 3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL

Line 3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)

3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL
3931: WHERE org_id = c_org_id

Line 3930: FROM RA_CUSTOMER_TRX_ALL

3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL
3931: WHERE org_id = c_org_id
3932: AND customer_trx_id = c_customer_trx_id ;
3933:
3934: BEGIN