[Home] [Help]
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
Name |
PROJECT_NUMBER |
PROJECT_NAME |
START_DATE |
COMPLETION_DATE |
PROJECT_ID |
INVENTORY_ORGANIZATION_ID |