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_AR_AUTOINV_PKG dependencies on JL_ZZ_AR_TX_CATEG_ALL

Line 160: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ_all cat

156: l_tax_category_id IS NOT NULL THEN
157: BEGIN
158: SELECT tax_attribute_name, tax_attribute_value
159: INTO l_org_attribute_name, l_org_attribute_value
160: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ_all cat
161: WHERE cls.tax_attr_class_type = 'ORGANIZATION_CLASS'
162: AND cls.tax_attr_class_code = l_organization_class_code
163: AND cls.tax_category_id = l_tax_category_id
164: AND cls.tax_category_id = cat.tax_category_id

Line 193: FROM jl_zz_ar_tx_cus_cls cus, jl_zz_ar_tx_categ_all cat

189: IF l_cus_cls_flag = 'Y' THEN
190: BEGIN
191: SELECT tax_attribute_name, tax_attribute_value
192: INTO l_cust_attribute_name, l_cust_attribute_value
193: FROM jl_zz_ar_tx_cus_cls cus, jl_zz_ar_tx_categ_all cat
194: WHERE cus.tax_attr_class_code = l_contributor_class_code
195: AND cus.address_id = trx_lines_rec.orig_system_address_id
196: AND cus.tax_category_id = l_tax_category_id
197: AND cus.tax_category_id = cat.tax_category_id

Line 216: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ_all cat

212: ELSE
213: BEGIN
214: SELECT tax_attribute_name, tax_attribute_value
215: INTO l_cust_attribute_name, l_cust_attribute_value
216: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ_all cat
217: WHERE att.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
218: AND att.tax_attr_class_code = l_contributor_class_code
219: AND att.tax_category_id = l_tax_category_id
220: AND att.tax_attribute_name = cat.cus_tax_attribute