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_TCM_VALIDATE_EXEMPT_PKG dependencies on ZX_EXEMPTIONS_V

Line 99: FROM ZX_EXEMPTIONS_V

95: IF p_exemption_status = 'P' THEN
96: BEGIN
97: SELECT 'Y'
98: INTO x_valid_flag
99: FROM ZX_EXEMPTIONS_V
100: WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
101: AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
102: AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
103: AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id

Line 119: FROM ZX_EXEMPTIONS_V

115: ELSIF p_exemption_status = 'PM' THEN
116: BEGIN
117: SELECT 'Y'
118: INTO x_valid_flag
119: FROM ZX_EXEMPTIONS_V
120: WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
121: AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
122: AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
123: AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id

Line 139: FROM ZX_EXEMPTIONS_V

135: ELSIF p_exemption_status = 'PMU' THEN
136: BEGIN
137: SELECT 'Y'
138: INTO x_valid_flag
139: FROM ZX_EXEMPTIONS_V
140: WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
141: AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
142: AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
143: AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id