MSC_ANALYTIC_PRIVATE_PLAN_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID COMPILE_DESIGNATOR PLAN_TYPE STATUS PLANNING_MODE WORK_AREA_TYPE CREATED_BY PRIVATE_PLAN PLAN_OWNER

Query

SQL_Statement

SELECT PlanDefinitionEO.PLAN_ID, PlanDefinitionEO.COMPILE_DESIGNATOR, PlanDefinitionEO.PLAN_TYPE, PlanDefinitionEO.STATUS, PlanDefinitionEO.planning_mode , PlanDefinitionEO.work_area_type, PlanDefinitionEO.created_by, PlanDefinitionEO.private_plan, PlanDefinitionEO.plan_owner FROM msc_plan_definitions PlanDefinitionEO where PlanDefinitionEO.PRIVATE_PLAN = 1 AND PlanDefinitionEO.HAS_RUN = 1 AND PlanDefinitionEO.PLAN_TYPE != 1 AND PlanDefinitionEO.PLAN_TYPE != 4 AND PlanDefinitionEO.PLAN_COMPLETION_DATE IS NOT null AND PlanDefinitionEO.expose_to_analytic=1 union all SELECT PlanDefinitionEO.PLAN_ID, PlanDefinitionEO.COMPILE_DESIGNATOR, PlanDefinitionEO.PLAN_TYPE, PlanDefinitionEO.STATUS, PlanDefinitionEO.planning_mode , PlanDefinitionEO.work_area_type, PlanDefinitionEO.created_by, PlanDefinitionEO.private_plan, PlanDefinitionEO.plan_owner FROM msc_plan_definitions PlanDefinitionEO, PER_USERS USERS, msc_plan_Access mpa where PlanDefinitionEO.PRIVATE_PLAN = 2 AND PlanDefinitionEO.HAS_RUN = 1 AND PlanDefinitionEO.PLAN_TYPE != 1 AND PlanDefinitionEO.PLAN_TYPE != 4 AND PlanDefinitionEO.PLAN_COMPLETION_DATE IS NOT null AND mpa.plan_id = planDefinitionEO.plan_id AND mpa.user_id=USERS.USER_ID AND PlanDefinitionEO.expose_to_analytic=1 and users.user_guid=fnd_global.USER_GUID union all SELECT PlanDefinitionEO.PLAN_ID, PlanDefinitionEO.COMPILE_DESIGNATOR, PlanDefinitionEO.PLAN_TYPE, PlanDefinitionEO.STATUS, PlanDefinitionEO.planning_mode , PlanDefinitionEO.work_area_type, PlanDefinitionEO.created_by, PlanDefinitionEO.private_plan, PlanDefinitionEO.plan_owner FROM msc_plan_definitions PlanDefinitionEO, PER_USERS USERS, msc_plan_Access mpa where PlanDefinitionEO.PRIVATE_PLAN = 2 and PlanDefinitionEO.HAS_RUN = 1 AND (PlanDefinitionEO.PLAN_TYPE = 1 or PlanDefinitionEO.PLAN_TYPE = 4) AND PlanDefinitionEO.DEMAND_PLAN_COMPLETION_DATE IS NOT null and mpa.plan_id = planDefinitionEO.plan_id AND mpa.user_id=USERS.USER_ID and PlanDefinitionEO.expose_to_analytic=1 and users.user_guid=fnd_global.USER_GUID union all SELECT PlanDefinitionEO.PLAN_ID, PlanDefinitionEO.COMPILE_DESIGNATOR, PlanDefinitionEO.PLAN_TYPE, PlanDefinitionEO.STATUS, PlanDefinitionEO.planning_mode , PlanDefinitionEO.work_area_type, PlanDefinitionEO.created_by, PlanDefinitionEO.private_plan, PlanDefinitionEO.plan_owner FROM msc_plan_definitions PlanDefinitionEO where PlanDefinitionEO.PRIVATE_PLAN = 1 and PlanDefinitionEO.HAS_RUN = 1 AND (PlanDefinitionEO.PLAN_TYPE = 1 or PlanDefinitionEO.PLAN_TYPE = 4) AND PlanDefinitionEO.DEMAND_PLAN_COMPLETION_DATE IS NOT null and PlanDefinitionEO.expose_to_analytic=1