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 |