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 |