CST_WO_OPS_VAL_ERRORS_GT

This session temporary table is used in cost processing to hold any work order validation failures that cannot be recovered during a job. This avoids running these validations again.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: DEFAULT

Columns

Name	Datatype	Precision	Not-null	Comments
COST_ORG_ID	NUMBER	18	Yes	Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID	NUMBER	18	Yes	Surrogate ID identifying the cost book associated to the cost organization.
CST_WORK_ORDER_ID	NUMBER	18	Yes	Surrogate ID identifying the work order in costing.
OPERATION_SEQ_NUMBER	NUMBER		Yes	Indicates a number that identifies the operation sequence within this work order.
CUTOFF_DATE	TIMESTAMP		Yes	Indicates the date and time used to filter the transactions.
VALIDATION_LEVEL	NUMBER	9	Yes	Indicates the validation level at which this validation had failed e.g. Scrap or Work Order Close.

Indexes

Index	Uniqueness	Columns
CST_WO_OPS_VAL_ERRORS_GT_U1	Unique	COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, OPERATION_SEQ_NUMBER, CUTOFF_DATE, VALIDATION_LEVEL