VIEW: APPS.WIPFV_WIP_PERIOD_BALANCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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