VIEW: APPS.MSC_PROJECT_TASK_ITEMS_TREE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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