View: ZX_OUTPUT_CLASSIFICATIONS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_OUTPUT_CLASSIFICATIONS_V

View Text

SELECT TCC.ORG_ID ORG_ID
, COALESCE(RVL.TAX_RATE_NAME
, LKP.MEANING
, LKP.LOOKUP_CODE) MEANING
, COALESCE(RVL.DESCRIPTION
, RVL.TAX_RATE_NAME
, LKP.DESCRIPTION
, LKP.MEANING
, LKP.LOOKUP_CODE) DESCRIPTION
, TCC.TAX_CLASSIFICATION_CODE LOOKUP_CODE
, LKP.LOOKUP_TYPE LOOKUP_TYPE
, LKP.LEAF_NODE LEAF_NODE
, LKP.ENABLED_FLAG ENABLED_FLAG
, NVL(TCC.EFFECTIVE_FROM
, LKP.START_DATE_ACTIVE) START_DATE_ACTIVE
, COALESCE(LEAST(TCC.EFFECTIVE_TO
, LKP.END_DATE_ACTIVE)
, TCC.EFFECTIVE_TO
, LKP.END_DATE_ACTIVE) END_DATE_ACTIVE
, TCC.TAX_TYPE TAX_TYPE
, TCC.TAX_CLASS TAX_CLASS FROM ( SELECT DECODE(CREATED_BY
, -1087
, NVL(SUBSTRB(TAG
, 1
, 50)
, LOOKUP_CODE)
, LOOKUP_CODE) LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LOOKUP_TYPE
, LEAF_NODE FROM FND_LOOKUP_VALUES WHERE LANGUAGE = USERENV('LANG')
AND LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS'
AND SECURITY_GROUP_ID = 0
AND VIEW_APPLICATION_ID = 0 ) LKP
, ZX_ID_TCC_MAPPING_ALL TCC
, ZX_RATES_VL RVL WHERE TCC.TAX_CLASSIFICATION_CODE = LKP.LOOKUP_CODE
AND TCC.TAX_RATE_CODE_ID = RVL.TAX_RATE_ID(+)
AND TCC.ACTIVE_FLAG = 'Y'
AND (TCC.TAX_CLASS = 'OUTPUT' OR TCC.TAX_CLASS IS NULL)