VIEW: APPS.ZX_FC_BUSINESS_CATEGORIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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