[Home] [Help] [Dependency Information]
Object Name: | OKC_PROCESS_DEF_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_PROCESS_DEF_PARAMETERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Provides all the parameters required by workflow or sub program for any Processes registered with the application.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
ID | NUMBER | Yes | Unique Identifier for a Process Definition. Also the Primary key for the underlying base table, OKC_PROCESS_DEF_PARAMETERS_B | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not used |
PDF_ID | NUMBER | Yes | Unique identifier of the Process Definition to which this Parameter belongs. Refers to the ID in OKC_PROCESS_DEFS_B. | |
NAME | VARCHAR2 | (150) | Process definition parameter name (required by workflow). | |
USER_NAME | VARCHAR2 | (150) | Yes | Process definition parameter name (required by workflow). |
DATA_TYPE | VARCHAR2 | (90) | Yes | Parameter Data type. |
DEFAULT_VALUE | VARCHAR2 | (150) | Default Value | |
REQUIRED_YN | VARCHAR2 | (3) | Yes | Indicates if the parameter is required. Valid values Y or N. |
DESCRIPTION | VARCHAR2 | (1995) | Parameter description. | |
APPLICATION_ID | NUMBER | Application Identifier | ||
SEEDED_FLAG | VARCHAR2 | (3) | Indicates whether a record is seeded data | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | 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. | |
JTOT_OBJECT_CODE | VARCHAR2 | (30) | Refers to object_code in JTF_OBJECTS_B. This indicates the source from which the value for the process definition parameter is obtained. Used in conjunction with column_name and description column to build a list of values to provide database values for the parameter . | |
NAME_COLUMN | VARCHAR2 | (30) | Column used to build list of values based on source object column JTOT_OBJECT_CODE | |
DESCRIPTION_COLUMN | VARCHAR2 | (30) | Column used in list of values to help identify value of column column_name. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, PDF_ID
, NAME
, USER_NAME
, DATA_TYPE
, DEFAULT_VALUE
, REQUIRED_YN
, DESCRIPTION
, APPLICATION_ID
, SEEDED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, JTOT_OBJECT_CODE
, NAME_COLUMN
, DESCRIPTION_COLUMN
FROM APPS.OKC_PROCESS_DEF_PARAMETERS_V;
|
|
|