View: CST_WIP_PERIOD_BALANCES_V

Product:	BOM - Bills of Material
Description:	Net activity and balance for a job or schedule in an accounting period : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_WIP_PERIOD_BALANCES_V

View Text

SELECT WPB.ACCT_PERIOD_ID
, ACCT.PERIOD_NAME
, ACCT.PERIOD_START_DATE
, ACCT.SCHEDULE_CLOSE_DATE
, WPB.WIP_ENTITY_ID
, WRS.LINE_ID
, WPB.REPETITIVE_SCHEDULE_ID
, WPB.ORGANIZATION_ID
, /* POSTED VARIANCE (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) )
, /* POTENTIAL 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) ))
, /* NET ACTIVITY (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) ))
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