1. Tables and Views for Financials
  2. ZX_FC_BUSINESS_CATEGORIES_V

ZX_FC_BUSINESS_CATEGORIES_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

CONCAT_CLASSIF_CODE

CONCAT_CLASSIF_NAME

COUNTRY_CODE

EFFECTIVE_FROM

EFFECTIVE_TO

APPLICATION_ID

EVENT_CLASS_CODE

TAX_EVNT_CLS_CODE

ENTITY_CODE

CLASSIFICATION_CODE_LEVEL

CLASSIFICATION_CODE

CLASSIFICATION_NAME

CLASSIFICATION_ID

Query

SQL_Statement

SELECT FC.CONCAT_CLASSIF_CODE CONCAT_CLASSIF_CODE,

T.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,

FC.CLASSIFICATION_CODE,

T.CLASSIFICATION_NAME,

FC.CLASSIFICATION_ID

FROM ZX_FC_CODES_DENORM_B FC,

ZX_FC_CODES_DENORM_TL T,

ZX_EVNT_CLS_MAPPINGS EV

WHERE FC.CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY'

AND FC.ENABLED_FLAG = 'Y'

AND (EV.TAX_EVENT_CLASS_CODE = FC.SEGMENT1

OR (EV.INTRCMP_TX_EVNT_CLS_CODE =FC.SEGMENT1

AND EV.INTRCMP_TX_EVNT_CLS_CODE IS NOT NULL))

AND NVL(EV.INDIRECT_TAX_OR_WHT_FLAG,'I') ='I'

AND FC.CLASSIFICATION_CODES_DENORM_ID = T.CLASSIFICATION_CODES_DENORM_ID

AND T.LANGUAGE = userenv('LANG')