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: CZ.CZ_ATP_REQUESTS#

Source

View Text - Preformatted


select CONFIGURATOR_SESSION_KEY CONFIGURATOR_SESSION_KEY, SEQ_NO SEQ_NO, PS_NODE_ID PS_NODE_ID, ITEM_KEY ITEM_KEY, ITEM_KEY_TYPE ITEM_KEY_TYPE, QUANTITY QUANTITY, UOM_CODE UOM_CODE, INV_ORG_ID INV_ORG_ID, SHIP_TO_DATE SHIP_TO_DATE, MSG_DATA MSG_DATA, ATP_REQUEST_ID ATP_REQUEST_ID, CONFIG_ITEM_ID CONFIG_ITEM_ID, PARENT_CONFIG_ITEM_ID PARENT_CONFIG_ITEM_ID, ATO_CONFIG_ITEM_ID ATO_CONFIG_ITEM_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, NEED_BY_DATE NEED_BY_DATE, DAYS_LATE DAYS_LATE from "CZ"."CZ_ATP_REQUESTS"

View Text - HTML Formatted

SELECT CONFIGURATOR_SESSION_KEY CONFIGURATOR_SESSION_KEY
, SEQ_NO SEQ_NO
, PS_NODE_ID PS_NODE_ID
, ITEM_KEY ITEM_KEY
, ITEM_KEY_TYPE ITEM_KEY_TYPE
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, INV_ORG_ID INV_ORG_ID
, SHIP_TO_DATE SHIP_TO_DATE
, MSG_DATA MSG_DATA
, ATP_REQUEST_ID ATP_REQUEST_ID
, CONFIG_ITEM_ID CONFIG_ITEM_ID
, PARENT_CONFIG_ITEM_ID PARENT_CONFIG_ITEM_ID
, ATO_CONFIG_ITEM_ID ATO_CONFIG_ITEM_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, NEED_BY_DATE NEED_BY_DATE
, DAYS_LATE DAYS_LATE
FROM "CZ"."CZ_ATP_REQUESTS"