Supply Lines
The Supply Lines Extract view object extracts details from the supply line.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyLinesExtractPVO
Primary Keys : DosSupplyLinesPEOLineId
Initial Extract Date : DosSupplyLinesPEOCreationDate
Incremental Extract Date : DosSupplyLinesPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosSupplyLinesPEOAttributeCategory | Category for the descriptive flexfield that stores details about the supply line. |
| DosSupplyLinesPEOAttributeChar1 | Descriptive flexfield 1 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar10 | Descriptive flexfield 10 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar11 | Descriptive flexfield 11 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar12 | Descriptive flexfield 12 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar13 | Descriptive flexfield 13 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar14 | Descriptive flexfield 14 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar15 | Descriptive flexfield 15 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar16 | Descriptive flexfield 16 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar17 | Descriptive flexfield 17 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar18 | Descriptive flexfield 18 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar19 | Descriptive flexfield 19 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar2 | Descriptive flexfield 2 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar20 | Descriptive flexfield 20 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar3 | Descriptive flexfield 3 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar4 | Descriptive flexfield 4 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar5 | Descriptive flexfield 5 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar6 | Descriptive flexfield 6 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar7 | Descriptive flexfield 7 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar8 | Descriptive flexfield 8 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeChar9 | Descriptive flexfield 9 for the supply line. The data type of the flexfield is character. |
| DosSupplyLinesPEOAttributeDate1 | Descriptive flexfield 1 for the supply line. The data type of the flexfield is date. |
| DosSupplyLinesPEOAttributeDate2 | Descriptive flexfield 2 for the supply line. The data type of the flexfield is date. |
| DosSupplyLinesPEOAttributeDate3 | Descriptive flexfield 3 for the supply line. The data type of the flexfield is date. |
| DosSupplyLinesPEOAttributeDate4 | Descriptive flexfield 4 for the supply line. The data type of the flexfield is date. |
| DosSupplyLinesPEOAttributeDate5 | Descriptive flexfield 5 for the supply line. The data type of the flexfield is date. |
| DosSupplyLinesPEOAttributeNumber1 | Descriptive flexfield 1 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber10 | Descriptive flexfield 10 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber2 | Descriptive flexfield 2 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber3 | Descriptive flexfield 3 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber4 | Descriptive flexfield 4 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber5 | Descriptive flexfield 5 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber6 | Descriptive flexfield 6 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber7 | Descriptive flexfield 7 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber8 | Descriptive flexfield 8 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeNumber9 | Descriptive flexfield 9 for the supply line. The data type of the flexfield is number. |
| DosSupplyLinesPEOAttributeTimestamp1 | Descriptive flexfield 1 for the supply line. The data type of the flexfield is time stamp. |
| DosSupplyLinesPEOAttributeTimestamp2 | Descriptive flexfield 2 for the supply line. The data type of the flexfield is time stamp. |
| DosSupplyLinesPEOAttributeTimestamp3 | Descriptive flexfield 3 for the supply line. The data type of the flexfield is time stamp. |
| DosSupplyLinesPEOAttributeTimestamp4 | Descriptive flexfield 4 for the supply line. The data type of the flexfield is time stamp. |
| DosSupplyLinesPEOAttributeTimestamp5 | Descriptive flexfield 5 for the supply line. The data type of the flexfield is time stamp. |
| DosSupplyLinesPEOBackToBackFlag | This attribute contains Y or N. Y means the supply request or supply order occurs in a back-to-back flow. N means it doesn't. No value means N. N is the default value. |
| DosSupplyLinesPEOChangePendingFlag | This attribute contains Y or N. Y means that a change is pending for at least one child supply line. If this attribute contains Y because of a change that occurs on a supply line, then it must contain Y for all the child supply lines. N means no child lines are pending change. No value means N. N is the default value. A child line occurs when Supply Orchestration splits a supply line. |
| DosSupplyLinesPEOConfigItemFlag | This attribute contains 1 or 0. 1 means the item on the supply line is a configured item. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyLinesPEOContractManufacturingFlag | This attribute contains 1 or 0. 1 means the item on the supply line is a contract manufacturing item. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyLinesPEOCreatedBy | Name of the user who created the supply line. |
| DosSupplyLinesPEOCreationDate | Date and time when the user created the supply line. |
| DosSupplyLinesPEOCustomerContactId | Value that uniquely identifies the customer contact on the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEOCustomerId | Value that uniquely identifies the customer on the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEOCustomerOrderLineNumber | Number that identifies the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEOCustomerOrderNumber | Number that identifies the sales order that contains the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEOCustomerOrderScheduleNumber | Number that identifies the schedule on the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEOCustomerOrderSourceSystem | Name of the source system that captures the source order. |
| DosSupplyLinesPEOCustomerShipToId | Value that uniquely identifies the ship-to customer on the fulfillment line in Order Management. The supply line fulfills demand for the fulfillment line. |
| DosSupplyLinesPEODestinationBuId | Value that uniquely identifies the destination business unit in the source system. |
| DosSupplyLinesPEODestinationOrganizationCode | Abbreviation that identifies the inventory organization where Supply Orchestration creates supply for the requested item. You must set up this value in an Oracle Cloud application. |
| DosSupplyLinesPEODestinationOrganizationId | Value that uniquely identifies the inventory organization where Supply Orchestration creates supply for the requested item. You must set up this value in an Oracle Cloud application. |
| DosSupplyLinesPEOExecSystemItemNumber | Number that identifies the item in the execution system. A fulfillment task uses this value to communicate with a system that resides outside of Oracle Fusion. |
| DosSupplyLinesPEOHeaderId | Value that uniquely identifies the supply header for the supply request. Supply Orchestration creates the value for this attribute when it receives the supply request. |
| DosSupplyLinesPEOInventoryItemId | Value that uniquely identifies the inventory item that Supply Orchestration uses to fulfill the item on the supply line. |
| DosSupplyLinesPEOItemDescription | Description of the item on the supply line. |
| DosSupplyLinesPEOItemRevision | Number that identifies the revision of the item on the supply line. |
| DosSupplyLinesPEOItemType | Type of item on the supply line. The type specifies whether the item is a standard item, assemble-to-order, pick-to-order, outsourced, or you fulfill it in a back-to-back flow. This attribute can specify more than one type for the same item. |
| DosSupplyLinesPEOLastUpdateDate | Date and time when the user most recently updated the supply line. |
| DosSupplyLinesPEOLastUpdateLogin | Login that the user used when updating the supply line. |
| DosSupplyLinesPEOLastUpdatedBy | User who most recently updated the supply line. |
| DosSupplyLinesPEOLineId | Value that uniquely identifies the supply line. |
| DosSupplyLinesPEOLineNumber | Number that identifies the supply line. Each of these numbers in a supply order is unique. |
| DosSupplyLinesPEOMovementRequestFlag | This attribute contains 1 or 0. 1 means the supply line is for a movement request. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyLinesPEONeedByDate | Date when the requester requested fulfillment to deliver the item on the supply line to the destination. |
| DosSupplyLinesPEOObjectVersionNumber | Version of the supply line. This attribute makes sure no more than one user modifies the same object at the same time. The database increments the version every time it updates the row, then compares the version at the start and at the end of each transaction to determine whether another user updated the row during the current session. |
| DosSupplyLinesPEOOutsideProcessingFlag | This attribute contains 1 or 0. 1 means the supply line fulfills supply for outside processing. 0 means the request isn't for outside processing. No value means 0. 0 is the default value. |
| DosSupplyLinesPEOParentItemId | Value that uniquely identifies the parent item in the source system. |
| DosSupplyLinesPEOParentLineId | Value that uniquely identifies the parent line in the source system. This attribute creates a relationship between the supply line and the parent line. |
| DosSupplyLinesPEOPreparerId | Value that uniquely identifies the person who prepared the supply request. You must specify this value when you set up the preparer in an Oracle Cloud application. |
| DosSupplyLinesPEOQuantity | Quantity of the item on the supply line. |
| DosSupplyLinesPEOSecondaryQuantity | Secondary quantity of the item on the supply line. |
| DosSupplyLinesPEOSecondaryUomCode | Unit of measure for the secondary quantity of the item on the supply line. |
| DosSupplyLinesPEOSourceSystemId | Value that uniquely identifies the source system that requested supply. Order Management gets this value from the ORIG_SYSTEM_ID column of the HZ_ORIG_SYSTEMS_VL table. |
| DosSupplyLinesPEOSplitLineReferenceId | Value that uniquely identifies a reference to GOP_REFERENCE_ID. If Global Order Promising splits a fulfillment line, then it stores a reference to the original line in GOP_REFERENCE_ID. |
| DosSupplyLinesPEOStatusCode | Abbreviation that identifies the status of the supply line. The ORA_DOS_SUPPLY_LINE_STATUS lookup contains the values that you can for this attribute. |
| DosSupplyLinesPEOSupplyOperation | Operation that fulfills the supply line. Values include CREATE, UPDATE, or CANCEL. |
| DosSupplyLinesPEOSupplyOrderRefLineNumber | Number that identifies the source system that creates the interface record. Its the number that references the document line that you receive from the system that requests supply. |
| DosSupplyLinesPEOSupplyOrderReferenceLineId | Value that uniquely identifies the supply request line that your flow sends to Supply Orchestration. |
| DosSupplyLinesPEOSupplyOrderSource | Source application that sends the request for supply to Supply Orchestration. |
| DosSupplyLinesPEOSupplySourceSystem | Supply application that creates supply. Values include INV, WIE, POR, and so on. |
| DosSupplyLinesPEOSupplyType | Type of supply that the requesting application requested. The ORA_DOS_SUPPLY_ORDER_TYPE lookup contains the values that you can use for this attribute, such as TRANSFER, BUY, or MAKE. |
| DosSupplyLinesPEOUomCode | Abbreviation that identifies the unit of measure on the supply line. |