VIEW: APPS.OKC_ASSENTS_LOOKUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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