DOS_SUPPLY_TRACKING_LINES
Supply tracking lines tracks the supply creation, for the supply requests created in Supply Lines
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_SUPPLY_TRACKING_LINES_PK |
TRACKING_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRACKING_LINE_ID | NUMBER | 18 | Yes | Unique identifier of the supply order tracking line, automatically generated by system | |
| CANCELED_FLAG | VARCHAR2 | 1 | Yes | This attribute is used by status management to indicate that the tracking line is in CANCELED / NOT-CANCELED state. Will be used in status roll-up. | |
| SPLIT_FROM_TLINE_ID | NUMBER | 18 | For tracking lines created during split processing, this column will identify the tracking line from which the line was split | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| HEADER_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the supply order | |
| LINE_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the supply order line | |
| PARENT_TRACKING_LINE_ID | NUMBER | 18 | Reference to the unique identifier for the parent tracking line, automatically generated by system | ||
| TRACKING_LINE_NUMBER | NUMBER | 18 | Yes | Supply Tracking Line Number, automatically generated by system | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status of the supply tracking line The status code that is eligible to be used on a tracking line. | |
| SUPPLY_OPERATION | VARCHAR2 | 30 | Yes | Operation to be performed for the supply creation. Validate with lookup (FND_LOOKUPS) | |
| SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Any updates to the supply type are reflected here. Defaults to supply order line supply_type | |
| SUPPLY_SOURCE_SYSTEM | VARCHAR2 | 120 | Source system code where the supply request is getting executed. From Payload. (HZ_ORIG_SYSTEMS_VL) | ||
| ITEM_TYPE | VARCHAR2 | 30 | Item Type as defined in the Item master | ||
| SUPPLY_ORDER_REFERENCE_LINE_ID | NUMBER | 18 | Identifier of the source system that generated the interface record | ||
| SUPPLY_ORDER_REF_LINE_NUMBER | VARCHAR2 | 20 | Identifier of the source system that generated the interface record. Document Line reference number from the requesting system | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the inventory item | |
| ITEM_REVISION | VARCHAR2 | 72 | Revision of the Item being requested | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of Measure of the Quantity | |
| QUANTITY | NUMBER | Yes | Supply Quantity being requested for this order | ||
| NEED_BY_DATE | TIMESTAMP | Date the Supply needs to be available | |||
| SECONDARY_QUANTITY | NUMBER | Secondary Requested Quantity of the item | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Quantity Unit of Measure | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Destination organization ID (for purchase request and internal req request) | ||
| DESTINATION_ORGANIZATION_CODE | VARCHAR2 | 72 | Destination Organization Code (for internal req) | ||
| DESTINATION_BU_ID | NUMBER | 18 | Operating unit in the source system for the destination organization | ||
| HOLD_FLAG | VARCHAR2 | 1 | Yes | Hold Flag Identifier (Must be Y/N) | |
| CANCEL_REASON_CODE | VARCHAR2 | 30 | Reason for cancellation of the request | ||
| CANCEL_COMMENTS | VARCHAR2 | 1000 | Free form text to capture additional comments | ||
| SUPPLY_SET | VARCHAR2 | 18 | Set identifier for grouping lines to be passed to the execution system. | ||
| EXEC_SYSTEM_PROJECT_ID | NUMBER | 18 | Project ID under which this request falls | ||
| EXEC_SYSTEM_PROJECT_NAME | VARCHAR2 | 240 | Project Name under which this request falls | ||
| EXEC_SYSTEM_TASK_ID | NUMBER | 18 | Task ID under which this request falls | ||
| EXEC_SYSTEM_TASK_NAME | VARCHAR2 | 255 | Task Name under which this request falls | ||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate exception. Must be either Y or N. | |
| OPEN_FLAG | VARCHAR2 | 1 | Yes | This field indicates if the line is open for processing. The value for this field is set by the status framework based on the response from the task layer. The default value for this field should be Y. Based on the response from the task layer, status framework sets this value to N, when the customer last step in the process is completed for the line. | |
| TERMINATED_FLAG | VARCHAR2 | 1 | Yes | Indicates that the Tracking Line is terminated. Default is N. ChangeManagement sets this flag to Y. | |
| CHANGE_PENDING_FLAG | VARCHAR2 | 1 | Yes | Change Pending Identifier (Must be Y/N) | |
| CHANGE_REQUEST_ACTION_CODE | VARCHAR2 | 120 | Change Request Action Code also referred to Minor Action such as Reschedule PO. Validate with lookup (FND_LOOKUPS) | ||
| AVAILABLE_QUANTITY | NUMBER | Quantity which has been completed at the fulfillment completion step of the process instance associated to the tracking line. The available quantity can be compared to the required quantity for the tracking line to determine if the full supply required for the fline is complete. / Stores the qty that was received as part of the step marked as fulfillment completion step in the Orchestration Process. | |||
| RESUBMIT_COUNT | NUMBER | 6 | Stores the number of retries to recover an errored out line. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| COMPENSATION_MODE | VARCHAR2 | 30 | Column identifies if compensation is running in DEMAND mode or SUPPLY mode | ||
| REFERENCE_TRACKING_LINE_ID | NUMBER | 18 | Used to store original tracking line id incase of IMT update transfer request | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SHIPMENT_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate that the TrackingLine is Shipment Tracking Line. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOS_SUPPLY_TLINES_FK1 | Non Unique | FUSION_TS_TX_IDX | LINE_ID |
| DOS_SUPPLY_TLINES_N1 | Non Unique | FUSION_TS_TX_IDX | HEADER_ID |
| DOS_SUPPLY_TLINES_N2 | Non Unique | FUSION_TS_TX_IDX | SUPPLY_ORDER_REFERENCE_LINE_ID |
| DOS_SUPPLY_TLINES_N3 | Non Unique | FUSION_TS_TX_IDX | STATUS_CODE |
| DOS_SUPPLY_TLINES_N4 | Non Unique | FUSION_TS_TX_IDX | OPEN_FLAG |
| DOS_SUPPLY_TLINES_N5 | Non Unique | FUSION_TS_TX_IDX | SUPPLY_TYPE |
| DOS_SUPPLY_TLINES_N6 | Non Unique | FUSION_TS_TX_IDX | NEED_BY_DATE, OPEN_FLAG, SUPPLY_TYPE |
| DOS_SUPPLY_TLINES_U1 | Unique | FUSION_TS_TX_IDX | TRACKING_LINE_ID |