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: APPS.CST_PERIOD_BALANCES_VIEW

Source

View Text - Preformatted


SELECT wpb.ACCT_PERIOD_ID, wpb.WIP_ENTITY_ID, wrs.LINE_ID, wpb.ORGANIZATION_ID, cce.COST_ELEMENT_ID, cce.COST_ELEMENT, decode(cce.COST_ELEMENT_ID, 1,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.MATERIAL_ACCOUNT, wrs.MATERIAL_ACCOUNT), 2,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.MATERIAL_OVERHEAD_ACCOUNT, wrs.MATERIAL_OVERHEAD_ACCOUNT), 3,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.RESOURCE_ACCOUNT, wrs.RESOURCE_ACCOUNT), 4,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.OUTSIDE_PROCESSING_ACCOUNT, wrs.OUTSIDE_PROCESSING_ACCOUNT), 5,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.OVERHEAD_ACCOUNT, wrs.OVERHEAD_ACCOUNT), NULL), sum( decode(cce.COST_ELEMENT_ID, 1,0, 2,0, 3,NVL(wpb.TL_RESOURCE_IN,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_IN,0), 5,NVL(wpb.TL_OVERHEAD_IN,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.TL_MATERIAL_OUT,0), 2,NVL(wpb.TL_MATERIAL_OVERHEAD_OUT,0), 3,NVL(wpb.TL_RESOURCE_OUT,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_OUT,0), 5,NVL(wpb.TL_OVERHEAD_OUT,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.PL_MATERIAL_IN,0), 2,NVL(wpb.PL_MATERIAL_OVERHEAD_IN,0), 3,NVL(wpb.PL_RESOURCE_IN,0), 4,NVL(wpb.PL_OUTSIDE_PROCESSING_IN,0), 5,NVL(wpb.PL_OVERHEAD_IN,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.PL_MATERIAL_OUT,0), 2,NVL(wpb.PL_MATERIAL_OVERHEAD_OUT,0), 3,NVL(wpb.PL_RESOURCE_OUT,0), 4,NVL(wpb.PL_OUTSIDE_PROCESSING_OUT,0), 5,NVL(wpb.PL_OVERHEAD_OUT,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,0 + NVL(wpb.PL_MATERIAL_IN,0), 2,0 + NVL(wpb.PL_MATERIAL_OVERHEAD_IN,0), 3,NVL(wpb.TL_RESOURCE_IN,0) + NVL(PL_RESOURCE_IN,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_IN,0)+NVL(PL_OUTSIDE_PROCESSING_IN,0), 5,NVL(wpb.TL_OVERHEAD_IN,0) + NVL(PL_OVERHEAD_IN,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.TL_MATERIAL_OUT,0) + NVL(wpb.PL_MATERIAL_OUT,0), 2,NVL(wpb.TL_MATERIAL_OVERHEAD_OUT,0)+NVL(wpb.PL_MATERIAL_OVERHEAD_OUT,0), 3,NVL(wpb.TL_RESOURCE_OUT,0) + NVL(PL_RESOURCE_OUT,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_OUT,0)+NVL(PL_OUTSIDE_PROCESSING_OUT,0), 5,NVL(wpb.TL_OVERHEAD_OUT,0) + NVL(PL_OVERHEAD_OUT,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.TL_MATERIAL_VAR,0) + NVL(wpb.PL_MATERIAL_VAR,0), 2,NVL(wpb.TL_MATERIAL_OVERHEAD_VAR,0)+NVL(wpb.PL_MATERIAL_OVERHEAD_VAR,0), 3,NVL(wpb.TL_RESOURCE_VAR,0) + NVL(PL_RESOURCE_VAR,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_VAR,0)+NVL(PL_OUTSIDE_PROCESSING_VAR,0), 5,NVL(wpb.TL_OVERHEAD_VAR,0) + NVL(PL_OVERHEAD_VAR,0), 0)), sum( decode(cce.COST_ELEMENT_ID, 1,0 + NVL(wpb.PL_MATERIAL_IN,0), 2,0 + NVL(wpb.PL_MATERIAL_OVERHEAD_IN,0), 3,NVL(wpb.TL_RESOURCE_IN,0) + NVL(PL_RESOURCE_IN,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_IN,0)+NVL(PL_OUTSIDE_PROCESSING_IN,0), 5,NVL(wpb.TL_OVERHEAD_IN,0) + NVL(PL_OVERHEAD_IN,0), 0) - decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.TL_MATERIAL_OUT,0) + NVL(wpb.PL_MATERIAL_OUT,0), 2,NVL(wpb.TL_MATERIAL_OVERHEAD_OUT,0)+NVL(wpb.PL_MATERIAL_OVERHEAD_OUT,0), 3,NVL(wpb.TL_RESOURCE_OUT,0) + NVL(PL_RESOURCE_OUT,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_OUT,0) + NVL(PL_OUTSIDE_PROCESSING_OUT,0), 5,NVL(wpb.TL_OVERHEAD_OUT,0) + NVL(PL_OVERHEAD_OUT,0), 0) - decode(cce.COST_ELEMENT_ID, 1,NVL(wpb.TL_MATERIAL_VAR,0) + NVL(wpb.PL_MATERIAL_VAR,0), 2,NVL(wpb.TL_MATERIAL_OVERHEAD_VAR,0)+NVL(wpb.PL_MATERIAL_OVERHEAD_VAR,0), 3,NVL(wpb.TL_RESOURCE_VAR,0) + NVL(PL_RESOURCE_VAR,0), 4,NVL(wpb.TL_OUTSIDE_PROCESSING_VAR,0) + NVL(PL_OUTSIDE_PROCESSING_VAR,0), 5,NVL(wpb.TL_OVERHEAD_VAR,0) + NVL(PL_OVERHEAD_VAR,0), 0)) FROM WIP_PERIOD_BALANCES WPB,WIP_DISCRETE_JOBS WDJ,WIP_REPETITIVE_SCHEDULES WRS,CST_COST_ELEMENTS CCE where wdj.wip_entity_id (+) = wpb.wip_entity_id and wdj.organization_id (+) = wpb.organization_id and wrs.repetitive_schedule_id (+) = wpb.repetitive_schedule_id and wrs.organization_id (+) = wpb.organization_id group by wpb.ACCT_PERIOD_ID, wpb.wip_entity_id, wrs.line_id, wpb.organization_id, cce.cost_element_id, cce.cost_element, decode(cce.COST_ELEMENT_ID, 1,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.MATERIAL_ACCOUNT, wrs.MATERIAL_ACCOUNT), 2,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.MATERIAL_OVERHEAD_ACCOUNT, wrs.MATERIAL_OVERHEAD_ACCOUNT), 3,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.RESOURCE_ACCOUNT, wrs.RESOURCE_ACCOUNT), 4,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.OUTSIDE_PROCESSING_ACCOUNT, wrs.OUTSIDE_PROCESSING_ACCOUNT), 5,decode(wpb.REPETITIVE_SCHEDULE_ID, NULL, wdj.OVERHEAD_ACCOUNT, wrs.OVERHEAD_ACCOUNT), NULL)

View Text - HTML Formatted

SELECT WPB.ACCT_PERIOD_ID
, WPB.WIP_ENTITY_ID
, WRS.LINE_ID
, WPB.ORGANIZATION_ID
, CCE.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, DECODE(CCE.COST_ELEMENT_ID
, 1
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.MATERIAL_ACCOUNT
, WRS.MATERIAL_ACCOUNT)
, 2
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.MATERIAL_OVERHEAD_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT)
, 3
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.RESOURCE_ACCOUNT
, WRS.RESOURCE_ACCOUNT)
, 4
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.OUTSIDE_PROCESSING_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT)
, 5
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.OVERHEAD_ACCOUNT
, WRS.OVERHEAD_ACCOUNT)
, NULL)
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, 0
, 2
, 0
, 3
, NVL(WPB.TL_RESOURCE_IN
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_IN
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_IN
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.TL_MATERIAL_OUT
, 0)
, 2
, NVL(WPB.TL_MATERIAL_OVERHEAD_OUT
, 0)
, 3
, NVL(WPB.TL_RESOURCE_OUT
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_OUT
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_OUT
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.PL_MATERIAL_IN
, 0)
, 2
, NVL(WPB.PL_MATERIAL_OVERHEAD_IN
, 0)
, 3
, NVL(WPB.PL_RESOURCE_IN
, 0)
, 4
, NVL(WPB.PL_OUTSIDE_PROCESSING_IN
, 0)
, 5
, NVL(WPB.PL_OVERHEAD_IN
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.PL_MATERIAL_OUT
, 0)
, 2
, NVL(WPB.PL_MATERIAL_OVERHEAD_OUT
, 0)
, 3
, NVL(WPB.PL_RESOURCE_OUT
, 0)
, 4
, NVL(WPB.PL_OUTSIDE_PROCESSING_OUT
, 0)
, 5
, NVL(WPB.PL_OVERHEAD_OUT
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, 0 + NVL(WPB.PL_MATERIAL_IN
, 0)
, 2
, 0 + NVL(WPB.PL_MATERIAL_OVERHEAD_IN
, 0)
, 3
, NVL(WPB.TL_RESOURCE_IN
, 0) + NVL(PL_RESOURCE_IN
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_IN
, 0)+NVL(PL_OUTSIDE_PROCESSING_IN
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_IN
, 0) + NVL(PL_OVERHEAD_IN
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.TL_MATERIAL_OUT
, 0) + NVL(WPB.PL_MATERIAL_OUT
, 0)
, 2
, NVL(WPB.TL_MATERIAL_OVERHEAD_OUT
, 0)+NVL(WPB.PL_MATERIAL_OVERHEAD_OUT
, 0)
, 3
, NVL(WPB.TL_RESOURCE_OUT
, 0) + NVL(PL_RESOURCE_OUT
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_OUT
, 0)+NVL(PL_OUTSIDE_PROCESSING_OUT
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_OUT
, 0) + NVL(PL_OVERHEAD_OUT
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.TL_MATERIAL_VAR
, 0) + NVL(WPB.PL_MATERIAL_VAR
, 0)
, 2
, NVL(WPB.TL_MATERIAL_OVERHEAD_VAR
, 0)+NVL(WPB.PL_MATERIAL_OVERHEAD_VAR
, 0)
, 3
, NVL(WPB.TL_RESOURCE_VAR
, 0) + NVL(PL_RESOURCE_VAR
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_VAR
, 0)+NVL(PL_OUTSIDE_PROCESSING_VAR
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_VAR
, 0) + NVL(PL_OVERHEAD_VAR
, 0)
, 0))
, SUM( DECODE(CCE.COST_ELEMENT_ID
, 1
, 0 + NVL(WPB.PL_MATERIAL_IN
, 0)
, 2
, 0 + NVL(WPB.PL_MATERIAL_OVERHEAD_IN
, 0)
, 3
, NVL(WPB.TL_RESOURCE_IN
, 0) + NVL(PL_RESOURCE_IN
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_IN
, 0)+NVL(PL_OUTSIDE_PROCESSING_IN
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_IN
, 0) + NVL(PL_OVERHEAD_IN
, 0)
, 0) - DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.TL_MATERIAL_OUT
, 0) + NVL(WPB.PL_MATERIAL_OUT
, 0)
, 2
, NVL(WPB.TL_MATERIAL_OVERHEAD_OUT
, 0)+NVL(WPB.PL_MATERIAL_OVERHEAD_OUT
, 0)
, 3
, NVL(WPB.TL_RESOURCE_OUT
, 0) + NVL(PL_RESOURCE_OUT
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_OUT
, 0) + NVL(PL_OUTSIDE_PROCESSING_OUT
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_OUT
, 0) + NVL(PL_OVERHEAD_OUT
, 0)
, 0) - DECODE(CCE.COST_ELEMENT_ID
, 1
, NVL(WPB.TL_MATERIAL_VAR
, 0) + NVL(WPB.PL_MATERIAL_VAR
, 0)
, 2
, NVL(WPB.TL_MATERIAL_OVERHEAD_VAR
, 0)+NVL(WPB.PL_MATERIAL_OVERHEAD_VAR
, 0)
, 3
, NVL(WPB.TL_RESOURCE_VAR
, 0) + NVL(PL_RESOURCE_VAR
, 0)
, 4
, NVL(WPB.TL_OUTSIDE_PROCESSING_VAR
, 0) + NVL(PL_OUTSIDE_PROCESSING_VAR
, 0)
, 5
, NVL(WPB.TL_OVERHEAD_VAR
, 0) + NVL(PL_OVERHEAD_VAR
, 0)
, 0))
FROM WIP_PERIOD_BALANCES WPB
, WIP_DISCRETE_JOBS WDJ
, WIP_REPETITIVE_SCHEDULES WRS
, CST_COST_ELEMENTS CCE
WHERE WDJ.WIP_ENTITY_ID (+) = WPB.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID (+) = WPB.ORGANIZATION_ID
AND WRS.REPETITIVE_SCHEDULE_ID (+) = WPB.REPETITIVE_SCHEDULE_ID
AND WRS.ORGANIZATION_ID (+) = WPB.ORGANIZATION_ID GROUP BY WPB.ACCT_PERIOD_ID
, WPB.WIP_ENTITY_ID
, WRS.LINE_ID
, WPB.ORGANIZATION_ID
, CCE.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, DECODE(CCE.COST_ELEMENT_ID
, 1
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.MATERIAL_ACCOUNT
, WRS.MATERIAL_ACCOUNT)
, 2
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.MATERIAL_OVERHEAD_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT)
, 3
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.RESOURCE_ACCOUNT
, WRS.RESOURCE_ACCOUNT)
, 4
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.OUTSIDE_PROCESSING_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT)
, 5
, DECODE(WPB.REPETITIVE_SCHEDULE_ID
, NULL
, WDJ.OVERHEAD_ACCOUNT
, WRS.OVERHEAD_ACCOUNT)
, NULL)