Product: | OKC - Contracts Core |
---|---|
Description: | View on tables OKC_ACTIONS_B and OKC_ACTIONS_TL. |
Implementation/DBA Data: | APPS.OKC_ACTIONS_V |
SELECT ACNB.ROWID ROW_ID
, ACNB.ID ID
, ACNB.CORRELATION CORRELATION
, ACNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACNT.SFWT_FLAG SFWT_FLAG
, ACNT.NAME NAME
, ACNT.DESCRIPTION DESCRIPTION
, ACNT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, ACNT.COMMENTS COMMENTS
, ACNB.ENABLED_YN ENABLED_YN
, ACNB.FACTORY_ENABLED_YN FACTORY_ENABLED_YN
, ACNB.COUNTER_ACTION_YN COUNTER_ACTION_YN
, ACNB.ACN_TYPE ACN_TYPE
, ACNB.SYNC_ALLOWED_YN SYNC_ALLOWED_YN
, ACNB.APPLICATION_ID APPLICATION_ID
, ACNB.SEEDED_FLAG SEEDED_FLAG
, ACNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ACNB.ATTRIBUTE1 ATTRIBUTE1
, ACNB.ATTRIBUTE2 ATTRIBUTE2
, ACNB.ATTRIBUTE3 ATTRIBUTE3
, ACNB.ATTRIBUTE4 ATTRIBUTE4
, ACNB.ATTRIBUTE5 ATTRIBUTE5
, ACNB.ATTRIBUTE6 ATTRIBUTE6
, ACNB.ATTRIBUTE7 ATTRIBUTE7
, ACNB.ATTRIBUTE8 ATTRIBUTE8
, ACNB.ATTRIBUTE9 ATTRIBUTE9
, ACNB.ATTRIBUTE10 ATTRIBUTE10
, ACNB.ATTRIBUTE11 ATTRIBUTE11
, ACNB.ATTRIBUTE12 ATTRIBUTE12
, ACNB.ATTRIBUTE13 ATTRIBUTE13
, ACNB.ATTRIBUTE14 ATTRIBUTE14
, ACNB.ATTRIBUTE15 ATTRIBUTE15
, ACNB.CREATED_BY CREATED_BY
, ACNB.CREATION_DATE CREATION_DATE
, ACNB.LAST_UPDATED_BY LAST_UPDATED_BY
, ACNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_ACTIONS_B ACNB
, OKC_ACTIONS_TL ACNT
WHERE ACNB.ID =ACNT.ID
AND ACNT.LANGUAGE = USERENV('LANG')