VIEW: APPS.OKC_TIME_IA_STARTEND_VAL_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'