Product: | OKC - Contracts Core |
---|---|
Description: | View for event based Time |
Implementation/DBA Data: | APPS.OKC_TIME_RELATED_TO_EVENT_V |
SELECT TAL.ID ID
, TAL.OPERATOR OPERATOR
, TAL.BEFORE_AFTER BEFORE_AFTER
, TAL.DURATION DURATION
, TAL.UOM_CODE UOM_CODE
, TAL.TVE_ID_OFFSET TVE_ID_OFFSET
, TGN.CNH_ID CNH_ID
, TAL.SPN_ID SPN_ID
, TAL.DNZ_CHR_ID DNZ_CHR_ID
, TAL.TVE_ID_LIMITED TVE_ID_LIMITED
, TAL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAL.TZE_ID
, 'N' SFWT_FLAG
, TAL.DESCRIPTION DESCRIPTION
, TAL.SHORT_DESCRIPTION SHORT_DESCRIPTION
, TAL.COMMENTS COMMENTS
, TAL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TAL.ATTRIBUTE1 ATTRIBUTE1
, TAL.ATTRIBUTE2 ATTRIBUTE2
, TAL.ATTRIBUTE3 ATTRIBUTE3
, TAL.ATTRIBUTE4 ATTRIBUTE4
, TAL.ATTRIBUTE5 ATTRIBUTE5
, TAL.ATTRIBUTE6 ATTRIBUTE6
, TAL.ATTRIBUTE7 ATTRIBUTE7
, TAL.ATTRIBUTE8 ATTRIBUTE8
, TAL.ATTRIBUTE9 ATTRIBUTE9
, TAL.ATTRIBUTE10 ATTRIBUTE10
, TAL.ATTRIBUTE11 ATTRIBUTE11
, TAL.ATTRIBUTE12 ATTRIBUTE12
, TAL.ATTRIBUTE13 ATTRIBUTE13
, TAL.ATTRIBUTE14 ATTRIBUTE14
, TAL.ATTRIBUTE15 ATTRIBUTE15
, TAL.CREATED_BY CREATED_BY
, TAL.CREATION_DATE CREATION_DATE
, TAL.LAST_UPDATED_BY LAST_UPDATED_BY
, TAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_TIMEVALUES TAL
, OKC_TIMEVALUES TGN
WHERE TGN.ID = TAL.TVE_ID_OFFSET
AND TAL.TVE_TYPE = 'TAL'
AND TGN.TVE_TYPE = 'TGN' UNION SELECT TGN.ID ID
, NULL OPERATOR
, 'O' BEFORE_AFTER
, TO_NUMBER(NULL) DURATION
, NULL UOM_CODE
, TO_NUMBER(NULL) TVE_ID_OFFSET
, TGN.CNH_ID CNH_ID
, TO_NUMBER(NULL) SPN_ID
, TGN.DNZ_CHR_ID DNZ_CHR_ID
, TGN.TVE_ID_LIMITED TVE_ID_LIMITED
, TGN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TGN.TZE_ID
, 'N' SFWT_FLAG
, TGN.DESCRIPTION DESCRIPTION
, TGN.SHORT_DESCRIPTION SHORT_DESCRIPTION
, TGN.COMMENTS COMMENTS
, TGN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TGN.ATTRIBUTE1 ATTRIBUTE1
, TGN.ATTRIBUTE2 ATTRIBUTE2
, TGN.ATTRIBUTE3 ATTRIBUTE3
, TGN.ATTRIBUTE4 ATTRIBUTE4
, TGN.ATTRIBUTE5 ATTRIBUTE5
, TGN.ATTRIBUTE6 ATTRIBUTE6
, TGN.ATTRIBUTE7 ATTRIBUTE7
, TGN.ATTRIBUTE8 ATTRIBUTE8
, TGN.ATTRIBUTE9 ATTRIBUTE9
, TGN.ATTRIBUTE10 ATTRIBUTE10
, TGN.ATTRIBUTE11 ATTRIBUTE11
, TGN.ATTRIBUTE12 ATTRIBUTE12
, TGN.ATTRIBUTE13 ATTRIBUTE13
, TGN.ATTRIBUTE14 ATTRIBUTE14
, TGN.ATTRIBUTE15 ATTRIBUTE15
, TGN.CREATED_BY CREATED_BY
, TGN.CREATION_DATE CREATION_DATE
, TGN.LAST_UPDATED_BY LAST_UPDATED_BY
, TGN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TGN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_TIMEVALUES TGN
WHERE TGN.TVE_TYPE = 'TGN'
AND NOT EXISTS ( SELECT NULL
FROM OKC_TIMEVALUES
WHERE TVE_TYPE = 'TAL'
AND TVE_ID_OFFSET = TGN.ID)