CMF_FD_IN_CONVERT_CFOPS_V
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: VIEW
Columns
Name |
---|
CLASSIFICATION_CODE CLASSIFICATION_NAME |
Query
SQL_Statement |
---|
SELECT ZXBC.CLASSIFICATION_CODE, ZXBC.CLASSIFICATION_NAME FROM ZX_FC_BUSINESS_CATEGORIES_V ZXBC WHERE ZXBC.COUNTRY_CODE = 'BR' AND ZXBC.EVENT_CLASS_CODE = 'PURCHASE_TRANSACTION' AND ZXBC.CONCAT_CLASSIF_CODE LIKE '%OPERATION_FISCAL_CODE%' AND ZXBC.CLASSIFICATION_CODE_LEVEL = 3 AND TRUNC(SYSDATE) >= TRUNC(ZXBC.EFFECTIVE_FROM) AND TRUNC(SYSDATE) < TRUNC(NVL(ZXBC.EFFECTIVE_TO,SYSDATE+1)) |