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