View: ZX_FC_PRODUCT_CATEGORIES_V

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

View Text

SELECT FC.CONCAT_CLASSIF_CODE
, FC.CONCAT_CLASSIF_NAME
, FC.COUNTRY_CODE
, FC.EFFECTIVE_FROM
, FC.EFFECTIVE_TO
FROM ZX_FC_CODES_DENORM_B FC
WHERE FC.CLASSIFICATION_TYPE_CODE = 'PRODUCT_CATEGORY'
AND FC.LANGUAGE = USERENV ( 'LANG')
AND FC.ENABLED_FLAG = 'Y'