View: CSTBV_PAC_PERIOD_BALANCES

Product:	BOM - Bills of Material
Description:	CSTBV_PAC_PERIOD_BALANCES stores the WIP balances for all entities withina cost group by period.
Implementation/DBA Data:	APPS.CSTBV_PAC_PERIOD_BALANCES

View Text

SELECT WPPB.PAC_PERIOD_ID /*PK*/
, WPPB.WIP_ENTITY_ID /*PK*/
, WPPB.LINE_ID /*PK*/
, WPPB.OPERATION_SEQ_NUM /*PK*/
, WPPB.COST_GROUP_ID /*PK*/
, WPPB.COST_TYPE_ID /*PK*/
, WPPB.OPERATION_COMPLETED_UNITS
, WPPB.RELIEVED_ASSEMBLY_UNITS
, WPPB.TL_RESOURCE_IN
, WPPB.TL_RESOURCE_OUT
, WPPB.TL_OUTSIDE_PROCESSING_IN
, WPPB.TL_OUTSIDE_PROCESSING_OUT
, WPPB.TL_OVERHEAD_IN
, WPPB.TL_OVERHEAD_OUT
, WPPB.PL_MATERIAL_IN
, WPPB.PL_MATERIAL_OUT
, WPPB.PL_RESOURCE_IN
, WPPB.PL_RESOURCE_OUT
, WPPB.PL_OVERHEAD_IN
, WPPB.PL_OVERHEAD_OUT
, WPPB.PL_OUTSIDE_PROCESSING_IN
, WPPB.PL_OUTSIDE_PROCESSING_OUT
, WPPB.PL_MATERIAL_OVERHEAD_IN
, WPPB.PL_MATERIAL_OVERHEAD_OUT
, WPPB.TL_RESOURCE_VAR
, WPPB.TL_OUTSIDE_PROCESSING_VAR
, WPPB.TL_OVERHEAD_VAR
, WPPB.PL_MATERIAL_VAR
, WPPB.PL_MATERIAL_OVERHEAD_VAR
, WPPB.PL_RESOURCE_VAR
, WPPB.PL_OUTSIDE_PROCESSING_VAR
, WPPB.PL_OVERHEAD_VAR /* FOREIGN KEYS RESOLVED */
, CPP.PERIOD_NAME
, WE.WIP_ENTITY_NAME
, WL.LINE_CODE
, CCG.COST_GROUP
, CCT.COST_TYPE /* ID */
, WPPB.ORGANIZATION_ID
, WPPB.WIP_ENTITY_TYPE /* WHO */
, WPPB.CREATION_DATE
, WPPB.CREATED_BY
, WPPB.LAST_UPDATE_DATE
, WPPB.LAST_UPDATED_BY
FROM WIP_ENTITIES WE
, WIP_LINES WL
, CST_PAC_PERIODS CPP
, CST_COST_TYPES CCT
, CST_COST_GROUPS CCG
, WIP_PAC_PERIOD_BALANCES WPPB
WHERE WPPB.PAC_PERIOD_ID = CPP.PAC_PERIOD_ID (+) AND WPPB.COST_GROUP_ID = CCG.COST_GROUP_ID (+)
AND CCG.COST_GROUP_TYPE (+) = 2 AND WPPB.COST_TYPE_ID = CCT.COST_TYPE_ID (+)
AND WPPB.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+)
AND WPPB.LINE_ID = WL.LINE_ID (+) AND '_SEC:WPPB.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns