FND Design Data [Home] [Help]

View: OKC_TIME_CODE_UNITS_V

Product: OKC - Contracts Core
Description: View for table OKC_TIME_CODE_UNITS_B
Implementation/DBA Data: ViewAPPS.OKC_TIME_CODE_UNITS_V
View Text

SELECT TCUB.ROWID ROW_ID
, TCUB.UOM_CODE UOM_CODE
, TCUB.TCE_CODE TCE_CODE
, TCUB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TCUT.SFWT_FLAG SFWT_FLAG
, TCUB.QUANTITY QUANTITY
, TCUT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, TCUT.DESCRIPTION DESCRIPTION
, TCUT.COMMENTS COMMENTS
, TCUB.ACTIVE_FLAG ACTIVE_FLAG
, TCUB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TCUB.ATTRIBUTE1 ATTRIBUTE1
, TCUB.ATTRIBUTE2 ATTRIBUTE2
, TCUB.ATTRIBUTE3 ATTRIBUTE3
, TCUB.ATTRIBUTE4 ATTRIBUTE4
, TCUB.ATTRIBUTE5 ATTRIBUTE5
, TCUB.ATTRIBUTE6 ATTRIBUTE6
, TCUB.ATTRIBUTE7 ATTRIBUTE7
, TCUB.ATTRIBUTE8 ATTRIBUTE8
, TCUB.ATTRIBUTE9 ATTRIBUTE9
, TCUB.ATTRIBUTE10 ATTRIBUTE10
, TCUB.ATTRIBUTE11 ATTRIBUTE11
, TCUB.ATTRIBUTE12 ATTRIBUTE12
, TCUB.ATTRIBUTE13 ATTRIBUTE13
, TCUB.ATTRIBUTE14 ATTRIBUTE14
, TCUB.ATTRIBUTE15 ATTRIBUTE15
, TCUB.CREATED_BY CREATED_BY
, TCUB.CREATION_DATE CREATION_DATE
, TCUB.LAST_UPDATED_BY LAST_UPDATED_BY
, TCUB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TCUB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_TIME_CODE_UNITS_B TCUB
, OKC_TIME_CODE_UNITS_TL TCUT
WHERE TCUB.UOM_CODE = TCUT.UOM_CODE
AND TCUB.TCE_CODE = TCUT.TCE_CODE
AND TCUT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
UOM_CODE
TCE_CODE
OBJECT_VERSION_NUMBER
SFWT_FLAG
QUANTITY
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS
ACTIVE_FLAG
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