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: PON.PON_AUC_PRICE_BREAKS_INTERFAC#

Source

View Text - Preformatted


select BATCH_ID#1 BATCH_ID, AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, INTERFACE_LINE_ID INTERFACE_LINE_ID, SHIPMENT_NUMBER SHIPMENT_NUMBER, SHIPMENT_TYPE SHIPMENT_TYPE, QUANTITY QUANTITY, PRICE PRICE, ORG_ID ORG_ID, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, MAX_QUANTITY MAX_QUANTITY, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SHIP_TO_ORGANIZATION SHIP_TO_ORGANIZATION, SHIP_TO_LOCATION SHIP_TO_LOCATION, ORG_NAME ORG_NAME, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, AUCTION_SHIPMENT_NUMBER AUCTION_SHIPMENT_NUMBER, NEED_BY_DATE NEED_BY_DATE, MIN_QUANTITY MIN_QUANTITY, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER from "PON"."PON_AUC_PRICE_BREAKS_INTERFACE"

View Text - HTML Formatted

SELECT BATCH_ID#1 BATCH_ID
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, SHIPMENT_TYPE SHIPMENT_TYPE
, QUANTITY QUANTITY
, PRICE PRICE
, ORG_ID ORG_ID
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, MAX_QUANTITY MAX_QUANTITY
, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE
, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SHIP_TO_ORGANIZATION SHIP_TO_ORGANIZATION
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, ORG_NAME ORG_NAME
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, AUCTION_SHIPMENT_NUMBER AUCTION_SHIPMENT_NUMBER
, NEED_BY_DATE NEED_BY_DATE
, MIN_QUANTITY MIN_QUANTITY
, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER
FROM "PON"."PON_AUC_PRICE_BREAKS_INTERFACE"