Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | this view shows all the search criteria for projects |
Implementation/DBA Data: | APPS.MSC_SEARCH_PROJECTS_V |
SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
WHERE P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT O.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, O.SR_INSTANCE_ID
, O.ORGANIZATION_ID
, O.ORGANIZATION_CODE
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_ORGS_TREE_V O
, MSC_PLANS_TREE_V P
WHERE P.PLAN_ID = O.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT P.PLAN_ID
, P2.COMPILE_DESIGNATOR
, P2.PLAN_TYPE
, P2.PLANNED_INSTANCE_ID
, P2.PLANNED_ORGANIZATION
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, NULL
, P.PLANNING_GROUP
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PROJECTS P
, MSC_PLANS_TREE_V P2
WHERE P2.PLAN_ID = P.PLAN_ID
AND P2.PLAN_COMPLETION_DATE IS NOT NULL
AND P2.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT P.PLAN_ID
, P2.COMPILE_DESIGNATOR
, P2.PLAN_TYPE
, P2.PLANNED_INSTANCE_ID
, P2.PLANNED_ORGANIZATION
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, NULL
, P.PLANNING_GROUP
, P.PROJECT_ID
, P.PROJECT_NUMBER
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PROJECTS P
, MSC_PLANS_TREE_V P2
WHERE P2.PLAN_ID = P.PLAN_ID
AND P2.PLAN_COMPLETION_DATE IS NOT NULL
AND P2.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT P.PLAN_ID
, P2.COMPILE_DESIGNATOR
, P2.PLAN_TYPE
, P2.PLANNED_INSTANCE_ID
, P2.PLANNED_ORGANIZATION
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, NULL
, P.PLANNING_GROUP
, P.PROJECT_ID
, P.PROJECT_NUMBER
, T.TASK_ID
, T.TASK_NUMBER
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PROJECT_TASKS T
, MSC_PROJECTS P
, MSC_PLANS_TREE_V P2
WHERE P.PLAN_ID = T.PLAN_ID
AND P.SR_INSTANCE_ID = T.SR_INSTANCE_ID
AND P.ORGANIZATION_ID = T.ORGANIZATION_ID
AND P.PROJECT_ID = T.PROJECT_ID
AND P.PLAN_ID = P2.PLAN_ID
AND P2.PLAN_COMPLETION_DATE IS NOT NULL
AND P2.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT P.PLAN_ID
, P2.COMPILE_DESIGNATOR
, P2.PLAN_TYPE
, P2.PLANNED_INSTANCE_ID
, P2.PLANNED_ORGANIZATION
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, NULL
, P.PLANNING_GROUP
, P.PROJECT_ID
, NULL
, P.TASK_ID
, NULL
, P.INVENTORY_ITEM_ID
, P.ITEM_NUMBER
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PROJECT_ITEMS_TREE_V P
, MSC_PLANS_TREE_V P2
WHERE P2.PLAN_ID = P.PLAN_ID
AND P2.PLAN_COMPLETION_DATE IS NOT NULL
AND P2.DATA_COMPLETION_DATE IS NOT NULL