View: POR_PROJECT_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Projects
Implementation/DBA Data:	APPS.POR_PROJECT_LOV_V

View Text

SELECT PROJECT_NUMBER
, PROJECT_NAME
, START_DATE
, COMPLETION_DATE
, PROJECT_ID
, -9999
FROM PA_PROJECTS_EXPEND_V PPE UNION (SELECT M.PROJECT_NUMBER
, M.PROJECT_NAME
, M.START_DATE
, M.COMPLETION_DATE
, M.PROJECT_ID
, P.ORGANIZATION_ID "INVENTORY_ORGANIZATION_ID"
FROM MTL_PROJECT_V M
, PJM_PROJECT_PARAMETERS P
, MTL_PARAMETERS MP
WHERE M.PROJECT_ID = P.PROJECT_ID
AND MP.ORGANIZATION_ID = P.ORGANIZATION_ID
AND MP.PROJECT_REFERENCE_ENABLED= 1)

Columns