VIEW: APPS.PA_OUTPUT_TAX_HANDLING_V

Source

View Text - Preformatted

SELECT LK.LOOKUP_CODE , LK.MEANING , zxp.org_id FROM FND_LOOKUPS LK, ZX_PRODUCT_OPTIONS ZXP WHERE ZXP.tax_method_code <> 'LTE' AND ZXP.application_id = 222 AND LK.ENABLED_FLAG = 'Y' AND LK.LOOKUP_TYPE = 'ZX_EXEMPTION_CONTROL' AND (LK.lookup_Code IN ('R', 'S') or (LK.lookup_code = 'E' AND zxp.tax_use_customer_exempt_flag = 'Y')) AND SYSDATE BETWEEN LK.START_DATE_ACTIVE AND NVL(LK.END_DATE_ACTIVE,SYSDATE)

View Text - HTML Formatted

SELECT LK.LOOKUP_CODE
, LK.MEANING
, ZXP.ORG_ID
FROM FND_LOOKUPS LK
, ZX_PRODUCT_OPTIONS ZXP
WHERE ZXP.TAX_METHOD_CODE <> 'LTE'
AND ZXP.APPLICATION_ID = 222
AND LK.ENABLED_FLAG = 'Y'
AND LK.LOOKUP_TYPE = 'ZX_EXEMPTION_CONTROL'
AND (LK.LOOKUP_CODE IN ('R'
, 'S') OR (LK.LOOKUP_CODE = 'E'
AND ZXP.TAX_USE_CUSTOMER_EXEMPT_FLAG = 'Y'))
AND SYSDATE BETWEEN LK.START_DATE_ACTIVE
AND NVL(LK.END_DATE_ACTIVE
, SYSDATE)