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: | APPS.XDP_WI_PARAMETERS_DISP_V |
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'