CN_PER_INT_TYPES_ALL

Details

Schema: FUSION
Object owner: CN
Object type: VIEW

Columns

Name
PER_INT_TYPE_ID PERIOD_ID INTERVAL_NAME INTERVAL_TYPE_ID ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CALENDAR_ID

Name

PER_INT_TYPE_ID

PERIOD_ID

INTERVAL_NAME

INTERVAL_TYPE_ID

ORG_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

CALENDAR_ID

Query

SQL_Statement
SELECT B.PER_INT_TYPE_ID, B.period_id, t.INTERVAL_name, b.INTERVAL_TYPE_id,b.ORG_ID, B.LAST_UPDATE_DATE,B.LAST_UPDATED_BY , B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATE_LOGIN , b.object_Version_number, CALENDAR_ID FROM CN_PER_INT_TYPES_all_B B, CN_PER_INT_TYPES_all_TL T WHERE B.ORG_ID = T.ORG_ID AND B.PER_INT_TYPE_id= T.PER_INT_TYPE_id AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT B.PER_INT_TYPE_ID, B.period_id, t.INTERVAL_name, b.INTERVAL_TYPE_id,b.ORG_ID, B.LAST_UPDATE_DATE,B.LAST_UPDATED_BY , B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATE_LOGIN ,

b.object_Version_number, CALENDAR_ID

FROM

CN_PER_INT_TYPES_all_B B,

CN_PER_INT_TYPES_all_TL T

WHERE

B.ORG_ID = T.ORG_ID

AND B.PER_INT_TYPE_id= T.PER_INT_TYPE_id

AND T.LANGUAGE = USERENV('LANG')