CollaborationOrderForecastsexceptionQuantities

Columns


Name	Type	Description
CollaborationOrderForecastsCollaborationOrderForecastId [KEY]	Long	Value that uniquely identifies the order forecast.
CollaborationOrderForecastId	Long	Value that uniquely identifies the collaboration order forecast.
ExceptionId [KEY]	Long	Value that uniquely identifies the collaboration order forecast exception.
BucketId [KEY]	Long	Value that uniquely identifies the time bucket.
ExceptionTypeCode	String	Abbreviation that identifies the exception type. Values include COMMIT_MISMATCH or FORECAST_DEVIATION.
BucketAggregationCode	String	Abbreviation that identifies the bucket aggregation type for the exception quantity. A list of accepted values is defined in the lookup type ORA_VCS_BUCKET_AGGR_LEVEL. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
BucketStartDate	Date	Date when the time bucket starts.
BucketEndDate	Date	Date when the time bucket ends.
ExceptionFactor	Double	Value that identifies the amount of change based on the exception type.
PrimaryExceptionVariable	Double	Value that's used in the calculation of the exception factor.
SecondaryExceptionVariable	Double	Value that's used in the calculation of the exception factor.
MaximumCommitVersion	Int	Version of the maximum commit when the exception occurred for the aggregation type.
MaximumForecastVersion	Int	Version of the maximum forecast when the exception occurred for the aggregation type.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。