VIEW: APPS.OKS_COVTIMES_HIST_V

Source

View Text - Preformatted

SELECT IGS.ID ID , IGS.OBJECT_VERSION_NUMBER , 'N' SFWT_FLAG , IGS.TVE_ID_STARTED , IGS.TVE_ID_ENDED , IGS.TVE_ID_LIMITED , IGS.DNZ_CHR_ID , IGS.ATTRIBUTE_CATEGORY , IGS.ATTRIBUTE1 , IGS.ATTRIBUTE2 , IGS.ATTRIBUTE3 , IGS.ATTRIBUTE4 , IGS.ATTRIBUTE5 , IGS.ATTRIBUTE6 , IGS.ATTRIBUTE7 , IGS.ATTRIBUTE8 , IGS.ATTRIBUTE9 , IGS.ATTRIBUTE10 , IGS.ATTRIBUTE11 , IGS.ATTRIBUTE12 , IGS.ATTRIBUTE13 , IGS.ATTRIBUTE14 , IGS.ATTRIBUTE15 , IGS.CREATED_BY , IGS.CREATION_DATE , IGS.LAST_UPDATED_BY , IGS.LAST_UPDATE_DATE , IGS.LAST_UPDATE_LOGIN , IGS.TZE_ID, TGD1.MONTH START_MONTH, TGD1.NTH START_NTH, TGD1.DAY_OF_WEEK START_DAY_OF_WEEK, TGD1.DAY START_DAY, TGD1.HOUR START_HOUR, TGD1.MINUTE START_MINUTE, TGD1.SECOND START_SECOND, TGD2.MONTH END_MONTH, TGD2.NTH END_NTH, TGD2.DAY_OF_WEEK END_DAY_OF_WEEK, TGD2.DAY END_DAY, TGD2.HOUR END_HOUR, TGD2.MINUTE END_MINUTE, TGD2.SECOND END_SECOND ,IGS.MAJOR_VERSION FROM OKC_TIMEVALUES_BH TGD1, OKC_TIMEVALUES_BH TGD2, OKC_TIMEVALUES_BH IGS WHERE TGD1.ID = IGS.TVE_ID_STARTED AND tgd1.tve_type = 'TGD' AND TGD2.ID = IGS.TVE_ID_ENDED AND tgd2.tve_type = 'TGD' AND igs.tve_type = 'IGS' AND TGD1.major_version = IGS.major_version AND TGD2.major_version = IGS.major_version

View Text - HTML Formatted

SELECT IGS.ID ID
, IGS.OBJECT_VERSION_NUMBER
, 'N' SFWT_FLAG
, IGS.TVE_ID_STARTED
, IGS.TVE_ID_ENDED
, IGS.TVE_ID_LIMITED
, IGS.DNZ_CHR_ID
, IGS.ATTRIBUTE_CATEGORY
, IGS.ATTRIBUTE1
, IGS.ATTRIBUTE2
, IGS.ATTRIBUTE3
, IGS.ATTRIBUTE4
, IGS.ATTRIBUTE5
, IGS.ATTRIBUTE6
, IGS.ATTRIBUTE7
, IGS.ATTRIBUTE8
, IGS.ATTRIBUTE9
, IGS.ATTRIBUTE10
, IGS.ATTRIBUTE11
, IGS.ATTRIBUTE12
, IGS.ATTRIBUTE13
, IGS.ATTRIBUTE14
, IGS.ATTRIBUTE15
, IGS.CREATED_BY
, IGS.CREATION_DATE
, IGS.LAST_UPDATED_BY
, IGS.LAST_UPDATE_DATE
, IGS.LAST_UPDATE_LOGIN
, IGS.TZE_ID
, TGD1.MONTH START_MONTH
, TGD1.NTH START_NTH
, TGD1.DAY_OF_WEEK START_DAY_OF_WEEK
, TGD1.DAY START_DAY
, TGD1.HOUR START_HOUR
, TGD1.MINUTE START_MINUTE
, TGD1.SECOND START_SECOND
, TGD2.MONTH END_MONTH
, TGD2.NTH END_NTH
, TGD2.DAY_OF_WEEK END_DAY_OF_WEEK
, TGD2.DAY END_DAY
, TGD2.HOUR END_HOUR
, TGD2.MINUTE END_MINUTE
, TGD2.SECOND END_SECOND
, IGS.MAJOR_VERSION
FROM OKC_TIMEVALUES_BH TGD1
, OKC_TIMEVALUES_BH TGD2
, OKC_TIMEVALUES_BH IGS
WHERE TGD1.ID = IGS.TVE_ID_STARTED
AND TGD1.TVE_TYPE = 'TGD'
AND TGD2.ID = IGS.TVE_ID_ENDED
AND TGD2.TVE_TYPE = 'TGD'
AND IGS.TVE_TYPE = 'IGS'
AND TGD1.MAJOR_VERSION = IGS.MAJOR_VERSION
AND TGD2.MAJOR_VERSION = IGS.MAJOR_VERSION