Product: | OKC - Contracts Core |
---|---|
Description: | View based on tables OKC_ACTION_ATTRIBUTES_B and OKC_ACTION_ATTRIBUTES_TL |
Implementation/DBA Data: | APPS.OKC_ACTION_ATTRIBUTES_V |
SELECT AAEB.ROWID ROW_ID
, AAEB.ID ID
, AAEB.AAL_ID AAL_ID
, AAEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AAET.SFWT_FLAG SFWT_FLAG
, AAEB.ACN_ID ACN_ID
, AAEB.ELEMENT_NAME ELEMENT_NAME
, AAET.NAME NAME
, AAET.DESCRIPTION DESCRIPTION
, AAEB.DATA_TYPE DATA_TYPE
, AAEB.LIST_YN LIST_YN
, AAEB.VISIBLE_YN VISIBLE_YN
, AAEB.DATE_OF_INTEREST_YN DATE_OF_INTEREST_YN
, AAEB.FORMAT_MASK FORMAT_MASK
, AAEB.MINIMUM_VALUE MINIMUM_VALUE
, AAEB.MAXIMUM_VALUE MAXIMUM_VALUE
, AAEB.APPLICATION_ID APPLICATION_ID
, AAEB.SEEDED_FLAG SEEDED_FLAG
, AAEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AAEB.ATTRIBUTE1 ATTRIBUTE1
, AAEB.ATTRIBUTE2 ATTRIBUTE2
, AAEB.ATTRIBUTE3 ATTRIBUTE3
, AAEB.ATTRIBUTE4 ATTRIBUTE4
, AAEB.ATTRIBUTE5 ATTRIBUTE5
, AAEB.ATTRIBUTE6 ATTRIBUTE6
, AAEB.ATTRIBUTE7 ATTRIBUTE7
, AAEB.ATTRIBUTE8 ATTRIBUTE8
, AAEB.ATTRIBUTE9 ATTRIBUTE9
, AAEB.ATTRIBUTE10 ATTRIBUTE10
, AAEB.ATTRIBUTE11 ATTRIBUTE11
, AAEB.ATTRIBUTE12 ATTRIBUTE12
, AAEB.ATTRIBUTE13 ATTRIBUTE13
, AAEB.ATTRIBUTE14 ATTRIBUTE14
, AAEB.ATTRIBUTE15 ATTRIBUTE15
, AAEB.CREATED_BY CREATED_BY
, AAEB.CREATION_DATE CREATION_DATE
, AAEB.LAST_UPDATED_BY LAST_UPDATED_BY
, AAEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AAEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AAEB.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, AAEB.NAME_COLUMN NAME_COLUMN
, AAEB.DESCRIPTION_COLUMN DESCRIPTION_COLUMN
, AAEB.SOURCE_DOC_NUMBER_YN SOURCE_DOC_NUMBER_YN
FROM OKC_ACTION_ATTRIBUTES_B AAEB
, OKC_ACTION_ATTRIBUTES_TL AAET
WHERE AAEB.ID =AAET.ID
AND AAET.LANGUAGE = USERENV('LANG')