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_EDIT_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 trunc(sysdate) between trunc(ppp.start_date_active) and nvl(trunc(ppp.end_date_active),trunc(sysdate)) 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 TRUNC(SYSDATE) BETWEEN TRUNC(ppp.start_date_active) AND TRUNC(NVL(ppp.end_date_active, SYSDATE))

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 TRUNC(SYSDATE) BETWEEN TRUNC(PPP.START_DATE_ACTIVE)
AND NVL(TRUNC(PPP.END_DATE_ACTIVE)
, TRUNC(SYSDATE)) 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 TRUNC(SYSDATE) BETWEEN TRUNC(PPP.START_DATE_ACTIVE)
AND TRUNC(NVL(PPP.END_DATE_ACTIVE
, SYSDATE))