DBA Data[Home] [Help]

VIEW: APPS.ZX_FC_DOCUMENT_FISCAL_V

Source

View Text - Preformatted

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 = 'DOCUMENT_SUBTYPE' AND FC.LANGUAGE = USERENV ( 'LANG') AND FC.ENABLED_FLAG = 'Y'
   
View Text - HTML Formatted

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 = 'DOCUMENT_SUBTYPE'
AND FC.LANGUAGE = USERENV ( 'LANG')
AND FC.ENABLED_FLAG = 'Y'