eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKC_XPRT_QUESTIONS_VL

Product:	OKC - Contracts Core
Description:	Contract Expert questions view
Implementation/DBA Data:	APPS.OKC_XPRT_QUESTIONS_VL

View Text

SELECT B.QUESTION_ID
, T.QUESTION_NAME
, T.DESCRIPTION
, T.PROMPT
, B.QUESTION_TYPE
, B.QUESTION_INTENT
, T.QUESTION_TYPE
, B.DISABLED_FLAG
, B.QUESTION_DATATYPE
, B.VALUE_SET_NAME
, B.DEFAULT_VALUE
, B.MINIMUM_VALUE
, B.MAXIMUM_VALUE
, B.QUESTION_SYNC_FLAG
, B.OBJECT_VERSION_NUMBER
, B.PROGRAM_ID
, B.PROGRAM_APPLICATION_ID
, B.REQUEST_ID
, B.PROGRAM_UPDATE_DATE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM OKC_XPRT_QUESTIONS_B B
, OKC_XPRT_QUESTIONS_TL T
WHERE B.QUESTION_ID = T.QUESTION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
QUESTION_ID
QUESTION_NAME
DESCRIPTION
PROMPT
QUESTION_TYPE
QUESTION_INTENT
TL_QUESTION_TYPE
DISABLED_FLAG
QUESTION_DATATYPE
VALUE_SET_NAME
DEFAULT_VALUE
MINIMUM_VALUE
MAXIMUM_VALUE
QUESTION_SYNC_FLAG
OBJECT_VERSION_NUMBER
PROGRAM_ID
PROGRAM_APPLICATION_ID
REQUEST_ID
PROGRAM_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN