VIEW: APPS.PA_ALLOC_SRC_PROJECTS_V

Source

View Text - Preformatted

SELECT pap.project_id ,pap.segment1 ,pap.name ,pap.project_type ,pap.carrying_out_organization_id ,ppc.class_category ,ppc.class_code ,pap.org_id from pa_projects pap ,pa_project_classes ppc WHERE ppc.project_id(+) = pap.project_id and pap.template_flag <> 'Y' and pa_project_stus_utils.is_project_closed(pap.project_id) = 'N'

View Text - HTML Formatted

SELECT PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PAP.PROJECT_TYPE
, PAP.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PAP.ORG_ID
FROM PA_PROJECTS PAP
, PA_PROJECT_CLASSES PPC
WHERE PPC.PROJECT_ID(+) = PAP.PROJECT_ID
AND PAP.TEMPLATE_FLAG <> 'Y'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_CLOSED(PAP.PROJECT_ID) = 'N'