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.

[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_ATT_CLS

Line 715: jl_zz_ar_tx_att_cls tcac

711: FROM jl_zz_ar_tx_nat_rat tnr,
712: jl_zz_ar_tx_att_val tcav,
713: jl_zz_ar_tx_categ tc,
714: jl_zz_ar_tx_cat_att tca,
715: jl_zz_ar_tx_att_cls tcac
716: WHERE tcac.tax_attr_class_code = p_transaction_nature_class
717: AND tcac.tax_category_id = p_tax_category_id
718: AND tcac.tax_attr_class_type = 'TRANSACTION_CLASS'
719: AND tcac.enabled_flag = 'Y'

Line 1712: FROM jl_zz_ar_tx_att_cls ac

1708: BEGIN
1709: -- Bugfix 1388703
1710: SELECT ac.tax_attribute_value
1711: INTO l_curr_nature_class_value
1712: FROM jl_zz_ar_tx_att_cls ac
1713: WHERE ac.tax_attr_class_type = 'TRANSACTION_CLASS'
1714: AND ac.tax_attr_class_code = p_transaction_nature_class
1715: AND ac.tax_category_id = p_tax_category_id
1716: AND ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'

Line 1745: jl_zz_ar_tx_att_cls ota,

1741: into l_establishment_type,
1742: l_contributor_type
1743: FROM jl_zz_ar_tx_cus_cls cta,
1744: hz_cust_site_uses rsu,
1745: jl_zz_ar_tx_att_cls ota,
1746: jl_zz_ar_tx_categ tc
1747: WHERE tc.tax_category_id = p_tax_category_id
1748: AND tc.threshold_check_grp_by = 'DOCUMENT'
1749: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'

Line 1766: FROM jl_zz_ar_tx_att_cls cta,

1762: select ota.tax_attribute_value,
1763: cta.tax_attribute_value
1764: into l_establishment_type,
1765: l_contributor_type
1766: FROM jl_zz_ar_tx_att_cls cta,
1767: jl_zz_ar_tx_att_cls ota,
1768: jl_zz_ar_tx_categ tc
1769: WHERE tc.tax_category_id = p_tax_category_id
1770: AND tc.threshold_check_grp_by = 'DOCUMENT'

Line 1767: jl_zz_ar_tx_att_cls ota,

1763: cta.tax_attribute_value
1764: into l_establishment_type,
1765: l_contributor_type
1766: FROM jl_zz_ar_tx_att_cls cta,
1767: jl_zz_ar_tx_att_cls ota,
1768: jl_zz_ar_tx_categ tc
1769: WHERE tc.tax_category_id = p_tax_category_id
1770: AND tc.threshold_check_grp_by = 'DOCUMENT'
1771: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'

Line 2010: jl_zz_ar_tx_att_cls tcac

2006: CURSOR trx_nature IS
2007: SELECT tcav.tax_categ_attr_val_id tax_categ_attr_val_id
2008: FROM jl_zz_ar_tx_att_val tcav,
2009: jl_zz_ar_tx_cat_att tca,
2010: jl_zz_ar_tx_att_cls tcac
2011: WHERE tcav.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
2012: AND tcav.tax_category_id = p_tax_category_id
2013: AND tcac.tax_attr_class_code = p_transaction_nature_class
2014: AND tcac.tax_category_id = tcav.tax_category_id

Line 2227: ,jl_zz_ar_tx_att_cls tcl1

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
2230: AND r1.customer_trx_id = p_prev_cust_trx_id
2231: AND rl1.line_type = 'LINE'

Line 2260: ,jl_zz_ar_tx_att_cls tcl1

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
2263: AND r1.related_customer_trx_id = p_prev_cust_trx_id
2264: AND rl1.line_type = 'LINE'

Line 2293: ,jl_zz_ar_tx_att_cls tcl1

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
2296: AND r1.previous_customer_trx_id = p_prev_cust_trx_id
2297: AND r1.customer_trx_id <> p_curr_cust_trx_id

Line 2327: ,jl_zz_ar_tx_att_cls tcl1

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
2330: AND r2.customer_trx_id = r1.previous_customer_trx_id
2331: AND r1.customer_trx_id = rl1.customer_trx_id

Line 2366: ,jl_zz_ar_tx_att_cls tcl1

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
2369: AND r1.customer_trx_id = p_rel_cust_trx_id
2370: AND rl1.line_type = 'LINE'

Line 2399: ,jl_zz_ar_tx_att_cls tcl1

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
2402: AND r1.related_customer_trx_id = p_rel_cust_trx_id
2403: AND rl1.line_type = 'LINE'

Line 2432: ,jl_zz_ar_tx_att_cls tcl1

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
2435: AND r1.previous_customer_trx_id = p_rel_cust_trx_id
2436: AND rl1.line_type = 'LINE'

Line 2466: ,jl_zz_ar_tx_att_cls tcl1

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
2469: AND r2.customer_trx_id = r1.previous_customer_trx_id
2470: AND r1.customer_trx_id = rl1.customer_trx_id

Line 2500: ,jl_zz_ar_tx_att_cls tcl1

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
2503: AND r1.customer_trx_id = p_curr_cust_trx_id
2504: AND rl1.line_type = 'LINE'

Line 2946: FROM jl_zz_ar_tx_att_cls ac

2942: ELSE
2943: BEGIN
2944: SELECT tax_attribute_value
2945: INTO l_grp_attr_val
2946: FROM jl_zz_ar_tx_att_cls ac
2947: WHERE tax_attr_class_type = 'TRANSACTION_CLASS'
2948: AND tax_attr_class_code = p_transaction_nature_class
2949: AND enabled_flag = 'Y'
2950: AND tax_category_id = p_tax_category_id

Line 3441: from jl_zz_ar_tx_att_cls ac

3437: begin
3438: -- Bugfix 1388703
3439: select ac.tax_attribute_value
3440: into v_aux_establishment_type
3441: from jl_zz_ar_tx_att_cls ac
3442: where ac.tax_attr_class_code = p_organization_class
3443: and ac.tax_category_id = v_tax_category_to_reduce_id
3444: and ac.tax_attribute_type = 'ORGANIZATION_ATTRIBUTE'
3445: and ac.tax_attr_class_type = 'ORGANIZATION_CLASS'

Line 3468: from jl_zz_ar_tx_att_cls ac

3464: begin
3465: -- Bugfix 1388703
3466: select ac.tax_attribute_value
3467: into v_aux_transaction_nature
3468: from jl_zz_ar_tx_att_cls ac
3469: where ac.tax_attr_class_code = p_transaction_nature_class
3470: and ac.tax_category_id = v_tax_category_to_reduce_id
3471: and ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
3472: and ac.tax_attr_class_type = 'TRANSACTION_CLASS'

Line 3514: from jl_zz_ar_tx_att_cls ac,

3510: and p_trx_date >= NVL(cat.start_date_active, p_trx_date);
3511: ELSE
3512: select ac.tax_attribute_value
3513: into v_aux_contributor_type
3514: from jl_zz_ar_tx_att_cls ac,
3515: jl_zz_ar_tx_categ cat
3516: where ac.tax_attr_class_code = p_contributor_class
3517: and ac.tax_category_id = v_tax_category_to_reduce_id
3518: and ac.enabled_flag = 'Y'