ZX_FC_PRODUCT_CATEGORIES_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
CLASSIFICATION_CODE CLASSIFICATION_NAME CLASSIFICATION_ID CONCAT_LEAF_CODE CONCAT_LEAF_NAME COUNTRY_CODE EFFECTIVE_FROM EFFECTIVE_TO

Query

SQL_Statement
SELECT FC.CONCAT_CLASSIF_CODE CLASSIFICATION_CODE, FC.CONCAT_CLASSIF_NAME CLASSIFICATION_NAME, FC.CLASSIFICATION_ID , FC.CLASSIFICATION_CODE CONCAT_LEAF_CODE , FC.CLASSIFICATION_NAME CONCAT_LEAF_NAME, FC.COUNTRY_CODE, FC.EFFECTIVE_FROM, FC.EFFECTIVE_TO FROM ZX_FC_CODES_DENORM_VL FC WHERE FC.CLASSIFICATION_TYPE_CODE = 'PRODUCT_CATEGORY' AND FC.ENABLED_FLAG = 'Y'