View: OKC_TIME_IA_STARTEND_VAL_V

Product:	OKC - Contracts Core
Description:	View for Time - Absolute Start End
Implementation/DBA Data:	APPS.OKC_TIME_IA_STARTEND_VAL_V

View Text

SELECT TAV1.DATETIME START_DATE
, OKC_TIME_UTIL_PUB.GET_ENDDATE(TAV1.DATETIME
, ISE.UOM_CODE
, ISE.DURATION) END_DATE
, ISE.ID
, ISE.OBJECT_VERSION_NUMBER
, ISE.TZE_ID
, 'N' 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_TIMEVALUES TAV1
, OKC_TIMEVALUES ISE
WHERE TAV1.ID = ISE.TVE_ID_STARTED
AND TAV1.TVE_TYPE = 'TAV'
AND ISE.TVE_TYPE = 'ISE'

Columns