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.

[Home] [Help]

VIEW: MSC.MSC_SO_RELEASE_INTERFACE#

Source

View Text - Preformatted


select RELEASE_ID RELEASE_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SR_CUSTOMER_ID SR_CUSTOMER_ID, SR_CUSTOMER_SITE_ID SR_CUSTOMER_SITE_ID, SR_ITEM_ID SR_ITEM_ID, QUANTITY QUANTITY, ACTION ACTION, REQUEST_DATE REQUEST_DATE, ATP_OVERRIDE ATP_OVERRIDE, 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, ERROR_MESSAGE ERROR_MESSAGE, OE_TRANSACTION_TYPE OE_TRANSACTION_TYPE, OE_HEADER_ID OE_HEADER_ID, OE_LINE_ID OE_LINE_ID, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, RETURN_STATUS RETURN_STATUS, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, SCHEDULE_DATE_CHANGE SCHEDULE_DATE_CHANGE, UOM_CODE UOM_CODE, ORDER_NUMBER ORDER_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, LINE_NUMBER LINE_NUMBER, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER from "MSC"."MSC_SO_RELEASE_INTERFACE"

View Text - HTML Formatted

SELECT RELEASE_ID RELEASE_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SR_CUSTOMER_ID SR_CUSTOMER_ID
, SR_CUSTOMER_SITE_ID SR_CUSTOMER_SITE_ID
, SR_ITEM_ID SR_ITEM_ID
, QUANTITY QUANTITY
, ACTION ACTION
, REQUEST_DATE REQUEST_DATE
, ATP_OVERRIDE ATP_OVERRIDE
, 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
, ERROR_MESSAGE ERROR_MESSAGE
, OE_TRANSACTION_TYPE OE_TRANSACTION_TYPE
, OE_HEADER_ID OE_HEADER_ID
, OE_LINE_ID OE_LINE_ID
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, RETURN_STATUS RETURN_STATUS
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, SCHEDULE_DATE_CHANGE SCHEDULE_DATE_CHANGE
, UOM_CODE UOM_CODE
, ORDER_NUMBER ORDER_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, LINE_NUMBER LINE_NUMBER
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
FROM "MSC"."MSC_SO_RELEASE_INTERFACE"