[Home] [Help]
View: ZX_OUTPUT_CLASSIFICATIONS_V
View Text
SELECT
TCC.ORG_ID ORG_ID
,
LKP.MEANING MEANING
,
LKP.DESCRIPTION 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
,
CASE WHEN(NVL(TCC.EFFECTIVE_TO
,
TO_DATE('31/12/4712'
,
'DD/MM/YYYY')) - NVL(LKP.END_DATE_ACTIVE
,
TO_DATE('31/12/4712'
,
'DD/MM/YYYY'))) < 0 THEN TCC.EFFECTIVE_TO ELSE LKP.END_DATE_ACTIVE END END_DATE_ACTIVE
,
TCC.TAX_TYPE TAX_TYPE
,
TCC.TAX_CLASS TAX_CLASS
FROM
(
SELECT
MEANING
,
DECODE(CREATED_BY
,
-1087
,
NVL(SUBSTRB(TAG
,
1
,
50)
,
LOOKUP_CODE)
,
LOOKUP_CODE) LOOKUP_CODE
,
ENABLED_FLAG
,
START_DATE_ACTIVE
,
END_DATE_ACTIVE
,
LOOKUP_TYPE
,
DESCRIPTION
,
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
WHERE
TCC.TAX_CLASSIFICATION_CODE = LKP.LOOKUP_CODE
AND TCC.ACTIVE_FLAG = 'Y'
AND (TCC.TAX_CLASS = 'OUTPUT' OR TCC.TAX_CLASS IS NULL)