eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKC_TIME_CYCLE_SPAN_V

Product:	OKC - Contracts Core
Description:	View over timevalue and span
Implementation/DBA Data:	APPS.OKC_TIME_CYCLE_SPAN_V

View Text

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'

Columns

Name
ID
OBJECT_VERSION_NUMBER
TZE_ID
SFWT_FLAG
TVE_ID_LIMITED
DNZ_CHR_ID
DESCRIPTION
SHORT_DESCRIPTION
COMMENTS
NAME
SPN_ID
INTERVAL_YN
ACTIVE_YN
DURATION
UOM_CODE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN