1. Tables and Views for SCM
  2. DOS_CHANGE_BUY_ORDER_DTLS_V

DOS_CHANGE_BUY_ORDER_DTLS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

SUPPLY_BUY_ORD_DTLS_ID

OBJECT_VERSION_NUMBER

TRACKING_LINE_ID

BATCH_ID

GROUP_CODE

PREPARER_ID

EARLIEST_SHIP_DATE

DELIVERY_LEAD_TIME

DELIVER_TO_LOCATION_ID

SUGGESTED_VENDOR_ID

SUGGESTED_VENDOR_SITE_ID

DELIVER_TO_REQUESTOR_ID

REQUISITION_SOURCE_TYPE_CODE

DESTINATION_TYPE_CODE

SHIPPING_METHOD

AUTOSOURCE_FLAG

END_INVENTORY_ITEM_ID

REQUISITION_LINE_ID

PURCHASE_ORDER_HEADER_ID

PURCHASE_ORDER_NUMBER

PURCHASE_ORDER_LINE_ID

PURCHASE_ORDER_LINE_NUMBER

LINE_LOCATION_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SCHEDULED_SHIP_DATE

DISTRIBUTION_ID

LINE_TYPE_ID

REQUISITION_LINE_NUMBER

REQUISITION_NUMBER

AUTHORIZATION_STATUS

REQUISITIONING_BU_ID

DESTINATION_SUBINVENTORY_CODE

EXEC_SYSTEM_DELIVER_TO_SUBINV

EXEC_SYSTEM_DELVR_TO_LOC_NAME

EXEC_SYSTEM_DELVR_TO_REQUESTOR

EXEC_SYSTEM_SUGGESTED_VENDOR

EXEC_SYSTEM_SUGSTD_VENDOR_SITE

BUYER_ID

CATEGORY_ID

REQUESTED_SHIP_DATE

CHANGE_SUPPLY_OPERATION

PRIMARY_DOC_QUANTITY

PRIMARY_DOC_QUANTITY_UOM

SHIPMENT_PRIORITY_CODE

EXEC_SYSTEM_DESTN_LOCTR_CODE

CONTRACT_MFG_ITEM_ID

CONTRACT_MFG_ITEM_REVISION

NEED_BY_DATE

PURCHASE_ORDER_SCHEDULE_NUMBER

CARRIER_ID

FIRM_FLAG

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

REQUISITION_ID

END_ITEM_NAME

WORK_ORDER_SUBTYPE

Query

SQL_Statement

SELECT

supply_order_entity_id SUPPLY_BUY_ORD_DTLS_ID,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/TrackingLineId') TRACKING_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/BatchId') BATCH_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/GroupCode') GROUP_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PreparerId') PREPARER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/EarliestShipDate') EARLIEST_SHIP_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DeliveryLeadTime') DELIVERY_LEAD_TIME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DeliverToLocationId') DELIVER_TO_LOCATION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/SuggestedVendorId') SUGGESTED_VENDOR_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/SuggestedVendorSiteId') SUGGESTED_VENDOR_SITE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DeliverToRequestorId') DELIVER_TO_REQUESTOR_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitionSourceTypeCode') REQUISITION_SOURCE_TYPE_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DestinationTypeCode') DESTINATION_TYPE_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ShippingMethod') SHIPPING_METHOD,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/AutosourceFlag') AUTOSOURCE_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/EndInventoryItemId') END_INVENTORY_ITEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitionLineId') REQUISITION_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PurchaseOrderHeaderId') PURCHASE_ORDER_HEADER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PurchaseOrderNumber') PURCHASE_ORDER_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PurchaseOrderLineId') PURCHASE_ORDER_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PurchaseOrderLineNumber') PURCHASE_ORDER_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/LineLocationId') LINE_LOCATION_ID,

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ScheduledShipDate') SCHEDULED_SHIP_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DistributionId') DISTRIBUTION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/LineTypeId') LINE_TYPE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitionLineNumber') REQUISITION_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitionNumber') REQUISITION_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/AuthorizationStatus') AUTHORIZATION_STATUS,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitioningBuId') REQUISITIONING_BU_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/DestinationSubinventoryCode') DESTINATION_SUBINVENTORY_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemDeliverToSubinv') EXEC_SYSTEM_DELIVER_TO_SUBINV,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemDelvrToLocName') EXEC_SYSTEM_DELVR_TO_LOC_NAME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemDelvrToRequestor') EXEC_SYSTEM_DELVR_TO_REQUESTOR,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemSuggestedVendor') EXEC_SYSTEM_SUGGESTED_VENDOR,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemSugstdVendorSite') EXEC_SYSTEM_SUGSTD_VENDOR_SITE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/BuyerId') BUYER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/CategoryId') CATEGORY_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequestedShipDate') REQUESTED_SHIP_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ChangeSupplyOperation') CHANGE_SUPPLY_OPERATION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PrimaryDocQuantity') PRIMARY_DOC_QUANTITY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PrimaryDocQuantityUom') PRIMARY_DOC_QUANTITY_UOM,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ShipmentPriorityCode') SHIPMENT_PRIORITY_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ExecSystemDestnLoctrCode') EXEC_SYSTEM_DESTN_LOCTR_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ContractMfgItemId') CONTRACT_MFG_ITEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ContractMfgItemRevision') CONTRACT_MFG_ITEM_REVISION,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/PurchaseOrderScheduleNumber') PURCHASE_ORDER_SCHEDULE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/CarrierId') CARRIER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/FirmFlag') FIRM_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ShipClassOfService') SHIP_CLASS_OF_SERVICE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/ShipModeOfTransport') SHIP_MODE_OF_TRANSPORT,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/RequisitionId') REQUISITION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/EndItemName') END_ITEM_NAME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyBuyOrderDtlsVORow/WorkOrderSubType') WORK_ORDER_SUBTYPE

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