Product: | OKE - Project Contracts |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKE_TERMS_V |
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