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_QUESTION_ORDERS

Object Details

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

This entity stores the order of the questions to be displayed at runtime. This is an intersection entity between templates and questions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_XPRT_QUESTION_ORDERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUESTION_ORDER_ID
OKC_XPRT_QUESTION_ORDERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID QUESTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUESTION_ORDER_ID	NUMBER		Yes	Sequence generated ID.
TEMPLATE_ID	NUMBER		Yes	Template Id. FK to OKC_TERMS_TEMPLATES_ALL.
QUESTION_ID	NUMBER		Yes	Question Id. FK to OKC_XPRT_QUESTIONS_B.
SEQUENCE_NUM	NUMBER			The order in which questions on the template would be displayed when the user invokes contract expert during contract authoring
MANDATORY_FLAG	VARCHAR2	(1)		To indicate if a question need to be mandatory on run time UI.
QUESTION_RULE_STATUS	VARCHAR2	(30)		Indicate the status of the rule in which the question is used. If the question is used in multiple rules, the highest status will shown. The status priority is: ACTIVE, PENDINGPUB: DRAFT: for any other rule status. FK to FND lookup OKC_XPRT_RULE_STATUSES.
RUNTIME_AVAILABLE_FLAG	VARCHAR2	(1)		Flag to indicate whether the question is available at runtime. This flag will be null or N when record is created. Updated to Y when a template is successfully published in Oracle Configurator. Questions Order read only regions will render the 'Shown in Runtime' from this field
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 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_ORDER_ID
,      TEMPLATE_ID
,      QUESTION_ID
,      SEQUENCE_NUM
,      MANDATORY_FLAG
,      QUESTION_RULE_STATUS
,      RUNTIME_AVAILABLE_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_XPRT_QUESTION_ORDERS;

Dependencies

[top of page]

OKC.OKC_XPRT_QUESTION_ORDERS does not reference any database object

OKC.OKC_XPRT_QUESTION_ORDERS is referenced by following:

APPS: OKC_XPRT_QUESTION_ORDERS