CML_LCP_PROCESS_PARAMS
This table contains the user selection of processes to be run and also the individual process details like Last Run ID and Status. This table is the child table to CML_LCP_PROCESS_B
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_LCP_PROCESS_PARAMS_PK |
LCP_PROCESS_ID, PROCESS_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LCP_PROCESS_ID | NUMBER | 18 | Yes | Identifies the Run Control used for Landed Cost Processing. | |
| PROCESS_CODE | VARCHAR2 | 30 | Yes | Identifies the process code whose value is one of the five process lookup codes. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PROCESS_FLAG | VARCHAR2 | 1 | Yes | Indicates if the process defined by process_code should be executed as part of the Landed Cost Process run. N-No. Y-Yes | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the individual process. The possible values are Not Started, Pending, Running and Completed | |
| LAST_PROCESS_ID | NUMBER | 18 | Identifies the Last Process ID of the process defined by process_code for the Run Control. | ||
| USER_COMMENT | VARCHAR2 | 240 | Optional user comment or description. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_LCP_PROCESS_PARAMS_N1 | Non Unique | Default | LAST_UPDATE_DATE |
| CML_LCP_PROCESS_PARAMS_U1 | Unique | Default | LCP_PROCESS_ID, PROCESS_CODE |