VIEW: APPS.OKC_TIME_IA_STARTEND_REL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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