eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: MSC.MSC_ST_DELIVERY_DETAILS#

Source

View Text - Preformatted


select SR_INSTANCE_ID SR_INSTANCE_ID, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, SOURCE_CODE SOURCE_CODE, SOURCE_HEADER_ID SOURCE_HEADER_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, SHIP_SET_ID SHIP_SET_ID, ARRIVAL_SET_ID ARRIVAL_SET_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID, CANCELLED_QUANTITY CANCELLED_QUANTITY, REQUESTED_QUANTITY REQUESTED_QUANTITY, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM, SHIPPED_QUANTITY SHIPPED_QUANTITY, DELIVERED_QUANTITY DELIVERED_QUANTITY, DATE_REQUESTED DATE_REQUESTED, DATE_SCHEDULED DATE_SCHEDULED, OPERATING_UNIT OPERATING_UNIT, INV_INTERFACED_FLAG INV_INTERFACED_FLAG, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE, LATEST_PICKUP_DATE LATEST_PICKUP_DATE, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "MSC"."MSC_ST_DELIVERY_DETAILS"

View Text - HTML Formatted

SELECT SR_INSTANCE_ID SR_INSTANCE_ID
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER
, SHIP_SET_ID SHIP_SET_ID
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, REQUESTED_QUANTITY REQUESTED_QUANTITY
, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, DELIVERED_QUANTITY DELIVERED_QUANTITY
, DATE_REQUESTED DATE_REQUESTED
, DATE_SCHEDULED DATE_SCHEDULED
, OPERATING_UNIT OPERATING_UNIT
, INV_INTERFACED_FLAG INV_INTERFACED_FLAG
, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE
, REFRESH_NUMBER REFRESH_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "MSC"."MSC_ST_DELIVERY_DETAILS"