VIEW: APPS.PAFV_PROJECTS

Source

View Text - Preformatted

SELECT ppa.project_id , pps.project_status_name , ppa.name , ppa.segment1 , ppa.description , ppa.start_date , ppa.completion_date , ppa.closed_date , '_LA:wf_status_code:PA_LOOKUPS:WF_STATUS_CODE:MEANING' , '_LA:pm_product_code:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING' , ppa.pm_project_reference , '_LA:public_sector_flag:FND_LOOKUPS:YES_NO:MEANING' , pdr.distribution_rule,pdr.meaning , '_DF:PA:PA_PROJECTS_DESC_FLEX:ppa' , '_LA:template_flag:FND_LOOKUPS:YES_NO:MEANING' , ppa.carrying_out_organization_id , pou.name , ppa.project_type , ppt.description , ppa.org_id , t2.name , ppa.LAST_UPDATE_DATE , ppa.LAST_UPDATED_BY , ppa.CREATION_DATE , ppa.CREATED_BY FROM pa_projects_all ppa , pa_project_types_all ppt , hr_all_organization_units pou , hr_all_organization_units_tl t2 , pa_distribution_rules pdr , pa_project_statuses pps WHERE ppa.project_type = ppt.project_type and NVL(ppa.org_id,-99) = NVL(ppt.org_id,-99) and pdr.distribution_rule(+) = ppa.distribution_rule and ppa.project_status_code = pps.project_status_code and ppa.carrying_out_organization_id = pou.organization_id and ppa.org_id=t2.organization_id(+) and t2.language(+) = userenv('LANG') and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPS.PROJECT_STATUS_NAME
, PPA.NAME
, PPA.SEGMENT1
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, '_LA:WF_STATUS_CODE:PA_LOOKUPS:WF_STATUS_CODE:MEANING'
, '_LA:PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
, PPA.PM_PROJECT_REFERENCE
, '_LA:PUBLIC_SECTOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PDR.DISTRIBUTION_RULE
, PDR.MEANING
, '_DF:PA:PA_PROJECTS_DESC_FLEX:PPA'
, '_LA:TEMPLATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.CARRYING_OUT_ORGANIZATION_ID
, POU.NAME
, PPA.PROJECT_TYPE
, PPT.DESCRIPTION
, PPA.ORG_ID
, T2.NAME
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES_ALL PPT
, HR_ALL_ORGANIZATION_UNITS POU
, HR_ALL_ORGANIZATION_UNITS_TL T2
, PA_DISTRIBUTION_RULES PDR
, PA_PROJECT_STATUSES PPS
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND NVL(PPA.ORG_ID
, -99) = NVL(PPT.ORG_ID
, -99)
AND PDR.DISTRIBUTION_RULE(+) = PPA.DISTRIBUTION_RULE
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.CARRYING_OUT_ORGANIZATION_ID = POU.ORGANIZATION_ID
AND PPA.ORG_ID=T2.ORGANIZATION_ID(+)
AND T2.LANGUAGE(+) = USERENV('LANG')
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY