CML_LCP_REQUESTS
Contains the detail level parameters used by the individual processors and is created and maintained by the Landed Cost Process main program. This table is used apart from ESS request data and is used internally by the landed cost process to drive the background processing.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_LCP_REQUESTS_PK |
REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| LCP_PROCESS_ID | NUMBER | 18 | Yes | Identifies the Run Control used for Landed Cost Processing. | |
| PREPARE_MATERIAL_PO_FLAG | VARCHAR2 | 1 | Yes | Indicates if Prepare material Purchase orders process was run. (N-No. Y-Yes) | |
| PREPARE_INVOICE_FLAG | VARCHAR2 | 1 | Yes | Indicates if Prepare Invoice Data process was run. (N-No. Y-Yes) | |
| ASSOC_INVOICES_TO_FLAG | VARCHAR2 | 1 | Yes | Indicates if Associate Invoices to Trade Operations process was run. (N-No. Y-Yes) | |
| ALLOC_CHARGES_FLAG | VARCHAR2 | 1 | Yes | Indicates if Allocate Estimated charges process was run. (N-No. Y-Yes) | |
| START_DATE | TIMESTAMP | Identifies the start date of the request | |||
| END_DATE | TIMESTAMP | Identifies the end date of the request. | |||
| RUN_STATUS | VARCHAR2 | 64 | This field will store the overall status of the request. | ||
| PMPOD_RUN_STATUS | VARCHAR2 | 1000 | Identifies the Landed Cost Process run status or the diagnostic exception information for the sub-process 'Prepare Material Purchase Order Data'. | ||
| PID_RUN_STATUS | VARCHAR2 | 1000 | Identifies the Landed Cost Process run status or the diagnostic exception information for the sub-process 'Prepare Invoice Data'. | ||
| AC_RUN_STATUS | VARCHAR2 | 1000 | Identifies the Landed Cost Process run status or the diagnostic exception information for the sub-process 'Allocate Charges'. | ||
| AI_RUN_STATUS | VARCHAR2 | 1000 | Identifies the Landed Cost Process run status or the diagnostic exception information for the sub-process 'Associate Invoices to Trade Operation Charges'. | ||
| 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. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_LCP_REQUESTS_U1 | Unique | Default | REQUEST_ID |