PAY_TMPLT_CLMN_INST_TRANS_F

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
CLMN_INST_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE COL_ID BASE_CLMN_INST_ID BASE_COL_VALUE ROW_INST_ID COL_VALUE COL_CLOB_VALUE SURROGATE_KEY_VALUE RENAME_FLAG RULE_ID USE_EXISTING_REC OBJECT_VERSION_NUMBER LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SGUID

Name

CLMN_INST_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

COL_ID

BASE_CLMN_INST_ID

BASE_COL_VALUE

ROW_INST_ID

COL_VALUE

COL_CLOB_VALUE

SURROGATE_KEY_VALUE

RENAME_FLAG

RULE_ID

USE_EXISTING_REC

OBJECT_VERSION_NUMBER

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

ENTERPRISE_ID

MODULE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SGUID

Query

SQL_Statement
SELECT PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID CLMN_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PAY_TMPLT_CLMN_INST_TRANS_F.COL_ID COL_ID, PAY_TMPLT_CLMN_INST_TRANS_F.BASE_CLMN_INST_ID BASE_CLMN_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_F.BASE_COL_VALUE BASE_COL_VALUE, PAY_TMPLT_CLMN_INST_TRANS_F.ROW_INST_ID ROW_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_F_TL.COL_VALUE COL_VALUE, PAY_TMPLT_CLMN_INST_TRANS_F.COL_CLOB_VALUE COL_CLOB_VALUE, PAY_TMPLT_CLMN_INST_TRANS_F.SURROGATE_KEY_VALUE SURROGATE_KEY_VALUE, PAY_TMPLT_CLMN_INST_TRANS_F.RENAME_FLAG RENAME_FLAG, PAY_TMPLT_CLMN_INST_TRANS_F.RULE_ID RULE_ID, PAY_TMPLT_CLMN_INST_TRANS_F.USE_EXISTING_REC USE_EXISTING_REC, PAY_TMPLT_CLMN_INST_TRANS_F.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATION_CODE LEGISLATION_CODE, PAY_TMPLT_CLMN_INST_TRANS_F.ENTERPRISE_ID ENTERPRISE_ID, PAY_TMPLT_CLMN_INST_TRANS_F.MODULE_ID MODULE_ID, PAY_TMPLT_CLMN_INST_TRANS_F.CREATED_BY CREATED_BY, PAY_TMPLT_CLMN_INST_TRANS_F.CREATION_DATE CREATION_DATE, PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_TMPLT_CLMN_INST_TRANS_F.SGUID SGUID FROM PAY_TMPLT_CLMN_INST_TRANS_F, PAY_TMPLT_CLMN_INST_TRANS_F_TL WHERE PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID = PAY_TMPLT_CLMN_INST_TRANS_F_TL.CLMN_INST_ID AND PAY_TMPLT_CLMN_INST_TRANS_F_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID CLMN_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

PAY_TMPLT_CLMN_INST_TRANS_F.COL_ID COL_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.BASE_CLMN_INST_ID BASE_CLMN_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.BASE_COL_VALUE BASE_COL_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_F.ROW_INST_ID ROW_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_F_TL.COL_VALUE COL_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_F.COL_CLOB_VALUE COL_CLOB_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_F.SURROGATE_KEY_VALUE SURROGATE_KEY_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_F.RENAME_FLAG RENAME_FLAG,

PAY_TMPLT_CLMN_INST_TRANS_F.RULE_ID RULE_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.USE_EXISTING_REC USE_EXISTING_REC,

PAY_TMPLT_CLMN_INST_TRANS_F.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATION_CODE LEGISLATION_CODE,

PAY_TMPLT_CLMN_INST_TRANS_F.ENTERPRISE_ID ENTERPRISE_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.MODULE_ID MODULE_ID,

PAY_TMPLT_CLMN_INST_TRANS_F.CREATED_BY CREATED_BY,

PAY_TMPLT_CLMN_INST_TRANS_F.CREATION_DATE CREATION_DATE,

PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_TMPLT_CLMN_INST_TRANS_F.SGUID SGUID

FROM

PAY_TMPLT_CLMN_INST_TRANS_F,

PAY_TMPLT_CLMN_INST_TRANS_F_TL

WHERE

PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID = PAY_TMPLT_CLMN_INST_TRANS_F_TL.CLMN_INST_ID AND PAY_TMPLT_CLMN_INST_TRANS_F_TL.LANGUAGE = USERENV('LANG')