DOS_SUPPLY_TRANSFER_ORD_DTLS

Details

Schema: FUSION
Object owner: DOS
Object type: VIEW

Columns

Name
BUDGET_DATE CARRIER_ID CREATED_BY CREATION_DATE FIRM_DEMAND_FLAG FUNDS_STATUS LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LOAD_TYPE OBJECT_VERSION_NUMBER SALES_ORDER_HEADER_ID SALES_ORDER_HEADER_NUMBER SALES_ORDER_LINE_ID SALES_ORDER_LINE_NUMBER SCHEDULED_SHIP_DATE SHIP_CLASS_OF_SERVICE SHIP_MODE_OF_TRANSPORT SHIPMENT_PRIORITY_CODE SHIPPING_METHOD SUPPLY_TRANSFER_DETAILS_ID TRACKING_LINE_ID TRANSFER_ORDER_HEADER_NUMBER TRANSFER_ORDER_LINE_ID TRANSFER_ORDER_LINE_NUMBER TRANSFER_PRICE TRANSFER_PRICE_CURRENCY_CODE TRANSFER_ORDER_HEADER_ID UNIT_PRICE END_INVENTORY_ITEM_ID END_ITEM_NAME DELIVER_TO_REQUESTOR_ID PREPARER_ID SHIP_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID DOO_SHIPMENT_FLAG AGREEMENT_ID DESTINATION_TYPE_CODE UNIT_PRICE_CURRENCY_CODE SOURCE_SUBINVENTORY_CODE DESTINATION_SUBINVENTORY_CODE SOURCE_LOCATION_ID DESTINATION_LOCATION_ID 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 SOURCE_BU_ID SOURCE_ORGANIZATION_ID GROUP_CODE REQUESTED_SHIP_DATE CHANGE_SUPPLY_OPERATION PRIMARY_DOC_QUANTITY PRIMARY_DOC_QUANTITY_UOM EXEC_SYSTEM_DESTN_LOCTR_CODE

Name

BUDGET_DATE

CARRIER_ID

CREATED_BY

CREATION_DATE

FIRM_DEMAND_FLAG

FUNDS_STATUS

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LOAD_TYPE

OBJECT_VERSION_NUMBER

SALES_ORDER_HEADER_ID

SALES_ORDER_HEADER_NUMBER

SALES_ORDER_LINE_ID

SALES_ORDER_LINE_NUMBER

SCHEDULED_SHIP_DATE

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

SHIPMENT_PRIORITY_CODE

SHIPPING_METHOD

SUPPLY_TRANSFER_DETAILS_ID

TRACKING_LINE_ID

TRANSFER_ORDER_HEADER_NUMBER

TRANSFER_ORDER_LINE_ID

TRANSFER_ORDER_LINE_NUMBER

TRANSFER_PRICE

TRANSFER_PRICE_CURRENCY_CODE

TRANSFER_ORDER_HEADER_ID

UNIT_PRICE

END_INVENTORY_ITEM_ID

END_ITEM_NAME

DELIVER_TO_REQUESTOR_ID

PREPARER_ID

SHIP_TO_PARTY_ID

SHIP_TO_PARTY_SITE_ID

DOO_SHIPMENT_FLAG

AGREEMENT_ID

DESTINATION_TYPE_CODE

UNIT_PRICE_CURRENCY_CODE

SOURCE_SUBINVENTORY_CODE

DESTINATION_SUBINVENTORY_CODE

SOURCE_LOCATION_ID

DESTINATION_LOCATION_ID

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

SOURCE_BU_ID

SOURCE_ORGANIZATION_ID

GROUP_CODE

REQUESTED_SHIP_DATE

CHANGE_SUPPLY_OPERATION

PRIMARY_DOC_QUANTITY

PRIMARY_DOC_QUANTITY_UOM

EXEC_SYSTEM_DESTN_LOCTR_CODE

Query

SQL_Statement
SELECT BUDGET_DATE, CARRIER_ID, CREATED_BY, CREATION_DATE, FIRM_DEMAND_FLAG, FUNDS_STATUS, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LOAD_TYPE, OBJECT_VERSION_NUMBER, SALES_ORDER_HEADER_ID, SALES_ORDER_HEADER_NUMBER, SALES_ORDER_LINE_ID, SALES_ORDER_LINE_NUMBER, SCHEDULED_SHIP_DATE, SHIP_CLASS_OF_SERVICE, SHIP_MODE_OF_TRANSPORT, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD, SUPPLY_TRANSFER_DETAILS_ID, TRACKING_LINE_ID, TRANSFER_ORDER_HEADER_NUMBER, TRANSFER_ORDER_LINE_ID, TRANSFER_ORDER_LINE_NUMBER, TRANSFER_PRICE, TRANSFER_PRICE_CURRENCY_CODE, TRANSFER_ORDER_HEADER_ID, UNIT_PRICE, END_INVENTORY_ITEM_ID, END_ITEM_NAME, DELIVER_TO_REQUESTOR_ID, PREPARER_ID, SHIP_TO_PARTY_ID, SHIP_TO_PARTY_SITE_ID, DOO_SHIPMENT_FLAG, AGREEMENT_ID, DESTINATION_TYPE_CODE, UNIT_PRICE_CURRENCY_CODE, SOURCE_SUBINVENTORY_CODE, DESTINATION_SUBINVENTORY_CODE, SOURCE_LOCATION_ID, DESTINATION_LOCATION_ID, 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, SOURCE_BU_ID, SOURCE_ORGANIZATION_ID, GROUP_CODE, REQUESTED_SHIP_DATE, CHANGE_SUPPLY_OPERATION, PRIMARY_DOC_QUANTITY, PRIMARY_DOC_QUANTITY_UOM, EXEC_SYSTEM_DESTN_LOCTR_CODE FROM DOS_SUPPLY_TRANSFER_ORDER_DTLS

SQL_Statement

SELECT BUDGET_DATE,

CARRIER_ID,

CREATED_BY,

CREATION_DATE,

FIRM_DEMAND_FLAG,

FUNDS_STATUS,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

LOAD_TYPE,

OBJECT_VERSION_NUMBER,

SALES_ORDER_HEADER_ID,

SALES_ORDER_HEADER_NUMBER,

SALES_ORDER_LINE_ID,

SALES_ORDER_LINE_NUMBER,

SCHEDULED_SHIP_DATE,

SHIP_CLASS_OF_SERVICE,

SHIP_MODE_OF_TRANSPORT,

SHIPMENT_PRIORITY_CODE,

SHIPPING_METHOD,

SUPPLY_TRANSFER_DETAILS_ID,

TRACKING_LINE_ID,

TRANSFER_ORDER_HEADER_NUMBER,

TRANSFER_ORDER_LINE_ID,

TRANSFER_ORDER_LINE_NUMBER,

TRANSFER_PRICE,

TRANSFER_PRICE_CURRENCY_CODE,

TRANSFER_ORDER_HEADER_ID,

UNIT_PRICE,

END_INVENTORY_ITEM_ID,

END_ITEM_NAME,

DELIVER_TO_REQUESTOR_ID,

PREPARER_ID,

SHIP_TO_PARTY_ID,

SHIP_TO_PARTY_SITE_ID,

DOO_SHIPMENT_FLAG,

AGREEMENT_ID,

DESTINATION_TYPE_CODE,

UNIT_PRICE_CURRENCY_CODE,

SOURCE_SUBINVENTORY_CODE,

DESTINATION_SUBINVENTORY_CODE,

SOURCE_LOCATION_ID,

DESTINATION_LOCATION_ID,

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,

SOURCE_BU_ID,

SOURCE_ORGANIZATION_ID,

GROUP_CODE,

REQUESTED_SHIP_DATE,

CHANGE_SUPPLY_OPERATION,

PRIMARY_DOC_QUANTITY,

PRIMARY_DOC_QUANTITY_UOM,

EXEC_SYSTEM_DESTN_LOCTR_CODE

FROM DOS_SUPPLY_TRANSFER_ORDER_DTLS