View: CST_WIP_VARIANCES_V

Product:	BOM - Bills of Material
Description:	Variance and net activity for a job or schedule for an accounting period : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_WIP_VARIANCES_V

View Text

SELECT WPB.ACCT_PERIOD_ID
, ACCT.PERIOD_NAME
, ACCT.PERIOD_START_DATE
, ACCT.SCHEDULE_CLOSE_DATE
, WPB.WIP_ENTITY_ID
, NVL(WRS.LINE_ID
, -1)
, WPB.REPETITIVE_SCHEDULE_ID
, ACCT.ORGANIZATION_ID
, /* (TL_VAR) + (PL_VAR) */ ( NVL(WPB.TL_MATERIAL_VAR
, 0) + NVL(WPB.PL_MATERIAL_VAR
, 0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_VAR
, 0) +NVL(WPB.PL_MATERIAL_OVERHEAD_VAR
, 0)+ NVL(WPB.TL_RESOURCE_VAR
, 0) + NVL(PL_RESOURCE_VAR
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_VAR
, 0) +NVL(PL_OUTSIDE_PROCESSING_VAR
, 0)+ NVL(WPB.TL_OVERHEAD_VAR
, 0) + NVL(PL_OVERHEAD_VAR
, 0) ) /* POSTED VARIANCE */
, /* (TL_IN + PL_IN) - (TL_OUT + PL_OUT) */ (( 0 + NVL(WPB.PL_MATERIAL_IN
, 0)+ 0 + NVL(WPB.PL_MATERIAL_OVERHEAD_IN
, 0) + NVL(WPB.TL_RESOURCE_IN
, 0) + NVL(PL_RESOURCE_IN
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_IN
, 0)+NVL(PL_OUTSIDE_PROCESSING_IN
, 0)+ NVL(WPB.TL_OVERHEAD_IN
, 0) + NVL(PL_OVERHEAD_IN
, 0) ) - ( NVL(WPB.TL_MATERIAL_OUT
, 0) + NVL(WPB.PL_MATERIAL_OUT
, 0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_OUT
, 0) +NVL(WPB.PL_MATERIAL_OVERHEAD_OUT
, 0)+ NVL(WPB.TL_RESOURCE_OUT
, 0) + NVL(PL_RESOURCE_OUT
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_OUT
, 0) + NVL(PL_OUTSIDE_PROCESSING_OUT
, 0)+ NVL(WPB.TL_OVERHEAD_OUT
, 0) + NVL(PL_OVERHEAD_OUT
, 0) )) /*POTENTIAL VARIANCE */
, /* (TL_IN + PL_IN) - (TL_OUT + PL_OUT) - (TL_VAR + PL_VAR) */ (( 0 + NVL(WPB.PL_MATERIAL_IN
, 0)+ 0 + NVL(WPB.PL_MATERIAL_OVERHEAD_IN
, 0)+ NVL(WPB.TL_RESOURCE_IN
, 0) + NVL(PL_RESOURCE_IN
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_IN
, 0) +NVL(PL_OUTSIDE_PROCESSING_IN
, 0)+ NVL(WPB.TL_OVERHEAD_IN
, 0) + NVL(PL_OVERHEAD_IN
, 0) ) - ( NVL(WPB.TL_MATERIAL_OUT
, 0) + NVL(WPB.PL_MATERIAL_OUT
, 0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_OUT
, 0) +NVL(WPB.PL_MATERIAL_OVERHEAD_OUT
, 0)+ NVL(WPB.TL_RESOURCE_OUT
, 0) + NVL(PL_RESOURCE_OUT
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_OUT
, 0) + NVL(PL_OUTSIDE_PROCESSING_OUT
, 0)+ NVL(WPB.TL_OVERHEAD_OUT
, 0) + NVL(PL_OVERHEAD_OUT
, 0) ) - ( NVL(WPB.TL_MATERIAL_VAR
, 0) + NVL(WPB.PL_MATERIAL_VAR
, 0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_VAR
, 0) +NVL(WPB.PL_MATERIAL_OVERHEAD_VAR
, 0)+ NVL(WPB.TL_RESOURCE_VAR
, 0) + NVL(PL_RESOURCE_VAR
, 0)+ NVL(WPB.TL_OUTSIDE_PROCESSING_VAR
, 0) + NVL(PL_OUTSIDE_PROCESSING_VAR
, 0)+ NVL(WPB.TL_OVERHEAD_VAR
, 0) + NVL(PL_OVERHEAD_VAR
, 0) )) /* NET ACTIVITY */
FROM WIP_REPETITIVE_SCHEDULES WRS
, WIP_DISCRETE_JOBS WDJ
, WIP_PERIOD_BALANCES WPB
, ORG_ACCT_PERIODS ACCT
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
AND WPB.ACCT_PERIOD_ID (+) = ACCT.ACCT_PERIOD_ID
AND WPB.ORGANIZATION_ID (+) = ACCT.ORGANIZATION_ID

Columns