ZX_FC_DOCUMENT_FISCAL_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
CONCAT_CLASSIF_CODE CONCAT_CLASSIF_NAME COUNTRY_CODE EFFECTIVE_FROM EFFECTIVE_TO CLASSIFICATION_CODE CLASSIFICATION_NAME CLASSIFICATION_ID

Query

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