1. Tables and Views for SCM
  2. DOS_CHANGE_HEADERS_V

DOS_CHANGE_HEADERS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

HEADER_ID

OBJECT_VERSION_NUMBER

SUPPLY_ORDER_NUMBER

SUPPLY_ORDER_SOURCE

INTERFACE_BATCH_NUMBER

INTERFACE_BATCH_NAME

STATUS_CODE

SUPPLY_REQUEST_DATE

SUPPLY_ORDER_REFERENCE_NUMBER

SUPPLY_ORDER_REFERENCE_ID

TRUSTED_SOURCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

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

SOURCE_REF_DOC_DESCRIPTION

INTERFACE_SOURCE_CODE

Query

SQL_Statement

SELECT

supply_order_entity_id HEADER_ID,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/SupplyOrderNumber') SUPPLY_ORDER_NUMBER,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/InterfaceBatchNumber') INTERFACE_BATCH_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/InterfaceBatchName') INTERFACE_BATCH_NAME,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/SupplyRequestDate') SUPPLY_REQUEST_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/SupplyOrderReferenceNumber') SUPPLY_ORDER_REFERENCE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/SupplyOrderReferenceId') SUPPLY_ORDER_REFERENCE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/TrustedSource') TRUSTED_SOURCE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/SourceRefDocDescription') SOURCE_REF_DOC_DESCRIPTION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyHeaderVORow/InterfaceSourceCode') INTERFACE_SOURCE_CODE

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