CST_WO_OPS_TO_VALIDATE_GT

This transaction temporary table is used to load the distinct set of work order and operations for which pending transactions are to be evaluated.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	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		Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18	Yes	Surrogate ID identifying the work order operation 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.
PENDING_TXNS_FLAG	VARCHAR2	1			Indicates if there are any transactions pending to be processed for this operation.
WORK_METHOD_CODE	VARCHAR2	30			Indicates the work method of the work order.
WO_CLOSED_FLAG	VARCHAR2	1			Indicates if the work order is closed. Valid values are Y, N and Null.
WORK_ORDER_TYPE	VARCHAR2	30			Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. The value for which comes from a lookup_type = 'WIE_WO_TYPE'. This lookup is system defined and not alterable by the user.
INVENTORY_ITEM_ID	NUMBER		18		This refers to the primary product that needs to be manufactured and can be any active item that has the "Build in WIP" flag checked at the Item organization (plant) level.
SERVER_TZ_CUTOFF_DATE	TIMESTAMP				Indicates the server time zones date and time used to filter the transactions.
PAC_BOOK_FLAG	VARCHAR2	5			Indicates if it is a periodic average cost book. Valid values are N, Y and NULL.