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_PAC_PERIOD_BALANCES_EFC#

Source

View Text - Preformatted


select TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR, PL_OVERHEAD_OUT PL_OVERHEAD_OUT, PAC_PERIOD_ID PAC_PERIOD_ID, 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, COST_GROUP_ID COST_GROUP_ID, PL_MATERIAL_VAR PL_MATERIAL_VAR, 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, ORGANIZATION_ID ORGANIZATION_ID, PL_MATERIAL_OUT PL_MATERIAL_OUT, TL_OVERHEAD_IN TL_OVERHEAD_IN, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT, PL_OVERHEAD_VAR PL_OVERHEAD_VAR, LINE_ID LINE_ID, 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_PAC_PERIOD_BALANCES_EFC"

View Text - HTML Formatted

SELECT TL_OUTSIDE_PROCESSING_VAR TL_OUTSIDE_PROCESSING_VAR
, PL_OVERHEAD_OUT PL_OVERHEAD_OUT
, PAC_PERIOD_ID PAC_PERIOD_ID
, 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
, COST_GROUP_ID COST_GROUP_ID
, PL_MATERIAL_VAR PL_MATERIAL_VAR
, 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
, ORGANIZATION_ID ORGANIZATION_ID
, PL_MATERIAL_OUT PL_MATERIAL_OUT
, TL_OVERHEAD_IN TL_OVERHEAD_IN
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, PL_MATERIAL_OVERHEAD_OUT PL_MATERIAL_OVERHEAD_OUT
, PL_OVERHEAD_VAR PL_OVERHEAD_VAR
, LINE_ID LINE_ID
, 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_PAC_PERIOD_BALANCES_EFC"