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.

VIEW: APPS.PA_PROJ_PARTIES_PROG_EV_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)