View: MSC_PROJECT_ITEMS_TREE_V

Product:	MSC - Advanced Supply Chain Planning
Description:	this view shows all the project items in the tree
Implementation/DBA Data:	APPS.MSC_PROJECT_ITEMS_TREE_V

View Text

SELECT S.PLAN_ID
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
, S.PLANNING_GROUP
, S.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, S.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, S.INVENTORY_ITEM_ID
, I.ITEM_NAME
, I.DESCRIPTION
FROM MSC_SYSTEM_ITEMS I
, MSC_PROJECTS P
, MSC_PROJECT_TASKS T
, MSC_SUPPLIES S
WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND S.PLAN_ID = I.PLAN_ID
AND P.PROJECT_ID = S.PROJECT_ID
AND P.SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND P.ORGANIZATION_ID = S.ORGANIZATION_ID
AND P.PLAN_ID = -1
AND T.TASK_ID(+) = S.TASK_ID
AND T.PROJECT_ID(+) = S.PROJECT_ID
AND T.SR_INSTANCE_ID(+) = S.SR_INSTANCE_ID
AND T.ORGANIZATION_ID(+) = S.ORGANIZATION_ID
AND T.PLAN_ID(+) = -1
AND S.PROJECT_ID IS NOT NULL UNION ALL SELECT D.PLAN_ID
, D.ORGANIZATION_ID
, D.SR_INSTANCE_ID
, D.PLANNING_GROUP
, D.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, D.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, D.INVENTORY_ITEM_ID
, I.ITEM_NAME
, I.DESCRIPTION
FROM MSC_SYSTEM_ITEMS I
, MSC_PROJECTS P
, MSC_PROJECT_TASKS T
, MSC_DEMANDS D
WHERE D.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND D.ORGANIZATION_ID = I.ORGANIZATION_ID
AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND D.PLAN_ID = I.PLAN_ID
AND P.PROJECT_ID = D.PROJECT_ID
AND P.SR_INSTANCE_ID = D.SR_INSTANCE_ID
AND P.ORGANIZATION_ID = D.ORGANIZATION_ID
AND P.PLAN_ID = -1
AND T.TASK_ID(+) = D.TASK_ID
AND T.PROJECT_ID(+) = D.PROJECT_ID
AND T.SR_INSTANCE_ID(+) = D.SR_INSTANCE_ID
AND T.ORGANIZATION_ID(+) = D.ORGANIZATION_ID
AND T.PLAN_ID(+) = -1
AND D.PROJECT_ID IS NOT NULL UNION ALL SELECT S.PLAN_ID
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
, '_COMMON'
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, S.INVENTORY_ITEM_ID
, I.ITEM_NAME
, I.DESCRIPTION
FROM MSC_SYSTEM_ITEMS I
, MSC_SUPPLIES S
WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND S.PLAN_ID = I.PLAN_ID
AND S.PROJECT_ID IS NULL UNION ALL SELECT D.PLAN_ID
, D.ORGANIZATION_ID
, D.SR_INSTANCE_ID
, '_COMMON'
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, D.INVENTORY_ITEM_ID
, I.ITEM_NAME
, I.DESCRIPTION
FROM MSC_SYSTEM_ITEMS I
, MSC_DEMANDS D
WHERE D.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND D.ORGANIZATION_ID = I.ORGANIZATION_ID
AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND D.PLAN_ID = I.PLAN_ID
AND D.PROJECT_ID IS NULL

Columns