[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_STRATEGIES_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SGYB.ROWID ROW_ID
, SGYB.ID ID
, SGYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SGYT.SFWT_FLAG SFWT_FLAG
, SGYB.ISM_ID ISM_ID
, SGYB.CST_CODE CST_CODE
, SGYT.NAME NAME
, SGYT.DESCRIPTION DESCRIPTION
, SGYB.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SGYB.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, SGYB.RANKING RANKING
, SGYB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SGYB.ATTRIBUTE1 ATTRIBUTE1
, SGYB.ATTRIBUTE2 ATTRIBUTE2
, SGYB.ATTRIBUTE3 ATTRIBUTE3
, SGYB.ATTRIBUTE4 ATTRIBUTE4
, SGYB.ATTRIBUTE5 ATTRIBUTE5
, SGYB.ATTRIBUTE6 ATTRIBUTE6
, SGYB.ATTRIBUTE7 ATTRIBUTE7
, SGYB.ATTRIBUTE8 ATTRIBUTE8
, SGYB.ATTRIBUTE9 ATTRIBUTE9
, SGYB.ATTRIBUTE10 ATTRIBUTE10
, SGYB.ATTRIBUTE11 ATTRIBUTE11
, SGYB.ATTRIBUTE12 ATTRIBUTE12
, SGYB.ATTRIBUTE13 ATTRIBUTE13
, SGYB.ATTRIBUTE14 ATTRIBUTE14
, SGYB.ATTRIBUTE15 ATTRIBUTE15
, SGYB.ORG_ID ORG_ID
, SGYB.REQUEST_ID REQUEST_ID
, SGYB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SGYB.PROGRAM_ID PROGRAM_ID
, SGYB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SGYB.CREATED_BY CREATED_BY
, SGYB.CREATION_DATE CREATION_DATE
, SGYB.LAST_UPDATED_BY LAST_UPDATED_BY
, SGYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SGYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_STRATEGIES_B SGYB
, ZOKL_STRATEGIES_TL SGYT
WHERE SGYB.ID = SGYT.ID
AND SGYT.LANGUAGE = USERENV('LANG')