Product: | OKC - Contracts Core |
---|---|
Description: | View for Time - Generic Start End |
Implementation/DBA Data: | APPS.OKC_TIME_IG_STARTEND_VAL_V |
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.DESCRIPTION
, IGS.SHORT_DESCRIPTION
, IGS.COMMENTS
, 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
FROM OKC_TIMEVALUES TGD1
, OKC_TIMEVALUES TGD2
, OKC_TIMEVALUES 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'