VIEW: APPS.OKC_TIME_CYCLE_SPAN_V

Source

View Text - Preformatted

SELECT CYL.ID, CYL.OBJECT_VERSION_NUMBER, CYL.TZE_ID, 'N' SFWT_FLAG, CYL.TVE_ID_LIMITED, CYL.DNZ_CHR_ID, CYL.DESCRIPTION, CYL.SHORT_DESCRIPTION, CYL.COMMENTS, CYL.NAME, CYL.SPN_ID, CYL.INTERVAL_YN, SPN.ACTIVE_YN, SPN.DURATION, SPN.uom_code, CYL.ATTRIBUTE_CATEGORY, CYL.ATTRIBUTE1, CYL.ATTRIBUTE2, CYL.ATTRIBUTE3, CYL.ATTRIBUTE4, CYL.ATTRIBUTE5, CYL.ATTRIBUTE6, CYL.ATTRIBUTE7, CYL.ATTRIBUTE8, CYL.ATTRIBUTE9, CYL.ATTRIBUTE10, CYL.ATTRIBUTE11, CYL.ATTRIBUTE12, CYL.ATTRIBUTE13, CYL.ATTRIBUTE14, CYL.ATTRIBUTE15, CYL.CREATED_BY, CYL.CREATION_DATE, CYL.LAST_UPDATED_BY, CYL.LAST_UPDATE_DATE, CYL.LAST_UPDATE_LOGIN FROM OKC_SPAN SPN, OKC_TIMEVALUES CYL WHERE SPN.TVE_ID = CYL.ID AND CYL.tve_type = 'CYL'

View Text - HTML Formatted

SELECT CYL.ID
, CYL.OBJECT_VERSION_NUMBER
, CYL.TZE_ID
, 'N' SFWT_FLAG
, CYL.TVE_ID_LIMITED
, CYL.DNZ_CHR_ID
, CYL.DESCRIPTION
, CYL.SHORT_DESCRIPTION
, CYL.COMMENTS
, CYL.NAME
, CYL.SPN_ID
, CYL.INTERVAL_YN
, SPN.ACTIVE_YN
, SPN.DURATION
, SPN.UOM_CODE
, CYL.ATTRIBUTE_CATEGORY
, CYL.ATTRIBUTE1
, CYL.ATTRIBUTE2
, CYL.ATTRIBUTE3
, CYL.ATTRIBUTE4
, CYL.ATTRIBUTE5
, CYL.ATTRIBUTE6
, CYL.ATTRIBUTE7
, CYL.ATTRIBUTE8
, CYL.ATTRIBUTE9
, CYL.ATTRIBUTE10
, CYL.ATTRIBUTE11
, CYL.ATTRIBUTE12
, CYL.ATTRIBUTE13
, CYL.ATTRIBUTE14
, CYL.ATTRIBUTE15
, CYL.CREATED_BY
, CYL.CREATION_DATE
, CYL.LAST_UPDATED_BY
, CYL.LAST_UPDATE_DATE
, CYL.LAST_UPDATE_LOGIN
FROM OKC_SPAN SPN
, OKC_TIMEVALUES CYL
WHERE SPN.TVE_ID = CYL.ID
AND CYL.TVE_TYPE = 'CYL'