SELECT P.PROJECT_ID , P.PROJECT_NUMBER , P.PROJECT_NAME , P.PROJECT_DESCRIPTION , P.PROJECT_NUMBER_SORT_ORDER , P.START_DATE , P.COMPLETION_DATE FROM PA_PROJECTS_ALL_BASIC_V P WHERE ( FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') IS NULL OR EXISTS ( SELECT 1 FROM PJM_PROJECT_PARAMETERS PPP , PJM_ORG_PARAMETERS POP WHERE POP.ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') AND POP.PROJECT_REFERENCE_ENABLED = 'Y' AND PPP.ORGANIZATION_ID = POP.ORGANIZATION_ID AND PPP.PROJECT_ID = P.PROJECT_ID ) )