ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41DAA57978CCCF93E06362FB0905DD8A Project Number Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US 41BDA02E08772D95E06362FB0905F43FY SELECT distinct ppa.segment1 project_number , ppa.name project_name , papf.full_name , papf.employee_number , pprtt.meaning role , papp.start_date_active member_from , papp.end_date_active member_to , pprtb.start_date_active role_from , pprtb.end_date_active role_to , haou.name hr_org , ppa.project_type , pps.project_status_name project_status , pprtt.project_role_id , NVL (papf.email_address, 'n/a') email_address , NVL (pp.phone_number, 'n/a') telno_number , hla.description user_location , hla.location_code FROM pa.pa_project_parties papp , pa.pa_projects_all ppa , pa.pa_project_role_types_tl pprtt , pa.pa_project_role_types_b pprtb , pa.pa_project_statuses pps , hr.per_all_people_f papf , hr.per_all_assignments_f paaf , hr.hr_locations_all hla , hr.per_phones pp , hr.hr_all_organization_units haou WHERE ppa.project_id = papp.project_id AND papp.resource_source_id = papf.person_id AND PPRTT.PROJECT_ROLE_ID = PPRTB.PROJECT_ROLE_ID AND pprtt.project_role_id = papp.project_role_id AND ppa.project_status_code = pps.project_status_code AND papf.person_id = paaf.person_id AND paaf.location_id = hla.location_id(+) AND papf.person_id = pp.parent_id(+) AND ppa.carrying_out_organization_id = haou.organization_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND SYSDATE BETWEEN papp.start_date_active AND NVL (papp.end_date_active, SYSDATE) AND NVL (pp.date_to, SYSDATE + 1) > SYSDATE AND NVL (pp.phone_type, 'W1') = 'W1' AND pprtt.language = 'US' AND 1 = 1 --AND ppa.segment1 = :projectnum; --AND(:projectnum IS NULL OR ppa.segment1 LIKE :projectnum) --Order by ppa.segment1; --AND ppa.segment1 = :projectnum; AND(:projectnum IS NULL OR ppa.segment1 LIKE :projectnum) Order by ppa.segment1 US MDS Test Project Key Members Test Report of Key Members associated with a project 1=1 :projectnum 1 10 1=1 ppa.segment1=:project_number LOV Project Number 41DAA57978CCCF93E06362FB0905DD8A Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US Project