1. Tables and Views for SCM
  2. DOS_CHANGE_LINES_V

DOS_CHANGE_LINES_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

LINE_ID

OBJECT_VERSION_NUMBER

HEADER_ID

PARENT_LINE_ID

LINE_NUMBER

ITEM_TYPE

STATUS_CODE

SUPPLY_ORDER_REF_LINE_NUMBER

SUPPLY_ORDER_REFERENCE_LINE_ID

SUPPLY_OPERATION

SUPPLY_TYPE

SUPPLY_SOURCE_SYSTEM

INVENTORY_ITEM_ID

ITEM_REVISION

UOM_CODE

QUANTITY

DESTINATION_ORGANIZATION_ID

DESTINATION_ORGANIZATION_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

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_DESCRIPTION

SECONDARY_QUANTITY

SECONDARY_UOM_CODE

NEED_BY_DATE

EXEC_SYSTEM_ITEM_NUMBER

CHANGE_PENDING_FLAG

BACK_TO_BACK_FLAG

CONFIG_ITEM_FLAG

CONTRACT_MANUFACTURING_FLAG

CUSTOMER_CONTACT_ID

CUSTOMER_ID

CUSTOMER_ORDER_LINE_NUMBER

CUSTOMER_ORDER_NUMBER

CUSTOMER_ORDER_SCHEDULE_NUMBER

CUSTOMER_SHIP_TO_ID

SPLIT_LINE_REFERENCE_ID

CUSTOMER_ORDER_SOURCE_SYSTEM

ATTRIBUTE_CATEGORY

DESTINATION_BU_ID

SUPPLY_ORDER_SOURCE

SOURCE_SYSTEM_ID

PARENT_ITEM_ID

OUTSIDE_PROCESSING_FLAG

Query

SQL_Statement

SELECT

DISTINCT

supply_order_entity_id LINE_ID,

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ParentLineId') PARENT_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/LineNumber') LINE_NUMBER,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ItemDescription') ITEM_DESCRIPTION,

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ExecSystemItemNumber') EXEC_SYSTEM_ITEM_NUMBER,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/BackToBackFlag') BACK_TO_BACK_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ConfigItemFlag') CONFIG_ITEM_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ContractManufacturingFlag') CONTRACT_MANUFACTURING_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerContactId') CUSTOMER_CONTACT_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerId') CUSTOMER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerOrderLineNumber') CUSTOMER_ORDER_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerOrderNumber') CUSTOMER_ORDER_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerOrderScheduleNumber') CUSTOMER_ORDER_SCHEDULE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerShipToId') CUSTOMER_SHIP_TO_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/SplitLineReferenceId') SPLIT_LINE_REFERENCE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/CustomerOrderSourceSystem') CUSTOMER_ORDER_SOURCE_SYSTEM,

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/SupplyOrderSource') SUPPLY_ORDER_SOURCE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/SourceSystemId') SOURCE_SYSTEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/ParentItemId') PARENT_ITEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyLineVORow/OutsideProcessingFlag') OUTSIDE_PROCESSING_FLAG

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