Product: | IGW - Grants Proposal |
---|---|
Description: | View displays details of the proposal's Administrative Official |
Implementation/DBA Data: | APPS.IGW_ADMIN_OFFICIAL_V |
SELECT PA.PROPOSAL_ID
, PA.PROPOSAL_NUMBER
, PA.LEAD_ORGANIZATION_ID
, AP.PERSON_ID
, AP.FULL_NAME
, AP.LAST_NAME
, AP.FIRST_NAME
, AP.MIDDLE_NAMES
, AP.TITLE
, AP.PRE_NAME_ADJUNCT
, AP.SUFFIX
, AP.LAST_NAME||DECODE(AP.FIRST_NAME
, NULL
, NULL
, '
, ' ||AP.FIRST_NAME)||DECODE(AP.MIDDLE_NAMES
, NULL
, NULL
, ' ' ||AP.MIDDLE_NAMES)
, AP.FIRST_NAME||DECODE(AP.MIDDLE_NAMES
, NULL
, NULL
, ' ' ||MIDDLE_NAMES)||' '||AP.LAST_NAME||DECODE(SUFFIX
, NULL
, NULL
, ' ' ||SUFFIX) FIRST_MIDDLE_LAST_NAME
, IGW_REPORT_PROCESSING.GET_JOB_NAME(AP.PERSON_ID) LAST_FIRST_MIDDLE_NAME
, LOC.ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3
, LOC.POSTAL_CODE
, LOC.REGION_1
, LOC.REGION_2
, LOC.REGION_3
, LOC.TOWN_OR_CITY
, LOC.COUNTRY
, IGW_REPORT_PROCESSING.GET_PHONE_NUMBER(AP.PERSON_ID
, 'WF')
, IGW_REPORT_PROCESSING.GET_PHONE_NUMBER(AP.PERSON_ID
, 'W1')
, AP.EMAIL_ADDRESS
FROM IGW_PROPOSALS_ALL PA
, PER_PEOPLE_X AP
, PER_ASSIGNMENTS_X ASG
, HR_LOCATIONS LOC
WHERE PA.ADMIN_OFFICIAL_ID = AP.PERSON_ID
AND AP.PERSON_ID = ASG.PERSON_ID(+)
AND ASG.PRIMARY_FLAG(+) = 'Y'
AND ASG.LOCATION_ID = LOC.LOCATION_ID(+)