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' |