DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKC_PROCESS_DEF_PARAMETERS_V

Object Details
Object Name: OKC_PROCESS_DEF_PARAMETERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_PROCESS_DEF_PARAMETERS_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.OKC_PROCESS_DEF_PARAMETERS_V references the following:

SchemaAPPS
SynonymOKC_PROCESS_DEF_PARMS_B
SynonymOKC_PROCESS_DEF_PARMS_TL
APPS.OKC_PROCESS_DEF_PARAMETERS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CHANGE_CONTRACT_PVT - show dependent code
Package BodyOKC_CONDITION_EVAL_PVT - show dependent code
Package BodyOKC_CONTRACT_APPROVAL_PVT - show dependent code
Package BodyOKC_FEP_PVT - show dependent code
Package BodyOKC_KSQ_PVT - show dependent code
Package BodyOKC_OAT_PVT - show dependent code
PL/SQL PackageOKC_OUTCOME_INIT_PVT - show dependent code
Package BodyOKC_PDP_PVT - show dependent code
PL/SQL PackageOKC_PDP_PVT - show dependent code
Package BodyOKC_PROCESS_PVT - show dependent code
Package BodyOKC_QA_CHECK_PVT - show dependent code
Package BodyOKE_CONTRACT_APPROVAL_PVT - show dependent code