[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 |