PAY_TMPLT_CLMN_INST_TRANS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
CLMN_INST_ID BASE_CLMN_INST_ID BASE_COL_VALUE ROW_INST_ID COL_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

BASE_CLMN_INST_ID

BASE_COL_VALUE

ROW_INST_ID

COL_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_B.CLMN_INST_ID CLMN_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_B.BASE_CLMN_INST_ID BASE_CLMN_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_B.BASE_COL_VALUE BASE_COL_VALUE, PAY_TMPLT_CLMN_INST_TRANS_B.ROW_INST_ID ROW_INST_ID, PAY_TMPLT_CLMN_INST_TRANS_B.COL_ID COL_ID, PAY_TMPLT_CLMN_INST_TRANS_TL.COL_VALUE COL_VALUE, PAY_TMPLT_CLMN_INST_TRANS_B.COL_CLOB_VALUE COL_CLOB_VALUE, PAY_TMPLT_CLMN_INST_TRANS_B.SURROGATE_KEY_VALUE SURROGATE_KEY_VALUE, PAY_TMPLT_CLMN_INST_TRANS_B.RENAME_FLAG RENAME_FLAG, PAY_TMPLT_CLMN_INST_TRANS_B.RULE_ID RULE_ID, PAY_TMPLT_CLMN_INST_TRANS_B.USE_EXISTING_REC USE_EXISTING_REC, PAY_TMPLT_CLMN_INST_TRANS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAY_TMPLT_CLMN_INST_TRANS_B.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_TMPLT_CLMN_INST_TRANS_B.LEGISLATION_CODE LEGISLATION_CODE, PAY_TMPLT_CLMN_INST_TRANS_B.ENTERPRISE_ID ENTERPRISE_ID, PAY_TMPLT_CLMN_INST_TRANS_B.MODULE_ID MODULE_ID, PAY_TMPLT_CLMN_INST_TRANS_B.CREATED_BY CREATED_BY, PAY_TMPLT_CLMN_INST_TRANS_B.CREATION_DATE CREATION_DATE, PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_TMPLT_CLMN_INST_TRANS_B.SGUID SGUID FROM PAY_TMPLT_CLMN_INST_TRANS_B, PAY_TMPLT_CLMN_INST_TRANS_TL WHERE PAY_TMPLT_CLMN_INST_TRANS_B.CLMN_INST_ID = PAY_TMPLT_CLMN_INST_TRANS_TL.CLMN_INST_ID AND PAY_TMPLT_CLMN_INST_TRANS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PAY_TMPLT_CLMN_INST_TRANS_B.CLMN_INST_ID CLMN_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.BASE_CLMN_INST_ID BASE_CLMN_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.BASE_COL_VALUE BASE_COL_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_B.ROW_INST_ID ROW_INST_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.COL_ID COL_ID,

PAY_TMPLT_CLMN_INST_TRANS_TL.COL_VALUE COL_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_B.COL_CLOB_VALUE COL_CLOB_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_B.SURROGATE_KEY_VALUE SURROGATE_KEY_VALUE,

PAY_TMPLT_CLMN_INST_TRANS_B.RENAME_FLAG RENAME_FLAG,

PAY_TMPLT_CLMN_INST_TRANS_B.RULE_ID RULE_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.USE_EXISTING_REC USE_EXISTING_REC,

PAY_TMPLT_CLMN_INST_TRANS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_TMPLT_CLMN_INST_TRANS_B.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.LEGISLATION_CODE LEGISLATION_CODE,

PAY_TMPLT_CLMN_INST_TRANS_B.ENTERPRISE_ID ENTERPRISE_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.MODULE_ID MODULE_ID,

PAY_TMPLT_CLMN_INST_TRANS_B.CREATED_BY CREATED_BY,

PAY_TMPLT_CLMN_INST_TRANS_B.CREATION_DATE CREATION_DATE,

PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_TMPLT_CLMN_INST_TRANS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_TMPLT_CLMN_INST_TRANS_B.SGUID SGUID

FROM

PAY_TMPLT_CLMN_INST_TRANS_B,

PAY_TMPLT_CLMN_INST_TRANS_TL

WHERE

PAY_TMPLT_CLMN_INST_TRANS_B.CLMN_INST_ID = PAY_TMPLT_CLMN_INST_TRANS_TL.CLMN_INST_ID AND PAY_TMPLT_CLMN_INST_TRANS_TL.LANGUAGE = USERENV('LANG')