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 JL_ZZ_AR_TX_CATEG

Line 267: FROM jl_zz_ar_tx_categ cat

263: UNION
264: SELECT cat.tax_code,
265: NULL,
266: NULL
267: FROM jl_zz_ar_tx_categ cat
268: WHERE cat.tax_category_id = p_tax_category_id
269: AND p_trx_date <= cat.end_date_active
270: AND p_trx_date >= NVL(cat.start_date_active,p_trx_date);
271:

Line 729: jl_zz_ar_tx_categ tc,

725: tnr.base_rate,
726: tnr.txn_nature_id
727: FROM jl_zz_ar_tx_nat_rat tnr,
728: jl_zz_ar_tx_att_val tcav,
729: jl_zz_ar_tx_categ tc,
730: jl_zz_ar_tx_cat_att tca,
731: jl_zz_ar_tx_att_cls tcac
732: WHERE tcac.tax_attr_class_code = p_transaction_nature_class
733: AND tcac.tax_category_id = p_tax_category_id

Line 1766: jl_zz_ar_tx_categ tc

1762: l_contributor_type
1763: FROM jl_zz_ar_tx_cus_cls cta,
1764: hz_cust_site_uses rsu,
1765: jl_zz_ar_tx_att_cls ota,
1766: jl_zz_ar_tx_categ tc
1767: WHERE tc.tax_category_id = p_tax_category_id
1768: AND tc.threshold_check_grp_by = 'DOCUMENT'
1769: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'
1770: AND ota.tax_category_id = tc.tax_category_id

Line 1788: jl_zz_ar_tx_categ tc

1784: into l_establishment_type,
1785: l_contributor_type
1786: FROM jl_zz_ar_tx_att_cls cta,
1787: jl_zz_ar_tx_att_cls ota,
1788: jl_zz_ar_tx_categ tc
1789: WHERE tc.tax_category_id = p_tax_category_id
1790: AND tc.threshold_check_grp_by = 'DOCUMENT'
1791: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'
1792: AND ota.tax_category_id = tc.tax_category_id

Line 2105: FROM jl_zz_ar_tx_categ

2101: WHEN NO_DATA_FOUND THEN
2102: BEGIN
2103: SELECT min_percentage
2104: INTO p_min_tax_rate
2105: FROM jl_zz_ar_tx_categ
2106: WHERE tax_category_id = p_tax_category_id
2107: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2108: AND end_date_active;
2109: EXCEPTION

Line 2128: FROM jl_zz_ar_tx_categ

2124: WHEN NO_DATA_FOUND THEN
2125: BEGIN
2126: SELECT min_amount
2127: INTO p_min_tax_amount
2128: FROM jl_zz_ar_tx_categ
2129: WHERE tax_category_id = p_tax_category_id
2130: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2131: AND end_date_active;
2132: EXCEPTION

Line 2151: FROM jl_zz_ar_tx_categ

2147: WHEN NO_DATA_FOUND THEN
2148: BEGIN
2149: SELECT min_taxable_basis
2150: INTO p_min_taxable_basis
2151: FROM jl_zz_ar_tx_categ
2152: WHERE tax_category_id = p_tax_category_id
2153: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2154: AND end_date_active;
2155: EXCEPTION

Line 2248: ,jl_zz_ar_tx_categ tc1

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
2250: AND r1.customer_trx_id = p_prev_cust_trx_id
2251: AND rl1.line_type = 'LINE'
2252: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2281: ,jl_zz_ar_tx_categ tc1

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
2283: AND r1.related_customer_trx_id = p_prev_cust_trx_id
2284: AND rl1.line_type = 'LINE'
2285: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2314: ,jl_zz_ar_tx_categ tc1

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
2316: AND r1.previous_customer_trx_id = p_prev_cust_trx_id
2317: AND r1.customer_trx_id <> p_curr_cust_trx_id
2318: AND rl1.line_type = 'LINE'

Line 2348: ,jl_zz_ar_tx_categ tc1

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
2350: AND r2.customer_trx_id = r1.previous_customer_trx_id
2351: AND r1.customer_trx_id = rl1.customer_trx_id
2352: AND rl1.line_type = 'LINE'

Line 2387: ,jl_zz_ar_tx_categ tc1

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
2389: AND r1.customer_trx_id = p_rel_cust_trx_id
2390: AND rl1.line_type = 'LINE'
2391: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2420: ,jl_zz_ar_tx_categ tc1

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
2422: AND r1.related_customer_trx_id = p_rel_cust_trx_id
2423: AND rl1.line_type = 'LINE'
2424: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2453: ,jl_zz_ar_tx_categ tc1

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
2455: AND r1.previous_customer_trx_id = p_rel_cust_trx_id
2456: AND rl1.line_type = 'LINE'
2457: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2487: ,jl_zz_ar_tx_categ tc1

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
2489: AND r2.customer_trx_id = r1.previous_customer_trx_id
2490: AND r1.customer_trx_id = rl1.customer_trx_id
2491: AND rl1.line_type = 'LINE'

Line 2521: ,jl_zz_ar_tx_categ tc1

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
2523: AND r1.customer_trx_id = p_curr_cust_trx_id
2524: AND rl1.line_type = 'LINE'
2525: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2545: ,jl_zz_ar_tx_categ tc1

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'
2548: AND rlt1.vat_tax_id = v1.vat_tax_id
2549: AND v1.tax_type = 'VAT'

Line 2557: ,jl_zz_ar_tx_categ tc1

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'
2560: AND rlt1.vat_tax_id = v1.vat_tax_id
2561: AND v1.tax_type = 'VAT'

Line 2939: FROM jl_zz_ar_tx_categ

2935: SELECT threshold_check_grp_by,
2936: threshold_check_level
2937: INTO l_grp_attr_name,
2938: l_operation_level
2939: FROM jl_zz_ar_tx_categ
2940: WHERE tax_category_id = p_tax_category_id
2941: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2942: AND end_date_active;
2943: EXCEPTION

Line 3461: FROM jl_zz_ar_tx_categ tc,

3457: v_tax_category_to_reduce_id,
3458: v_location_structure_id,
3459: v_location_segment_num,
3460: v_set_of_books_id
3461: FROM jl_zz_ar_tx_categ tc,
3462: ar_system_parameters_all sp
3463: WHERE tc.tax_category_id = p_tax_category_id
3464: AND p_trx_date <= tc.end_date_active
3465: AND p_trx_date >= NVL(tc.start_date_active, p_trx_date)

Line 3526: from jl_zz_ar_tx_categ cat

3522: and ac.tax_attribute_type = 'ORGANIZATION_ATTRIBUTE'
3523: and ac.tax_attr_class_type = 'ORGANIZATION_CLASS'
3524: and ac.enabled_flag = 'Y'
3525: and exists (select 1
3526: from jl_zz_ar_tx_categ cat
3527: where cat.tax_category_id = ac.tax_category_id
3528: and ac.tax_attribute_name = cat.org_tax_attribute
3529: and p_trx_date <= cat.end_date_active
3530: and p_trx_date >= NVL(cat.start_date_active, p_trx_date));

Line 3553: from jl_zz_ar_tx_categ cat

3549: and ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
3550: and ac.tax_attr_class_type = 'TRANSACTION_CLASS'
3551: and ac.enabled_flag = 'Y'
3552: and exists (select 1
3553: from jl_zz_ar_tx_categ cat
3554: where cat.tax_category_id = ac.tax_category_id
3555: and ac.tax_attribute_name = cat.txn_tax_attribute
3556: and p_trx_date <= cat.end_date_active
3557: and p_trx_date >= NVL(cat.start_date_active, p_trx_date));

Line 3578: jl_zz_ar_tx_categ cat

3574: select ac.tax_attribute_value
3575: into v_aux_contributor_type
3576: from jl_zz_ar_tx_cus_cls ac,
3577: hz_cust_site_uses su,
3578: jl_zz_ar_tx_categ cat
3579: where ac.tax_attr_class_code = p_contributor_class
3580: and ac.tax_category_id = v_tax_category_to_reduce_id
3581: and ac.enabled_flag = 'Y'
3582: and cat.tax_category_id = ac.tax_category_id

Line 3593: jl_zz_ar_tx_categ cat

3589: ELSE
3590: select ac.tax_attribute_value
3591: into v_aux_contributor_type
3592: from jl_zz_ar_tx_att_cls ac,
3593: jl_zz_ar_tx_categ cat
3594: where ac.tax_attr_class_code = p_contributor_class
3595: and ac.tax_category_id = v_tax_category_to_reduce_id
3596: and ac.enabled_flag = 'Y'
3597: and ac.tax_attr_class_type = 'CONTRIBUTOR_CLASS'