CST_CP_CLASS_TIMES
This table stores the total execution times in seconds for each sub-processor that are part of the Cost Processor on a particular instance of the job. The times are stored for each request referenced by the request identifier. The table also stores the date and total duration of each request.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: ARCHIVE
Primary Key
| Name | Columns |
|---|---|
|
CST_CP_CLASS_TIMES_PK |
REQ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQ_ID | NUMBER | 18 | Yes | Indicates the request ID of the job that created or last updated the row. | |
| RUN_CONTROL | VARCHAR2 | 30 | Yes | Identifies the Run Control used for cost processing. | |
| START_DATE | TIMESTAMP | Identifies the start date of the request. | |||
| END_DATE | TIMESTAMP | Identifies the end date of the request. | |||
| RUN_TIME_MINS | NUMBER | Indicates the total run time taken in minutes by the job i.e. END_DATE - START_DATE. | |||
| PO_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of PO interface sub-processor in seconds. | |||
| TRANSFER_ORDER_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of transfer order interface sub-processor in seconds. | |||
| TRADE_EVENT_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of trade event interface sub-processor in seconds. | |||
| AP_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of AP interface sub-processor in seconds. | |||
| CMR_RCV_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of CMR RCV pre-processor sub-processor in seconds. | |||
| CST_DOO_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of CST DOO interface sub-processor in seconds. | |||
| WORK_ORDER_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of work order pre-processor sub-processor in seconds. | |||
| OPERATION_TXN_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of operation transaction pre-processor sub-processor in seconds. | |||
| CST_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of cost pre-processor sub-processor in seconds. | |||
| RESOURCE_TXN_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of resource transaction pre-processor sub-processor in seconds. | |||
| TXN_COST_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of transaction cost interface sub-processor in seconds. | |||
| COMPUTE_AQISTN_COSTS | NUMBER | Indicates the cumulative execution time of all the queries of compute acquisition costs sub-processor in seconds. | |||
| COMPUTE_SERVICE_PO_AQISTN_COST | NUMBER | Indicates the cumulative execution time of all the queries of compute service PO acquisition costs sub-processor in seconds. | |||
| COMPUTE_TRADE_EVNT_AQISTN_COST | NUMBER | Indicates the cumulative execution time of all the queries of compute trade event acquisition costs sub-processor in seconds. | |||
| COMPUTE_CONS_AQISTN_COSTS | NUMBER | Indicates the cumulative execution time of all the queries of compute consigned acquisition costs sub-processor in seconds. | |||
| COMPUTE_BRAZIL_IMPORT_TAXES | NUMBER | Indicates the cumulative execution time of all the queries of compute brazil import taxes sub-processor in seconds. | |||
| CONS_ADV_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of consigned advice interface sub-processor in seconds. | |||
| INCOMING_COST_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of incoming cost pre-processor sub-processor in seconds. | |||
| PAC_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of PAC pre-processor sub-processor in seconds. | |||
| ACCTNG_ONLY_TXN_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of accounting only transaction pre-processor sub-processor in seconds. | |||
| RESOURCE_COST_PROC | NUMBER | Indicates the cumulative execution time of all the queries of resource cost processor sub-processor in seconds. | |||
| OPERATION_TXN_PROC | NUMBER | Indicates the cumulative execution time of all the queries of operation transaction processor sub-processor in seconds. | |||
| OSP_COST_PROC | NUMBER | Indicates the cumulative execution time of all the queries of OSP cost processor sub-processor in seconds. | |||
| QUANTITY_FLOW | NUMBER | Indicates the cumulative execution time of all the queries of quantity flow sub-processor in seconds. | |||
| WO_LAYERS | NUMBER | Indicates the cumulative execution time of all the queries of work order layers sub-processor in seconds. | |||
| SEQUENCE | NUMBER | Indicates the cumulative execution time of all the queries of sequence sub-processor in seconds. | |||
| RECEIPTS | NUMBER | Indicates the cumulative execution time of all the queries of receipts sub-processor in seconds. | |||
| DEPLETES | NUMBER | Indicates the cumulative execution time of all the queries of depletes sub-processor in seconds. | |||
| PAC_PROC | NUMBER | Indicates the cumulative execution time of all the queries of PAC processor sub-processor in seconds. | |||
| ADJUST_COST | NUMBER | Indicates the cumulative execution time of all the queries of adjust cost sub-processor in seconds. | |||
| RECEIPT_COST | NUMBER | Indicates the cumulative execution time of all the queries of receipt cost sub-processor in seconds. | |||
| DEPLETE_COST | NUMBER | Indicates the cumulative execution time of all the queries of deplete cost sub-processor in seconds. | |||
| WO_PENDING_TXN_VALIDATOR | NUMBER | Indicates the cumulative execution time of all the queries of work order pending transaction validator sub-processor in seconds. | |||
| WO_TXN_COST_CREATOR | NUMBER | Indicates the cumulative execution time of all the queries of work order cost creator sub-processor in seconds. | |||
| WO_CLOSE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of work order close processor sub-processor in seconds. | |||
| TRANSFER_COST_PRE_PROC | NUMBER | Indicates the cumulative execution time of all the queries of transfer cost pre-processor sub-processor in seconds. | |||
| TRANSFERS | NUMBER | Indicates the cumulative execution time of all the queries of transfers sub-processor in seconds. | |||
| MAIN_COST_PROC | NUMBER | Indicates the cumulative execution time of all the queries of main cost processor sub-processor in seconds. | |||
| SHIPMENT_REVENUE_MAP_INTERFACE | NUMBER | Indicates the cumulative execution time of all the queries of shipment revenue map interface sub-processor in seconds. | |||
| CST_COGS_RMA_RECOGNITION_TRANS | NUMBER | Indicates the cumulative execution time of all the queries of costing COGS RMA recognition transaction sub-processor in seconds. | |||
| CST_DIST_PROC | NUMBER | Indicates the cumulative execution time of all the queries of costing distribution processor sub-processor in seconds. | |||
| COST_PROC | NUMBER | Indicates the cumulative execution time of all the queries of cost processor sub-processor in seconds. | |||
| CST_REPORTS_PROC | NUMBER | Indicates the cumulative execution time of all the queries of costing reports processor sub-processor in seconds. | |||
| 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 |
|---|---|---|---|
| CST_CP_CLASS_TIMES_U1 | Unique | Default | REQ_ID |