FND Design Data [Home] [Help]

View: FII_TIME_RPT_STRUCT_V

Product: FII - Financial Intelligence
Description: Internal view used to support Time Dimension roll up functionality in DBI.
Implementation/DBA Data: ViewAPPS.FII_TIME_RPT_STRUCT_V
View Text

SELECT "CALENDAR_ID"
, "CALENDAR_TYPE"
, "REPORT_DATE"
, "TIME_ID"
, "PERIOD_TYPE_ID"
, "RECORD_TYPE_ID"
, "CREATION_DATE"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
FROM FII_TIME_RPT_STRUCT
WHERE RECORD_TYPE_ID IN (1
, 2
, 4
, 8
, 16
, 32
, 64
, 1024)

Columns

Name
CALENDAR_ID
CALENDAR_TYPE
REPORT_DATE
TIME_ID
PERIOD_TYPE_ID
RECORD_TYPE_ID
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
LAST_UPDATE_LOGIN