View: ZX_FC_BUSINESS_CATEGORIES_V

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

View Text

SELECT FC.CONCAT_CLASSIF_CODE CONCAT_CLASSIF_CODE
, FC.CONCAT_CLASSIF_NAME CONCAT_CLASSIF_NAME
, FC.COUNTRY_CODE COUNTRY_CODE
, FC.EFFECTIVE_FROM EFFECTIVE_FROM
, FC.EFFECTIVE_TO EFFECTIVE_TO
, EV.APPLICATION_ID APPLICATION_ID
, EV.EVENT_CLASS_CODE EVENT_CLASS_CODE
, EV.TAX_EVENT_CLASS_CODE TAX_EVNT_CLS_CODE
, EV.ENTITY_CODE ENTITY_CODE
, FC.CLASSIFICATION_CODE_LEVEL
FROM ZX_FC_CODES_DENORM_B FC
, ZX_EVNT_CLS_MAPPINGS EV
WHERE FC.CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY'
AND FC.LANGUAGE = USERENV('LANG')
AND FC.ENABLED_FLAG = 'Y'
AND EV.TAX_EVENT_CLASS_CODE = FC.SEGMENT1 UNION ALL SELECT FC.CONCAT_CLASSIF_CODE CONCAT_CLASSIF_CODE
, FC.CONCAT_CLASSIF_NAME CONCAT_CLASSIF_NAME
, FC.COUNTRY_CODE COUNTRY_CODE
, FC.EFFECTIVE_FROM EFFECTIVE_FROM
, FC.EFFECTIVE_TO EFFECTIVE_TO
, EV.APPLICATION_ID APPLICATION_ID
, EV.EVENT_CLASS_CODE EVENT_CLASS_CODE
, EV.TAX_EVENT_CLASS_CODE TAX_EVNT_CLS_CODE
, EV.ENTITY_CODE ENTITY_CODE
, FC.CLASSIFICATION_CODE_LEVEL
FROM ZX_FC_CODES_DENORM_B FC
, ZX_EVNT_CLS_MAPPINGS EV
WHERE FC.CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY'
AND FC.LANGUAGE = USERENV('LANG')
AND FC.ENABLED_FLAG = 'Y'
AND EV.INTRCMP_TX_EVNT_CLS_CODE = FC.SEGMENT1
AND EV.INTRCMP_TX_EVNT_CLS_CODE IS NOT NULL