FND Design Data [Home] [Help]

View: OKL_SERVICES_V

Product: OKL - Lease and Finance Management
Description: View for OKL_SERVICES_B and OKL_SERVICES_TL
Implementation/DBA Data: ViewAPPS.OKL_SERVICES_V
View Text

SELECT SVC.ROWID ROW_ID
, SVC.ID ID
, SVC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SVC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SVC.ATTRIBUTE1 ATTRIBUTE1
, SVC.ATTRIBUTE2 ATTRIBUTE2
, SVC.ATTRIBUTE3 ATTRIBUTE3
, SVC.ATTRIBUTE4 ATTRIBUTE4
, SVC.ATTRIBUTE5 ATTRIBUTE5
, SVC.ATTRIBUTE6 ATTRIBUTE6
, SVC.ATTRIBUTE7 ATTRIBUTE7
, SVC.ATTRIBUTE8 ATTRIBUTE8
, SVC.ATTRIBUTE9 ATTRIBUTE9
, SVC.ATTRIBUTE10 ATTRIBUTE10
, SVC.ATTRIBUTE11 ATTRIBUTE11
, SVC.ATTRIBUTE12 ATTRIBUTE12
, SVC.ATTRIBUTE13 ATTRIBUTE13
, SVC.ATTRIBUTE14 ATTRIBUTE14
, SVC.ATTRIBUTE15 ATTRIBUTE15
, SVC.CREATED_BY CREATED_BY
, SVC.CREATION_DATE CREATION_DATE
, SVC.LAST_UPDATED_BY LAST_UPDATED_BY
, SVC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SVC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SVC.INV_ITEM_ID INV_ITEM_ID
, SVC.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
, SVC.PARENT_OBJECT_ID PARENT_OBJECT_ID
, SVC.EFFECTIVE_FROM EFFECTIVE_FROM
, SVC.SUPPLIER_ID SUPPLIER_ID
, SVCT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, SVCT.DESCRIPTION DESCRIPTION
, SVCT.COMMENTS COMMENTS
FROM OKL_SERVICES_B SVC
, OKL_SERVICES_TL SVCT
WHERE SVC.ID = SVCT.ID
AND SVCT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
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
INV_ITEM_ID
PARENT_OBJECT_CODE
PARENT_OBJECT_ID
EFFECTIVE_FROM
SUPPLIER_ID
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS