eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_AP_PROJECT_TASKS_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPP.ORGANIZATION_ID
, PPP.PROJECT_ID
, PT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PT.DESCRIPTION
, PAPF.FULL_NAME MANAGER
, PT.START_DATE
, PT.END_DATE
, PPP.RN RN3
, PT.RN RN2
, MP.RN RN1
FROM PER_ALL_PEOPLE_F PAPF
, MRP_AP_TASKS_SN PT
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_PRJ_PARAS_SN PPP
WHERE PAPF.PERSON_ID(+)= PT.TASK_MANAGER_PERSON_ID
AND PT.PROJECT_ID= PPP.PROJECT_ID
AND PPP.ORGANIZATION_ID= MP.ORGANIZATION_ID

Columns

Name
ORGANIZATION_ID
PROJECT_ID
TASK_ID
TASK_NUMBER
TASK_NAME
DESCRIPTION
MANAGER
START_DATE
END_DATE
RN3
RN2
RN1