DBA Data[Home] [Help]

VIEW: APPS.FII_TIME_RPT_STRUCT_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)