Product: | OKC - Contracts Core |
---|---|
Description: | View for Time - Relative Start End |
Implementation/DBA Data: | APPS.OKC_TIME_IA_STARTEND_REL_V |
SELECT ISE1.START_DATE START_PARENT_DATE
, OKC_TIME_UTIL_PUB.GET_ENDDATE( ISE1.START_DATE
, TAL.UOM_CODE
, (DECODE(TAL.BEFORE_AFTER
, 'B'
, -1
, 'A'
, 1) * TAL.DURATION)) START_DATE
, OKC_TIME_UTIL_PUB.GET_ENDDATE( OKC_TIME_UTIL_PUB.GET_ENDDATE( ISE1.START_DATE
, TAL.UOM_CODE
, (DECODE(TAL.BEFORE_AFTER
, 'B'
, -1
, 'A'
, 1) * TAL.DURATION))
, ISE.UOM_CODE
, ISE.DURATION) END_DATE
, ISE.ID
, ISE.TZE_ID
, TAL.UOM_CODE START_UOM_CODE
, TAL.DURATION START_DURATION
, TAL.TVE_ID_OFFSET START_TVE_ID_OFFSET
, ISE.OBJECT_VERSION_NUMBER
, ISE.SFWT_FLAG
, ISE.TVE_ID_STARTED
, ISE.TVE_ID_ENDED
, ISE.TVE_ID_LIMITED
, ISE.DNZ_CHR_ID
, ISE.DESCRIPTION
, ISE.SHORT_DESCRIPTION
, ISE.COMMENTS
, ISE.OPERATOR
, ISE.DURATION
, ISE.UOM_CODE
, ISE.BEFORE_AFTER
, ISE.ATTRIBUTE_CATEGORY
, ISE.ATTRIBUTE1
, ISE.ATTRIBUTE2
, ISE.ATTRIBUTE3
, ISE.ATTRIBUTE4
, ISE.ATTRIBUTE5
, ISE.ATTRIBUTE6
, ISE.ATTRIBUTE7
, ISE.ATTRIBUTE8
, ISE.ATTRIBUTE9
, ISE.ATTRIBUTE10
, ISE.ATTRIBUTE11
, ISE.ATTRIBUTE12
, ISE.ATTRIBUTE13
, ISE.ATTRIBUTE14
, ISE.ATTRIBUTE15
, ISE.CREATED_BY
, ISE.CREATION_DATE
, ISE.LAST_UPDATED_BY
, ISE.LAST_UPDATE_DATE
, ISE.LAST_UPDATE_LOGIN
FROM OKC_TIME_TPA_RELATIVE_V TAL
, OKC_TIME_IA_STARTEND_V ISE
, OKC_TIME_IA_STARTEND_VAL_V ISE1
WHERE TAL.ID = ISE.TVE_ID_STARTED
AND ISE1.ID = TAL.TVE_ID_OFFSET