CollaborationOrderForecastRequestsdetails
CollaborationOrderForecastRequestsdetails
Columns
| Name | Type | Description |
| CollaborationOrderForecastRequestsCollaborationOrderForecastRequestId [KEY] | Long | Value that uniquely identifies the request. |
| CollaborationOrderForecastRequestId | String | Value that uniquely identifies the request for the collaboration order forecast. |
| PublisherOrderTypeCode | String | Abbreviation that identifies the order type of the reference quantity. A list of accepted values is defined in the lookup type ORA_VCS_COLLAB_ORDER_TYPES. 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. |
| Quantity | Double | Quantity of the publisher order type. |
| ReferenceHeaderId | Long | Value that uniquely identifies the reference header for a measure that originates in the Oracle Cloud. A measure that doesn't originate in the Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
| ReferenceLineId | Long | Value that uniquely identifies the reference line for a measure that originates outside of Oracle Cloud. A measure that doesn't originate in Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
| ReferenceLineLocationId | Long | Value that uniquely identifies the reference line location for a measure that originates outside of Oracle Cloud. A measure that doesn't originate in Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
| ReferenceHeaderNumber | String | Reference header number for a measure that originates in the Oracle Cloud. A measure that doesn't originate in the Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
| ReferenceLineNumber | String | Number that identifies the reference line for a measure that originates outside of Oracle Cloud. A measure that doesn't originate in Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
| ReferenceLineLocationNumber | String | Number that identifies the reference line location for a measure that originates outside of Oracle Cloud. A measure that doesn't originate in Oracle Cloud must use the Reference Header Number column. You must use a reference header, line, and location for each read-only reference measure. A purchase order is an example of a reference measure. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |