1. Tables and Views for SCM
  2. DOS_CHANGE_TRACKING_LINES_V

DOS_CHANGE_TRACKING_LINES_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

HEADER_ID

LINE_ID

TRACKING_LINE_ID

PARENT_TRACKING_LINE_ID

TRACKING_LINE_NUMBER

STATUS_CODE

INVENTORY_ITEM_ID

ITEM_REVISION

UOM_CODE

QUANTITY

NEED_BY_DATE

DESTINATION_ORGANIZATION_ID

DESTINATION_ORGANIZATION_CODE

DESTINATION_BU_ID

HOLD_FLAG

CANCEL_REASON_CODE

CANCEL_COMMENTS

SUPPLY_SET

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR20

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ITEM_TYPE

SUPPLY_OPERATION

SUPPLY_ORDER_REFERENCE_LINE_ID

SUPPLY_ORDER_REF_LINE_NUMBER

SUPPLY_SOURCE_SYSTEM

SUPPLY_TYPE

EXCEPTION_FLAG

SECONDARY_QUANTITY

SECONDARY_UOM_CODE

SPLIT_FROM_TLINE_ID

EXEC_SYSTEM_PROJECT_ID

EXEC_SYSTEM_PROJECT_NAME

EXEC_SYSTEM_TASK_ID

EXEC_SYSTEM_TASK_NAME

OPEN_FLAG

CHANGE_PENDING_FLAG

CHANGE_REQUEST_ACTION_CODE

CANCELED_FLAG

AVAILABLE_QUANTITY

INITIATING_TASK

SHIPMENT_FLAG

Query

SQL_Statement

SELECT

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/HeaderId') HEADER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/LineId') LINE_ID,

supply_order_entity_id TRACKING_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ParentTrackingLineId') PARENT_TRACKING_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/TrackingLineNumber') TRACKING_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/StatusCode') STATUS_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/InventoryItemId') INVENTORY_ITEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ItemRevision') ITEM_REVISION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/UomCode') UOM_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/Quantity') QUANTITY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/NeedByDate') NEED_BY_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/DestinationOrganizationId') DESTINATION_ORGANIZATION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/DestinationOrganizationCode') DESTINATION_ORGANIZATION_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/DestinationBuId') DESTINATION_BU_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/HoldFlag') HOLD_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/CancelReasonCode') CANCEL_REASON_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/CancelComments') CANCEL_COMMENTS,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplySet') SUPPLY_SET,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/CreatedBy') CREATED_BY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/CreationDate') CREATION_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/LastUpdatedBy') LAST_UPDATED_BY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/LastUpdateLogin') LAST_UPDATE_LOGIN,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/LastUpdateDate') LAST_UPDATE_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ObjectVersionNumber') OBJECT_VERSION_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeCategory') ATTRIBUTE_CATEGORY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar1') ATTRIBUTE_CHAR1,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar10') ATTRIBUTE_CHAR10,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar11') ATTRIBUTE_CHAR11,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar12') ATTRIBUTE_CHAR12,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar13') ATTRIBUTE_CHAR13,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar14') ATTRIBUTE_CHAR14,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar15') ATTRIBUTE_CHAR15,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar16') ATTRIBUTE_CHAR16,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar17') ATTRIBUTE_CHAR17,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar18') ATTRIBUTE_CHAR18,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar19') ATTRIBUTE_CHAR19,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar2') ATTRIBUTE_CHAR2,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar20') ATTRIBUTE_CHAR20,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar3') ATTRIBUTE_CHAR3,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar4') ATTRIBUTE_CHAR4,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar5') ATTRIBUTE_CHAR5,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar6') ATTRIBUTE_CHAR6,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar7') ATTRIBUTE_CHAR7,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar8') ATTRIBUTE_CHAR8,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeChar9') ATTRIBUTE_CHAR9,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeDate1') ATTRIBUTE_DATE1,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeDate2') ATTRIBUTE_DATE2,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeDate3') ATTRIBUTE_DATE3,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeDate4') ATTRIBUTE_DATE4,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeDate5') ATTRIBUTE_DATE5,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber1') ATTRIBUTE_NUMBER1,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber10') ATTRIBUTE_NUMBER10,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber2') ATTRIBUTE_NUMBER2,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber3') ATTRIBUTE_NUMBER3,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber4') ATTRIBUTE_NUMBER4,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber5') ATTRIBUTE_NUMBER5,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber6') ATTRIBUTE_NUMBER6,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber7') ATTRIBUTE_NUMBER7,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber8') ATTRIBUTE_NUMBER8,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeNumber9') ATTRIBUTE_NUMBER9,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeTimestamp1') ATTRIBUTE_TIMESTAMP1,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeTimestamp2') ATTRIBUTE_TIMESTAMP2,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeTimestamp3') ATTRIBUTE_TIMESTAMP3,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeTimestamp4') ATTRIBUTE_TIMESTAMP4,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AttributeTimestamp5') ATTRIBUTE_TIMESTAMP5,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ItemType') ITEM_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplyOperation') SUPPLY_OPERATION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplyOrderReferenceLineId') SUPPLY_ORDER_REFERENCE_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplyOrderRefLineNumber') SUPPLY_ORDER_REF_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplySourceSystem') SUPPLY_SOURCE_SYSTEM,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SupplyType') SUPPLY_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ExceptionFlag') EXCEPTION_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SecondaryQuantity') SECONDARY_QUANTITY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SecondaryUomCode') SECONDARY_UOM_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/SplitFromTlineId') SPLIT_FROM_TLINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ExecSystemProjectId') EXEC_SYSTEM_PROJECT_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ExecSystemProjectName') EXEC_SYSTEM_PROJECT_NAME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ExecSystemTaskId') EXEC_SYSTEM_TASK_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ExecSystemTaskName') EXEC_SYSTEM_TASK_NAME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/OpenFlag') OPEN_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ChangePendingFlag') CHANGE_PENDING_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ChangeRequestActionCode') CHANGE_REQUEST_ACTION_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/CanceledFlag') CANCELED_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/AvailableQuantity') AVAILABLE_QUANTITY, extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/InitiatingTask') INITIATING_TASK,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTrackingLineVORow/ShipmentFlag') SHIPMENT_FLAG

FROM DOS_CHANGE_SUPPLY_ORDER WHERE SUPPLY_ORDER_ENTITY_TYPE='DOS_SUPPLY_TRACKING_LINES' AND ACTIVE_FLAG='Y'