View: WIPFV_WIP_PERIOD_BALANCES

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_WIP_PERIOD_BALANCES

View Text

SELECT AC.PERIOD_NAME
, EN.WIP_ENTITY_NAME
, '_LA:PE.CLASS_TYPE:MFG_LOOKUPS:WIP_CLASS_TYPE:MEANING'
, PE.TL_RESOURCE_IN
, PE.TL_OVERHEAD_IN
, PE.TL_OUTSIDE_PROCESSING_IN
, PE.PL_MATERIAL_IN
, PE.PL_MATERIAL_OVERHEAD_IN
, PE.PL_RESOURCE_IN
, PE.PL_OVERHEAD_IN
, PE.PL_OUTSIDE_PROCESSING_IN
, PE.TL_MATERIAL_OUT
, PE.TL_MATERIAL_OVERHEAD_OUT
, PE.TL_RESOURCE_OUT
, PE.TL_OVERHEAD_OUT
, PE.TL_OUTSIDE_PROCESSING_OUT
, PE.PL_MATERIAL_OUT
, PE.PL_MATERIAL_OVERHEAD_OUT
, PE.PL_RESOURCE_OUT
, PE.PL_OVERHEAD_OUT
, PE.PL_OUTSIDE_PROCESSING_OUT
, PE.TL_MATERIAL_VAR
, PE.TL_MATERIAL_OVERHEAD_VAR
, PE.TL_RESOURCE_VAR
, PE.TL_OUTSIDE_PROCESSING_VAR
, PE.TL_OVERHEAD_VAR
, PE.PL_MATERIAL_VAR
, PE.PL_MATERIAL_OVERHEAD_VAR
, PE.PL_RESOURCE_VAR
, PE.PL_OVERHEAD_VAR
, PE.PL_OUTSIDE_PROCESSING_VAR
, PA.ORGANIZATION_CODE
, AL.NAME
, PE.ACCT_PERIOD_ID
, PE.WIP_ENTITY_ID
, PE.REPETITIVE_SCHEDULE_ID
, PE.ORGANIZATION_ID
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RE
, ORG_ACCT_PERIODS AC
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_PERIOD_BALANCES PE
WHERE PE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND PE.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND PE.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID
AND NVL(PE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(RE.REPETITIVE_SCHEDULE_ID
, -1)
AND PE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND PE.REPETITIVE_SCHEDULE_ID = RE.REPETITIVE_SCHEDULE_ID(+)
AND PE.ORGANIZATION_ID = RE.ORGANIZATION_ID(+)
AND PE.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+)
AND PE.ORGANIZATION_ID = DI.ORGANIZATION_ID(+)
AND '_SEC:PE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns