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: WIP.WIP_PERIOD_BALANCES_EFC#

Source

View Text - Preformatted


select TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR, PL_OVERHEAD_OUT PL_OVERHEAD_OUT, TL_OVERHEAD_OUT TL_OVERHEAD_OUT, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN, PL_RESOURCE_VAR PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN, TL_RESOURCE_VAR TL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT, PL_MATERIAL_VAR PL_MATERIAL_VAR, TL_MATERIAL_VAR TL_MATERIAL_VAR, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, PL_RESOURCE_OUT PL_RESOURCE_OUT, TL_RESOURCE_OUT TL_RESOURCE_OUT, PL_MATERIAL_OVERHEAD_VAR PL_MATERIAL_OVERHEAD_VAR, PL_OVERHEAD_IN PL_OVERHEAD_IN, PL_MATERIAL_IN PL_MATERIAL_IN, PL_MATERIAL_OUT PL_MATERIAL_OUT, TL_OVERHEAD_IN TL_OVERHEAD_IN, TL_MATERIAL_OVERHEAD_VAR TL_MATERIAL_OVERHEAD_VAR, TL_MATERIAL_OUT TL_MATERIAL_OUT, ACCT_PERIOD_ID ACCT_PERIOD_ID, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT, TL_SCRAP_IN TL_SCRAP_IN, TL_SCRAP_OUT TL_SCRAP_OUT, PL_OVERHEAD_VAR PL_OVERHEAD_VAR, TL_MATERIAL_OVERHEAD_OUT TL_MATERIAL_OVERHEAD_OUT, TL_OVERHEAD_VAR TL_OVERHEAD_VAR, WIP_ENTITY_ID WIP_ENTITY_ID, PL_RESOURCE_IN PL_RESOURCE_IN, PL_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR, TL_RESOURCE_IN TL_RESOURCE_IN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID from "WIP"."WIP_PERIOD_BALANCES_EFC"

View Text - HTML Formatted

SELECT TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR
, PL_OVERHEAD_OUT PL_OVERHEAD_OUT
, TL_OVERHEAD_OUT TL_OVERHEAD_OUT
, PL_OUTSIDE_PROCESSING_IN PL_OUTSIDE_PROCESSING_IN
, PL_RESOURCE_VAR PL_RESOURCE_VAR
, PL_OUTSIDE_PROCESSING_OUT PL_OUTSIDE_PROCESSING_OUT
, PL_MATERIAL_OVERHEAD_IN PL_MATERIAL_OVERHEAD_IN
, TL_OUTSIDE_PROCESSING_IN TL_OUTSIDE_PROCESSING_IN
, TL_RESOURCE_VAR TL_RESOURCE_VAR
, TL_OUTSIDE_PROCESSING_OUT TL_OUTSIDE_PROCESSING_OUT
, PL_MATERIAL_VAR PL_MATERIAL_VAR
, TL_MATERIAL_VAR TL_MATERIAL_VAR
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, PL_RESOURCE_OUT PL_RESOURCE_OUT
, TL_RESOURCE_OUT TL_RESOURCE_OUT
, PL_MATERIAL_OVERHEAD_VAR PL_MATERIAL_OVERHEAD_VAR
, PL_OVERHEAD_IN PL_OVERHEAD_IN
, PL_MATERIAL_IN PL_MATERIAL_IN
, PL_MATERIAL_OUT PL_MATERIAL_OUT
, TL_OVERHEAD_IN TL_OVERHEAD_IN
, TL_MATERIAL_OVERHEAD_VAR TL_MATERIAL_OVERHEAD_VAR
, TL_MATERIAL_OUT TL_MATERIAL_OUT
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT
, TL_SCRAP_IN TL_SCRAP_IN
, TL_SCRAP_OUT TL_SCRAP_OUT
, PL_OVERHEAD_VAR PL_OVERHEAD_VAR
, TL_MATERIAL_OVERHEAD_OUT TL_MATERIAL_OVERHEAD_OUT
, TL_OVERHEAD_VAR TL_OVERHEAD_VAR
, WIP_ENTITY_ID WIP_ENTITY_ID
, PL_RESOURCE_IN PL_RESOURCE_IN
, PL_OUTSIDE_PROCESSING_VAR PL_OUTSIDE_PROCESSING_VAR
, TL_RESOURCE_IN TL_RESOURCE_IN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM "WIP"."WIP_PERIOD_BALANCES_EFC"