VIEW: APPS.GMS_BILL_AWARD_PROJECTS_V

Source

View Text - Preformatted

SELECT pa.project_id, pa.name, pa.segment1, gms.award_number, gms.award_short_name, gms.org_id from pa_projects_all pa, gms_awards gms WHERE pa.project_id=gms.award_project_id and PA_SECURITY.ALLOW_QUERY(pa.project_id) = 'Y' order by lower(pa.segment1)

View Text - HTML Formatted

SELECT PA.PROJECT_ID
, PA.NAME
, PA.SEGMENT1
, GMS.AWARD_NUMBER
, GMS.AWARD_SHORT_NAME
, GMS.ORG_ID
FROM PA_PROJECTS_ALL PA
, GMS_AWARDS GMS
WHERE PA.PROJECT_ID=GMS.AWARD_PROJECT_ID
AND PA_SECURITY.ALLOW_QUERY(PA.PROJECT_ID) = 'Y' ORDER BY LOWER(PA.SEGMENT1)