FND Design Data [Home] [Help]

View: XDP_WI_PARAMETERS_DISP_V

Product: XDP - Provisioning
Description: The view XDP_WI_PARAMETERS_DISP_V holds all the Workitem parameters and associated properties for a given Work Item. The value_lookup_sql column is for internal use. The column validation_procedure is for future use.
Implementation/DBA Data: ViewAPPS.XDP_WI_PARAMETERS_DISP_V
View Text

SELECT B.ROWID ROW_ID
, B.WORKITEM_ID
, B.PARAMETER_NAME
, F.MEANING
, B.REQUIRED_FLAG
, B.VALUE_LOOKUP_SQL
, B.VALIDATION_PROCEDURE
, B.EVALUATION_MODE
, B.EVALUATION_PROCEDURE
, B.DEFAULT_VALUE
, B.LOG_IN_AUDIT_TRAIL_FLAG
, B.EVALUATION_SEQ
, B.DISPLAY_SEQ
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM XDP_WI_PARAMETERS B
, CSI_LOOKUPS F
WHERE B.PARAMETER_NAME = F.LOOKUP_CODE
AND F.LOOKUP_TYPE = 'CSI_EXTEND_ATTRIB_POOL'

Columns

Name
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