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.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 117: FROM zx_output_classifications_v l,

113: c_org_id NUMBER) IS
114: SELECT p.output_tax_code,
115: p.retention_tax_code
116: -- FROM fnd_lookups l, pa_projects p bug#4574838
117: FROM zx_output_classifications_v l,
118: pa_projects p
119: WHERE p.project_id = c_project_id
120: AND l.lookup_code = decode(c_retention_flag,'TRUE',p.retention_tax_code,p.output_tax_code)
121: AND l.org_id IN (c_org_id, -99)

Line 236: FROM zx_output_classifications_v l,

232: (c_expenditure_item_id NUMBER,
233: c_org_id NUMBER,
234: c_trx_date DATE) IS
235: SELECT l.lookup_code
236: FROM zx_output_classifications_v l,
237: -- fnd_lookups l, bug#4574838
238: pa_expenditure_type_ous_all type,
239: pa_expenditure_items_all item
240: WHERE item.expenditure_item_id = c_expenditure_item_id

Line 960: from zx_output_classifications_v

956: cursor c_chk_tax_classif_code( c_tax_code in VARCHAR2,
957: c_org_id in NUMBER,
958: c_trx_date DATE) is
959: select lookup_code
960: from zx_output_classifications_v
961: where lookup_code = c_tax_code
962: AND org_id IN (c_org_id, -99)
963: AND enabled_flag = 'Y'
964: AND (start_date_active <= c_trx_date OR

Line 1520: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l

1516: c_org_id NUMBER,
1517: c_trx_date date)
1518: IS
1519: SELECT su.tax_code
1520: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l
1521: WHERE su.site_use_id = c_site_use_id
1522: AND su.org_id = c_org_id
1523: AND l.lookup_code = su.tax_code
1524: AND l.org_id IN (c_org_id, -99)

Line 1653: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l

1649: c_org_id NUMBER,
1650: c_trx_date DATE)
1651: IS
1652: SELECT c.tax_code
1653: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l
1654: WHERE c.cust_account_id = c_customer_id
1655: AND c.org_id = c_org_id
1656: AND l.lookup_code = c.tax_code
1657: AND l.org_id IN (c_org_id, -99)

Line 1783: FROM zx_output_classifications_v l, AR_MEMO_LINES m

1779: c_org_id NUMBER)
1780: IS
1781: SELECT m.tax_code
1782: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1783: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1784: WHERE m.memo_line_id = c_memo_line_id
1785: AND l.lookup_code = m.tax_code
1786: AND l.org_id IN (c_org_id, -99)
1787: AND l.enabled_flag = 'Y'

Line 1804: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i

1800: c_org_id NUMBER)
1801: IS
1802: SELECT i.tax_code
1803: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1804: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1805: WHERE i.inventory_item_id = c_item_id
1806: AND i.organization_id = c_organization_id
1807: AND l.lookup_code = i.tax_code
1808: AND l.org_id IN (c_org_id, -99)