CMF_FISCAL_DOC_ASSOCTNS

Details

Schema: FUSION
Object owner: CMF
Object type: VIEW

Columns

Name
FISCAL_DOC_ASSOCTNS_ID COUNTRY_CODE ASSOCIATION_CODE FISCAL_PROC_OPTIONS_ID ACTIVE_FLAG START_DATE END_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SEED_FLAG DESCRIPTION NAME

Name

FISCAL_DOC_ASSOCTNS_ID

COUNTRY_CODE

ASSOCIATION_CODE

FISCAL_PROC_OPTIONS_ID

ACTIVE_FLAG

START_DATE

END_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

SEED_FLAG

DESCRIPTION

NAME

Query

SQL_Statement
SELECT CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_DOC_ASSOCTNS_ID FISCAL_DOC_ASSOCTNS_ID, CMF_FISCAL_DOC_ASSOCTNS_B.COUNTRY_CODE COUNTRY_CODE, CMF_FISCAL_DOC_ASSOCTNS_B.ASSOCIATION_CODE ASSOCIATION_CODE, CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_PROC_OPTIONS_ID FISCAL_PROC_OPTIONS_ID, CMF_FISCAL_DOC_ASSOCTNS_B.ACTIVE_FLAG ACTIVE_FLAG, CMF_FISCAL_DOC_ASSOCTNS_B.START_DATE START_DATE, CMF_FISCAL_DOC_ASSOCTNS_B.END_DATE END_DATE, CMF_FISCAL_DOC_ASSOCTNS_B.CREATED_BY CREATED_BY, CMF_FISCAL_DOC_ASSOCTNS_B.CREATION_DATE CREATION_DATE, CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMF_FISCAL_DOC_ASSOCTNS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMF_FISCAL_DOC_ASSOCTNS_B.SEED_FLAG SEED_FLAG, CMF_FISCAL_DOC_ASSOCTNS_TL.DESCRIPTION DESCRIPTION, CMF_FISCAL_DOC_ASSOCTNS_TL.NAME NAME FROM CMF_FISCAL_DOC_ASSOCTNS_B, CMF_FISCAL_DOC_ASSOCTNS_TL WHERE CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_DOC_ASSOCTNS_ID = CMF_FISCAL_DOC_ASSOCTNS_TL.FISCAL_DOC_ASSOCTNS_ID AND CMF_FISCAL_DOC_ASSOCTNS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_DOC_ASSOCTNS_ID FISCAL_DOC_ASSOCTNS_ID,

CMF_FISCAL_DOC_ASSOCTNS_B.COUNTRY_CODE COUNTRY_CODE,

CMF_FISCAL_DOC_ASSOCTNS_B.ASSOCIATION_CODE ASSOCIATION_CODE,

CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_PROC_OPTIONS_ID FISCAL_PROC_OPTIONS_ID,

CMF_FISCAL_DOC_ASSOCTNS_B.ACTIVE_FLAG ACTIVE_FLAG,

CMF_FISCAL_DOC_ASSOCTNS_B.START_DATE START_DATE,

CMF_FISCAL_DOC_ASSOCTNS_B.END_DATE END_DATE,

CMF_FISCAL_DOC_ASSOCTNS_B.CREATED_BY CREATED_BY,

CMF_FISCAL_DOC_ASSOCTNS_B.CREATION_DATE CREATION_DATE,

CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CMF_FISCAL_DOC_ASSOCTNS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CMF_FISCAL_DOC_ASSOCTNS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CMF_FISCAL_DOC_ASSOCTNS_B.SEED_FLAG SEED_FLAG,

CMF_FISCAL_DOC_ASSOCTNS_TL.DESCRIPTION DESCRIPTION,

CMF_FISCAL_DOC_ASSOCTNS_TL.NAME NAME

FROM

CMF_FISCAL_DOC_ASSOCTNS_B,

CMF_FISCAL_DOC_ASSOCTNS_TL

WHERE

CMF_FISCAL_DOC_ASSOCTNS_B.FISCAL_DOC_ASSOCTNS_ID = CMF_FISCAL_DOC_ASSOCTNS_TL.FISCAL_DOC_ASSOCTNS_ID AND CMF_FISCAL_DOC_ASSOCTNS_TL.LANGUAGE = USERENV('LANG')