1. Tables and Views for Financials
  2. ZX_FC_INTENDED_USE_V

ZX_FC_INTENDED_USE_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

CLASSIFICATION_ID

CODE

NAME

COUNTRY_CODE

EFFECTIVE_FROM

EFFECTIVE_TO

Query

SQL_Statement

SELECT MC.CATEGORY_ID CLASSIFICATION_ID,

MC.CATEGORY_CODE CODE,

MCT.DESCRIPTION NAME,

NULL COUNTRY_CODE,

ZFT.EFFECTIVE_FROM EFFECTIVE_FROM,

MC.END_DATE_ACTIVE EFFECTIVE_TO

FROM EGP_CATEGORIES_TL MCT,

EGP_CATEGORIES_B MC,

ZX_FC_TYPES_B ZFT,

EGP_CATEGORY_SETS_B MCS

WHERE ZFT.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE'

AND MCS.CATEGORY_SET_ID = ZFT.OWNER_ID_NUM

AND MC.CATEGORY_ID = MCT.CATEGORY_ID

AND MCT.LANGUAGE = USERENV ( 'LANG')

AND MC.ENABLED_FLAG = 'Y'

UNION ALL

SELECT FC.CLASSIFICATION_ID CLASSIFICATION_ID,

FC.CLASSIFICATION_CODE CODE,

T.CLASSIFICATION_NAME NAME,

FC.COUNTRY_CODE COUNTRY_CODE,

FC.EFFECTIVE_FROM EFFECTIVE_FROM,

FC.EFFECTIVE_TO EFFECTIVE_TO

FROM ZX_FC_CODES_TL T, ZX_FC_CODES_B FC

where FC.CLASSIFICATION_ID = T.CLASSIFICATION_ID

and T.LANGUAGE = userenv('LANG')

AND FC.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE'