[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_ACTIONS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ACTB.ROWID ROW_ID
, ACTB.ID ID
, ACTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACTT.SFWT_FLAG SFWT_FLAG
, ACTB.ITA_ID ITA_ID
, ACTB.ACT_ID ACT_ID
, ACTT.NAME NAME
, ACTT.DESCRIPTION DESCRIPTION
, ACTB.MANUAL_FLAG MANUAL_FLAG
, ACTB.MANDATORY_FLAG MANDATORY_FLAG
, ACTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ACTB.ATTRIBUTE1 ATTRIBUTE1
, ACTB.ATTRIBUTE2 ATTRIBUTE2
, ACTB.ATTRIBUTE3 ATTRIBUTE3
, ACTB.ATTRIBUTE4 ATTRIBUTE4
, ACTB.ATTRIBUTE5 ATTRIBUTE5
, ACTB.ATTRIBUTE6 ATTRIBUTE6
, ACTB.ATTRIBUTE7 ATTRIBUTE7
, ACTB.ATTRIBUTE8 ATTRIBUTE8
, ACTB.ATTRIBUTE9 ATTRIBUTE9
, ACTB.ATTRIBUTE10 ATTRIBUTE10
, ACTB.ATTRIBUTE11 ATTRIBUTE11
, ACTB.ATTRIBUTE12 ATTRIBUTE12
, ACTB.ATTRIBUTE13 ATTRIBUTE13
, ACTB.ATTRIBUTE14 ATTRIBUTE14
, ACTB.ATTRIBUTE15 ATTRIBUTE15
, ACTB.ORG_ID ORG_ID
, ACTB.REQUEST_ID REQUEST_ID
, ACTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ACTB.PROGRAM_ID PROGRAM_ID
, ACTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ACTB.CREATED_BY CREATED_BY
, ACTB.CREATION_DATE CREATION_DATE
, ACTB.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_ACTIONS_B ACTB
, ZOKL_ACTIONS_TL ACTT
WHERE ACTB.ID = ACTT.ID
AND ACTT.LANGUAGE = USERENV('LANG')