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_ATT_CLS

Line 731: jl_zz_ar_tx_att_cls tcac

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
734: AND tcac.tax_attr_class_type = 'TRANSACTION_CLASS'
735: AND tcac.enabled_flag = 'Y'

Line 1732: FROM jl_zz_ar_tx_att_cls ac

1728: BEGIN
1729: -- Bugfix 1388703
1730: SELECT ac.tax_attribute_value
1731: INTO l_curr_nature_class_value
1732: FROM jl_zz_ar_tx_att_cls ac
1733: WHERE ac.tax_attr_class_type = 'TRANSACTION_CLASS'
1734: AND ac.tax_attr_class_code = p_transaction_nature_class
1735: AND ac.tax_category_id = p_tax_category_id
1736: AND ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'

Line 1765: jl_zz_ar_tx_att_cls ota,

1761: into l_establishment_type,
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'

Line 1786: FROM jl_zz_ar_tx_att_cls cta,

1782: select ota.tax_attribute_value,
1783: cta.tax_attribute_value
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'

Line 1787: jl_zz_ar_tx_att_cls ota,

1783: cta.tax_attribute_value
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'

Line 2030: jl_zz_ar_tx_att_cls tcac

2026: CURSOR trx_nature IS
2027: SELECT tcav.tax_categ_attr_val_id tax_categ_attr_val_id
2028: FROM jl_zz_ar_tx_att_val tcav,
2029: jl_zz_ar_tx_cat_att tca,
2030: jl_zz_ar_tx_att_cls tcac
2031: WHERE tcav.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
2032: AND tcav.tax_category_id = p_tax_category_id
2033: AND tcac.tax_attr_class_code = p_transaction_nature_class
2034: AND tcac.tax_category_id = tcav.tax_category_id

Line 2247: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2280: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2313: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2347: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2386: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2419: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2452: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2486: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2520: ,jl_zz_ar_tx_att_cls tcl1

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

Line 2994: FROM jl_zz_ar_tx_att_cls ac

2990: ELSE
2991: BEGIN
2992: SELECT tax_attribute_value
2993: INTO l_grp_attr_val
2994: FROM jl_zz_ar_tx_att_cls ac
2995: WHERE tax_attr_class_type = 'TRANSACTION_CLASS'
2996: AND tax_attr_class_code = p_transaction_nature_class
2997: AND enabled_flag = 'Y'
2998: AND tax_category_id = p_tax_category_id

Line 3519: from jl_zz_ar_tx_att_cls ac

3515: begin
3516: -- Bugfix 1388703
3517: select ac.tax_attribute_value
3518: into v_aux_establishment_type
3519: from jl_zz_ar_tx_att_cls ac
3520: where ac.tax_attr_class_code = p_organization_class
3521: and ac.tax_category_id = v_tax_category_to_reduce_id
3522: and ac.tax_attribute_type = 'ORGANIZATION_ATTRIBUTE'
3523: and ac.tax_attr_class_type = 'ORGANIZATION_CLASS'

Line 3546: from jl_zz_ar_tx_att_cls ac

3542: begin
3543: -- Bugfix 1388703
3544: select ac.tax_attribute_value
3545: into v_aux_transaction_nature
3546: from jl_zz_ar_tx_att_cls ac
3547: where ac.tax_attr_class_code = p_transaction_nature_class
3548: and ac.tax_category_id = v_tax_category_to_reduce_id
3549: and ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
3550: and ac.tax_attr_class_type = 'TRANSACTION_CLASS'

Line 3592: from jl_zz_ar_tx_att_cls ac,

3588: and p_trx_date >= NVL(cat.start_date_active, p_trx_date);
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'