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]

VIEW: APPS.XDP_WI_PARAMETERS_DISP_V

Object Details

Object Name:	XDP_WI_PARAMETERS_DISP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XDP.XDP_WI_PARAMETERS_DISP_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
WORKITEM_ID	NUMBER		Yes	Work Item identifier which the Parameter is mapped to
PARAMETER_NAME	VARCHAR2	(40)	Yes	Internal of the Parameter mapped to the Work Item
PARAMETER_DISPLAY_NAME	VARCHAR2	(80)	Yes	Display Name of the Parameter mapped to the Work Item
REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag to represent if the Parameter is mandatory or optional for the Work Item
VALUE_LOOKUP_SQL	VARCHAR2	(1996)		SQL query used to provide a LOV for the Parameter
VALIDATION_PROCEDURE	VARCHAR2	(80)		Validation Procedure for the Parameter
EVALUATION_MODE	VARCHAR2	(20)		Internal code representing the evalutaion mode of the Parameter
EVALUATION_PROCEDURE	VARCHAR2	(80)		Evalidation Procedure for the Parameter
DEFAULT_VALUE	VARCHAR2	(4000)		Default value for the Parameter
LOG_IN_AUDIT_TRAIL_FLAG	VARCHAR2	(1)		Flag used to indicate if the Parameter is to have an audit trail
EVALUATION_SEQ	NUMBER			Evaluation Sequence for the Parameter mapped to the Work Item
DISPLAY_SEQ	NUMBER			Sequence in which the Parameter is to be displayed in the SFM UI
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT ROW_ID
,      WORKITEM_ID
,      PARAMETER_NAME
,      PARAMETER_DISPLAY_NAME
,      REQUIRED_FLAG
,      VALUE_LOOKUP_SQL
,      VALIDATION_PROCEDURE
,      EVALUATION_MODE
,      EVALUATION_PROCEDURE
,      DEFAULT_VALUE
,      LOG_IN_AUDIT_TRAIL_FLAG
,      EVALUATION_SEQ
,      DISPLAY_SEQ
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.XDP_WI_PARAMETERS_DISP_V;

Dependencies

[top of page]

APPS.XDP_WI_PARAMETERS_DISP_V references the following:

APPS: CSI_LOOKUPS; XDP_WI_PARAMETERS

APPS.XDP_WI_PARAMETERS_DISP_V is not referenced by any database object