VIEW: APPS.IGW_ADMIN_OFFICIAL_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)