CMF_FD_IN_CONVERT_CFOPS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FUSION
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
CLASSIFICATION_CODE CLASSIFICATION_NAME |
問合せ
| 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)) |