VIEW: APPS.MSC_PHUB_PROJECTS_MV#

Source

View Text - Preformatted

select         p.project_id,         p.sr_instance_id,         p.organization_id,         p.project_name,         p.project_number,         p.project_description,         p.planning_group,         nvl(t.task_id, -23453) task_id,         t.task_name,         t.task_number     from         msc_projects p,         msc_project_tasks t     where p.project_id=t.project_id(+)         and p.sr_instance_id=t.sr_instance_id(+)         and p.organization_id=t.organization_id(+)         and p.plan_id=t.plan_id(+)         and p.plan_id=-1     union all     select distinct         -23453 project_id, mtp.sr_instance_id, mtp.sr_tp_id,         to_char(null) project_name,         null project_number,         to_char(null) project_description,         to_char(null) planning_group,         -23453 task_id,         to_char(null) task_name,         null task_number     from msc_trading_partners mtp     where partner_type=3

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, P.PROJECT_NAME
, P.PROJECT_NUMBER
, P.PROJECT_DESCRIPTION
, P.PLANNING_GROUP
, NVL(T.TASK_ID
, -23453) TASK_ID
, T.TASK_NAME
, T.TASK_NUMBER
FROM MSC_PROJECTS P
, MSC_PROJECT_TASKS T
WHERE P.PROJECT_ID=T.PROJECT_ID(+)
AND P.SR_INSTANCE_ID=T.SR_INSTANCE_ID(+)
AND P.ORGANIZATION_ID=T.ORGANIZATION_ID(+)
AND P.PLAN_ID=T.PLAN_ID(+)
AND P.PLAN_ID=-1 UNION ALL SELECT DISTINCT -23453 PROJECT_ID
, MTP.SR_INSTANCE_ID
, MTP.SR_TP_ID
, TO_CHAR(NULL) PROJECT_NAME
, NULL PROJECT_NUMBER
, TO_CHAR(NULL) PROJECT_DESCRIPTION
, TO_CHAR(NULL) PLANNING_GROUP
, -23453 TASK_ID
, TO_CHAR(NULL) TASK_NAME
, NULL TASK_NUMBER
FROM MSC_TRADING_PARTNERS MTP
WHERE PARTNER_TYPE=3