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.

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

TABLE: OKC.OKC_XPRT_QUESTIONS_B

Object Details

Object Name:	OKC_XPRT_QUESTIONS_B
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_XPRT_QUESTIONS_B
Subobject Name:
Status:	VALID

This entity stores the user questions, constants and expert variables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_XPRT_QUESTIONS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUESTION_ID
OKC_XPRT_QUESTIONS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUESTION_TYPE
OKC_XPRT_QUESTIONS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALUE_SET_NAME
OKC_XPRT_QUESTIONS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUESTION_DATATYPE

Columns

Name	Datatype	Length	Mandatory	Comments
QUESTION_ID	NUMBER		Yes	This is the primary column for the questions and constants table and is sequence generated.
QUESTION_TYPE	VARCHAR2	(1)	Yes	This indicates the question type. FK to FND lookup OKC_XPRT_QUESTION_TYPE. Possible values are Q and C. Q: Question, C: Constant.
QUESTION_INTENT	VARCHAR2	(1)	Yes	Intent of Question or Constant. B: Buy, S: Sell.
DISABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if the question or constant is disabled
QUESTION_DATATYPE	VARCHAR2	(1)	Yes	Indicates response datatype. FK to FND lookup OKC_XPRT_QUESTION_DATATYPE. B: Boolean, N: Numeric, L: List of values.
VALUE_SET_NAME	VARCHAR2	(60)		The value set corresponding to the question with response type of List of Values. FK to FND value set.
DEFAULT_VALUE	NUMBER			Value for Constants. This is mandatory for defining constants.
MINIMUM_VALUE	NUMBER			Not currently used. For a future release
MAXIMUM_VALUE	NUMBER			Not currently used. For a future release
QUESTION_SYNC_FLAG	VARCHAR2	(1)	Yes	This will be used to indicate if a question needs to be synchronized with Oracle Confiugrator
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.
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 which user 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.
PROGRAM_ID	NUMBER	(15)		With PROGRAM_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_APPLICATION_ID	NUMBER	(15)		With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE	DATE			Stores the date on which the concurrent program created or updated the row.

Query Text

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


SELECT QUESTION_ID
,      QUESTION_TYPE
,      QUESTION_INTENT
,      DISABLED_FLAG
,      QUESTION_DATATYPE
,      VALUE_SET_NAME
,      DEFAULT_VALUE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      QUESTION_SYNC_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM OKC.OKC_XPRT_QUESTIONS_B;

Dependencies

[top of page]

OKC.OKC_XPRT_QUESTIONS_B does not reference any database object

OKC.OKC_XPRT_QUESTIONS_B is referenced by following:

APPS: OKC_XPRT_QUESTIONS_B