View: PA_OUTPUT_TAX_HANDLING_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_OUTPUT_TAX_HANDLING_V

View Text

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)

Columns