View: PJM_PROJECTS_MTLL_SV

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

View Text

SELECT S.PROJECT_ID
, S.PROJECT_NUMBER
, S.PROJECT_NAME
, S.PROJECT_NAME
, S.PROJECT_NUMBER
, TO_DATE(NULL)
, TO_DATE(NULL)
FROM PJM_SEIBAN_NUMBERS S
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 = S.PROJECT_ID ) )

Columns