1. Tables and Views for SCM
  2. DOS_CHANGE_XFER_ORDER_DTLS_V

DOS_CHANGE_XFER_ORDER_DTLS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

SUPPLY_TRANSFER_DETAILS_ID

TRACKING_LINE_ID

SALES_ORDER_HEADER_ID

SALES_ORDER_HEADER_NUMBER

SALES_ORDER_LINE_ID

SALES_ORDER_LINE_NUMBER

TRANSFER_ORDER_HEADER_ID

TRANSFER_ORDER_HEADER_NUMBER

TRANSFER_ORDER_LINE_ID

TRANSFER_ORDER_LINE_NUMBER

SCHEDULED_SHIP_DATE

SHIPPING_METHOD

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

SHIPMENT_PRIORITY_CODE

CARRIER_ID

UNIT_PRICE

TRANSFER_PRICE

TRANSFER_PRICE_CURRENCY_CODE

TAX_RECOVERABLE

TAX_NON_RECOVERABLE

FIRM_DEMAND_FLAG

FUNDS_STATUS

BUDGET_DATE

LOAD_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

END_INVENTORY_ITEM_ID

END_ITEM_NAME

DELIVER_TO_REQUESTOR_ID

PREPARER_ID

DOO_SHIPMENT_FLAG

SHIP_TO_PARTY_ID

SHIP_TO_PARTY_SITE_ID

AGREEMENT_ID

DESTINATION_TYPE_CODE

UNIT_PRICE_CURRENCY_CODE

DESTINATION_SUBINVENTORY_CODE

SOURCE_LOCATION_ID

DESTINATION_LOCATION_ID

SOURCE_SUBINVENTORY_CODE

EXEC_SYSTEM_DELIVER_TO_SUBINV

EXEC_SYSTEM_DELVR_TO_LOC_NAME

EXEC_SYSTEM_DELVR_TO_REQUESTOR

EXEC_SYSTEM_SOURCE_LOCTR_CODE

EXEC_SYSTEM_SOURCE_ORG_CODE

GROUP_CODE

SOURCE_BU_ID

SOURCE_ORGANIZATION_ID

REQUESTED_SHIP_DATE

CHANGE_SUPPLY_OPERATION

PRIMARY_DOC_QUANTITY

PRIMARY_DOC_QUANTITY_UOM

EXEC_SYSTEM_DESTN_LOCTR_CODE

NEED_BY_DATE

NONINCL_NONRECOVERABLE_TAX

NONINCL_RECOVERABLE_TAX

BUDGET_CONTROL_ENABLED_FLAG

Query

SQL_Statement

SELECT

supply_order_entity_id SUPPLY_TRANSFER_DETAILS_ID,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SalesOrderHeaderId') SALES_ORDER_HEADER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SalesOrderHeaderNumber') SALES_ORDER_HEADER_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SalesOrderLineId') SALES_ORDER_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SalesOrderLineNumber') SALES_ORDER_LINE_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferOrderHeaderId') TRANSFER_ORDER_HEADER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferOrderHeaderNumber') TRANSFER_ORDER_HEADER_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferOrderLineId') TRANSFER_ORDER_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferOrderLineNumber') TRANSFER_ORDER_LINE_NUMBER,

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

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/UnitPrice') UNIT_PRICE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferPrice') TRANSFER_PRICE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TransferPriceCurrencyCode') TRANSFER_PRICE_CURRENCY_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TaxRecoverable') TAX_RECOVERABLE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/TaxNonRecoverable') TAX_NON_RECOVERABLE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/FirmDemandFlag') FIRM_DEMAND_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/FundsStatus') FUNDS_STATUS,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/BudgetDate') BUDGET_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/LoadType') LOAD_TYPE,

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

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

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

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

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

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/DooShipmentFlag') DOO_SHIPMENT_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/ShipToPartyId') SHIP_TO_PARTY_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/ShipToPartySiteId') SHIP_TO_PARTY_SITE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/AgreementId') AGREEMENT_ID,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/UnitPriceCurrencyCode') UNIT_PRICE_CURRENCY_CODE,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SourceLocationId') SOURCE_LOCATION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/DestinationLocationId') DESTINATION_LOCATION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SourceSubinventoryCode') SOURCE_SUBINVENTORY_CODE,

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/ExecSystemSourceLoctrCode') EXEC_SYSTEM_SOURCE_LOCTR_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/ExecSystemSourceOrgCode') EXEC_SYSTEM_SOURCE_ORG_CODE,

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SourceBuId') SOURCE_BU_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/SourceOrganizationId') SOURCE_ORGANIZATION_ID,

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

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

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

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

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

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

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/NoninclNonrecoverableTax') NONINCL_NONRECOVERABLE_TAX,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/NoninclRecoverableTax') NONINCL_RECOVERABLE_TAX,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyTransferOrderDtlsVORow/BudgeteControlEnabledFlag') BUDGET_CONTROL_ENABLED_FLAG

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