Product: | BOM - Bills of Material |
---|---|
Description: | CSTFV_PAC_PERIOD_BALANCES stores the WIP balances for all entities withina cost group by period. |
Implementation/DBA Data: | APPS.CSTFV_PAC_PERIOD_BALANCES |
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.WIP_ENTITY_TYPE
, 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
, MP.ORGANIZATION_CODE
, HAOU.NAME /* ID */
, WPPB.ORGANIZATION_ID /* WHO */
, WPPB.CREATION_DATE
, WPPB.CREATED_BY
, WPPB.LAST_UPDATE_DATE
, WPPB.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, 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 WPPB.ORGANIZATION_ID = MP.ORGANIZATION_ID AND WPPB.ORGANIZATION_ID = HAOU.ORGANIZATION_ID AND '_SEC:WPPB.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY