[Home] [Help]
View: PA_PROJ_PARTIES_PROG_EV_V
View Text
SELECT PPP.PROJECT_PARTY_ID
, PPP.PROJECT_ID
, PPP.RESOURCE_ID
, 101
, PPP.RESOURCE_SOURCE_ID
, PE.FULL_NAME
, PPP.PROJECT_ROLE_ID
, PPRT.PROJECT_ROLE_TYPE
, PPRT.MEANING
, PPP.START_DATE_ACTIVE
, PPP.END_DATE_ACTIVE
FROM PA_PROJECT_PARTIES PPP
, PA_PROJECT_ROLE_TYPES PPRT
, PA_EMPLOYEES PE
WHERE PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
AND PPP.RESOURCE_TYPE_ID = 101
AND PPP.RESOURCE_SOURCE_ID = PE.PERSON_ID
AND PE.ACTIVE = '*'
AND PPRT.MENU_ID IN (SELECT F1.MENU_ID
FROM FND_COMPILED_MENU_FUNCTIONS F1
, FND_FORM_FUNCTIONS F2
WHERE (F2.FUNCTION_NAME = 'PA_PROGRESS_REPORT_VIEW' OR F2.FUNCTION_NAME = 'PA_PROGRESS_REPORT_EDIT')
AND F2.FUNCTION_ID = F1.FUNCTION_ID) UNION ALL SELECT PPP.PROJECT_PARTY_ID
, PPP.PROJECT_ID
, PPP.RESOURCE_ID
, 112
, PPP.RESOURCE_SOURCE_ID
, HZP.PARTY_NAME
, PPP.PROJECT_ROLE_ID
, PPRT.PROJECT_ROLE_TYPE
, PPRT.MEANING
, PPP.START_DATE_ACTIVE
, PPP.END_DATE_ACTIVE
FROM PA_PROJECT_PARTIES PPP
, PA_PROJECT_ROLE_TYPES PPRT
, HZ_PARTIES HZP
WHERE PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
AND PPP.RESOURCE_TYPE_ID = 112
AND PPP.RESOURCE_SOURCE_ID = HZP.PARTY_ID
AND PPRT.MENU_ID IN (SELECT F1.MENU_ID
FROM FND_COMPILED_MENU_FUNCTIONS F1
, FND_FORM_FUNCTIONS F2
WHERE (F2.FUNCTION_NAME = 'PA_PROGRESS_REPORT_VIEW' OR F2.FUNCTION_NAME = 'PA_PROGRESS_REPORT_EDIT')
AND F2.FUNCTION_ID = F1.FUNCTION_ID)
Columns
Name |
PROJECT_PARTY_ID |
PROJECT_ID |
RESOURCE_ID |
RESOURCE_TYPE_ID |
RESOURCE_SOURCE_ID |
RESOURCE_SOURCE_NAME |
PROJECT_ROLE_ID |
PROJECT_ROLE_TYPE |
PROJECT_ROLE_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |