DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKC_XPRT_QUESTIONS_VL

Object Details
Object Name: OKC_XPRT_QUESTIONS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_XPRT_QUESTIONS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Contract Expert questions view. This includes questions, constants and expert variables


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUESTION_ID NUMBER
Yes Sequence generated ID.
QUESTION_NAME VARCHAR2 (150) Yes Question name / Constant name
DESCRIPTION VARCHAR2 (2000)
Description of Variable / Question / Constant.
PROMPT VARCHAR2 (450)
Question prompt that will be displayed to user at runtime in the contract expert authoring process This is not applicable to constants.
QUESTION_TYPE VARCHAR2 (1) Yes Indicates the question type. FK to FND lookup OKC_XPRT_QUESTION_TYPE. Q: Question, C: Constant, X: Expert Variable.
QUESTION_INTENT VARCHAR2 (1) Yes Intent of Question / Constant / Expert variable. B: Buy, S: Sell.
TL_QUESTION_TYPE VARCHAR2 (1) Yes Indicates the question type. FK to FND lookup OKC_XPRT_QUESTION_TYPE. Q: Question, C: Constant, X: Expert Variable.
DISABLED_FLAG VARCHAR2 (1) Yes Enable / Disable flag.
QUESTION_DATATYPE VARCHAR2 (1) Yes Indicates response data type. FK to FND lookup OKC_XPRT_QUESTION_DATATYPE. B: Boolean, N: Numeric, L: List of values.
VALUE_SET_NAME VARCHAR2 (60)
Value set Id for question response. FK to FND value set.
DEFAULT_VALUE NUMBER

Value for Constants. This required for constants.
MINIMUM_VALUE NUMBER

Currently not supported. For future use.
MAXIMUM_VALUE NUMBER

Currently not supported. For future use.
QUESTION_SYNC_FLAG VARCHAR2 (1) Yes This will be used to indicate if a question needs to be synchronized with Oracle Configurator.
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
PROGRAM_ID NUMBER (15)
With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_APPLICATION_ID NUMBER (15)
With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
REQUEST_ID NUMBER (15)
Keeps track of the concurrent request during which this row was created or updated.
PROGRAM_UPDATE_DATE DATE

Stores the date on which the concurrent program created or updated the row.
CREATED_BY NUMBER (15) Yes Keeps track of which user created each row.
CREATION_DATE DATE
Yes Stores the date on which each row was created.
LAST_UPDATED_BY NUMBER (15) Yes Keeps track of who last updated each row.
LAST_UPDATE_DATE DATE
Yes Stores the date on which each row was last updated.
LAST_UPDATE_LOGIN NUMBER (15)
Provides access to information about the operating system login of the user who last updated each row.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.OKC_XPRT_QUESTIONS_VL;

Dependencies

[top of page]

APPS.OKC_XPRT_QUESTIONS_VL references the following:

SchemaAPPS
SynonymOKC_XPRT_QUESTIONS_B
SynonymOKC_XPRT_QUESTIONS_TL
APPS.OKC_XPRT_QUESTIONS_VL is referenced by following:

SchemaAPPS
Package BodyOKC_XPRT_QA_PVT - show dependent code
Package BodyOKC_XPRT_UTIL_PVT - show dependent code