VIEW: APPS.OKE_TERMS_V

Source

View Text - Preformatted

SELECT B.ROWID , B.TERM_CODE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , T.TERM_NAME , T.DESCRIPTION , B.TERM_TYPE_CODE , TT.TERM_TYPE_NAME , B.USER_DEFINED_FLAG , B.VIEW_APPLICATION_ID , A.APPLICATION_SHORT_NAME , A.APPLICATION_NAME , B.LOOKUP_TYPE , LT.DESCRIPTION FROM OKE_TERMS_B B , OKE_TERMS_TL T , OKE_TERM_TYPES_V TT , FND_APPLICATION_VL A , FND_LOOKUP_TYPES_VL LT WHERE T.TERM_CODE = B.TERM_CODE AND T.LANGUAGE = USERENV('LANG') AND TT.TERM_TYPE_CODE (+) = B.TERM_TYPE_CODE AND A.APPLICATION_ID (+) = B.VIEW_APPLICATION_ID AND LT.LOOKUP_TYPE (+) = B.LOOKUP_TYPE AND LT.VIEW_APPLICATION_ID (+) = B.VIEW_APPLICATION_ID

View Text - HTML Formatted

SELECT B.ROWID
, B.TERM_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.TERM_NAME
, T.DESCRIPTION
, B.TERM_TYPE_CODE
, TT.TERM_TYPE_NAME
, B.USER_DEFINED_FLAG
, B.VIEW_APPLICATION_ID
, A.APPLICATION_SHORT_NAME
, A.APPLICATION_NAME
, B.LOOKUP_TYPE
, LT.DESCRIPTION
FROM OKE_TERMS_B B
, OKE_TERMS_TL T
, OKE_TERM_TYPES_V TT
, FND_APPLICATION_VL A
, FND_LOOKUP_TYPES_VL LT
WHERE T.TERM_CODE = B.TERM_CODE
AND T.LANGUAGE = USERENV('LANG')
AND TT.TERM_TYPE_CODE (+) = B.TERM_TYPE_CODE
AND A.APPLICATION_ID (+) = B.VIEW_APPLICATION_ID
AND LT.LOOKUP_TYPE (+) = B.LOOKUP_TYPE
AND LT.VIEW_APPLICATION_ID (+) = B.VIEW_APPLICATION_ID