1. Tables and Views for SCM
  2. CMF_FD_OUT_ORIGIN_CFOPS_V

CMF_FD_OUT_ORIGIN_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 = 'SALES_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))