Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_ASSENTS_LOOKUPS_V |
SELECT AST.ROW_ID
, AST.STS_CODE
, AST.OPN_CODE
, AST.OBJECT_VERSION_NUMBER
, AST.ALLOWED_YN
, AST.ATTRIBUTE_CATEGORY
, AST.ATTRIBUTE1
, AST.ATTRIBUTE2
, AST.ATTRIBUTE3
, AST.ATTRIBUTE4
, AST.ATTRIBUTE5
, AST.ATTRIBUTE6
, AST.ATTRIBUTE7
, AST.ATTRIBUTE8
, AST.ATTRIBUTE9
, AST.ATTRIBUTE10
, AST.ATTRIBUTE11
, AST.ATTRIBUTE12
, AST.ATTRIBUTE13
, AST.ATTRIBUTE14
, AST.ATTRIBUTE15
, AST.CREATED_BY
, AST.CREATION_DATE
, AST.LAST_UPDATED_BY
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATE_LOGIN
, FND.LOOKUP_CODE || ' - ' || FND.MEANING OPN_NAME
FROM OKC_ASSENTS_V AST
, FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'OKC_OPERATION'
AND AST.OPN_CODE = FND.LOOKUP_CODE