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

Source

View Text - Preformatted


select BATCH_ID#1 BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, SEQUENCE_NUMBER SEQUENCE_NUMBER, PRICE_ELEMENT_TYPE_NAME PRICE_ELEMENT_TYPE_NAME, PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID, DESCRIPTION DESCRIPTION, PRICING_BASIS_NAME PRICING_BASIS_NAME, PRICING_BASIS PRICING_BASIS, VALUE VALUE, PRECISION PRECISION, DISPLAY_TARGET_FLAG DISPLAY_TARGET_FLAG, PF_TYPE PF_TYPE, DISPLAY_TO_SUPPLIERS_FLAG DISPLAY_TO_SUPPLIERS_FLAG, INTERFACE_HEADER_ID INTERFACE_HEADER_ID from "PON"."PON_AUC_PRICE_ELEMENTS_INT"

View Text - HTML Formatted

SELECT BATCH_ID#1 BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, PRICE_ELEMENT_TYPE_NAME PRICE_ELEMENT_TYPE_NAME
, PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID
, DESCRIPTION DESCRIPTION
, PRICING_BASIS_NAME PRICING_BASIS_NAME
, PRICING_BASIS PRICING_BASIS
, VALUE VALUE
, PRECISION PRECISION
, DISPLAY_TARGET_FLAG DISPLAY_TARGET_FLAG
, PF_TYPE PF_TYPE
, DISPLAY_TO_SUPPLIERS_FLAG DISPLAY_TO_SUPPLIERS_FLAG
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
FROM "PON"."PON_AUC_PRICE_ELEMENTS_INT"