View: PJM_PROJECTS_MTLL_PV

Product:	PJM - Project Manufacturing
Description:	Project only view for Project Locators
Implementation/DBA Data:	APPS.PJM_PROJECTS_MTLL_PV

View Text

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 ) )

Columns