DBA Data[Home] [Help]

VIEW: APPS.PJM_PROJECT_PROJ_BASIC_V

Source

View Text - Preformatted

SELECT P.PROJECT_ID , P.SEGMENT1 , P.NAME FROM PA_PROJECTS_ALL P UNION ALL SELECT S.PROJECT_ID , S.PROJECT_NUMBER , S.PROJECT_NAME FROM PJM_SEIBAN_NUMBERS S
View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
FROM PA_PROJECTS_ALL P UNION ALL SELECT S.PROJECT_ID
, S.PROJECT_NUMBER
, S.PROJECT_NAME
FROM PJM_SEIBAN_NUMBERS S