VIEW: APPS.CSTFV_PAC_PERIOD_BALANCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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