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: PA.PA_EI_DENORM_EFC#

Source

View Text - Preformatted


select DENORM_ID DENORM_ID, NCU_SET_OF_BOOKS_ID NCU_SET_OF_BOOKS_ID, CREATION_DATE CREATION_DATE, QUANTITY_1 QUANTITY_1, RAW_COST_RATE_1 RAW_COST_RATE_1, RAW_COST_1 RAW_COST_1, QUANTITY_2 QUANTITY_2, RAW_COST_RATE_2 RAW_COST_RATE_2, RAW_COST_2 RAW_COST_2, QUANTITY_3 QUANTITY_3, RAW_COST_RATE_3 RAW_COST_RATE_3, RAW_COST_3 RAW_COST_3, QUANTITY_4 QUANTITY_4, RAW_COST_RATE_4 RAW_COST_RATE_4, RAW_COST_4 RAW_COST_4, QUANTITY_5 QUANTITY_5, RAW_COST_RATE_5 RAW_COST_RATE_5, RAW_COST_5 RAW_COST_5, QUANTITY_6 QUANTITY_6, RAW_COST_RATE_6 RAW_COST_RATE_6, RAW_COST_6 RAW_COST_6, QUANTITY_7 QUANTITY_7, RAW_COST_RATE_7 RAW_COST_RATE_7, RAW_COST_7 RAW_COST_7 from "PA"."PA_EI_DENORM_EFC"

View Text - HTML Formatted

SELECT DENORM_ID DENORM_ID
, NCU_SET_OF_BOOKS_ID NCU_SET_OF_BOOKS_ID
, CREATION_DATE CREATION_DATE
, QUANTITY_1 QUANTITY_1
, RAW_COST_RATE_1 RAW_COST_RATE_1
, RAW_COST_1 RAW_COST_1
, QUANTITY_2 QUANTITY_2
, RAW_COST_RATE_2 RAW_COST_RATE_2
, RAW_COST_2 RAW_COST_2
, QUANTITY_3 QUANTITY_3
, RAW_COST_RATE_3 RAW_COST_RATE_3
, RAW_COST_3 RAW_COST_3
, QUANTITY_4 QUANTITY_4
, RAW_COST_RATE_4 RAW_COST_RATE_4
, RAW_COST_4 RAW_COST_4
, QUANTITY_5 QUANTITY_5
, RAW_COST_RATE_5 RAW_COST_RATE_5
, RAW_COST_5 RAW_COST_5
, QUANTITY_6 QUANTITY_6
, RAW_COST_RATE_6 RAW_COST_RATE_6
, RAW_COST_6 RAW_COST_6
, QUANTITY_7 QUANTITY_7
, RAW_COST_RATE_7 RAW_COST_RATE_7
, RAW_COST_7 RAW_COST_7
FROM "PA"."PA_EI_DENORM_EFC"