DBA Data[Home] [Help]

VIEW: APPS.HXT_ALL_PROJECTS_V

Source

View Text - Preformatted

SELECT ppa.PROJECT_ID, ppa.NAME PROJECT_NAME, ppa.SEGMENT1 PROJECT_NUMBER, ppa.CARRYING_OUT_ORGANIZATION_ID, ppa.START_DATE, ppa.COMPLETION_DATE FROM PA_PROJECTS_ALL ppa
View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME PROJECT_NAME
, PPA.SEGMENT1 PROJECT_NUMBER
, PPA.CARRYING_OUT_ORGANIZATION_ID
, PPA.START_DATE
, PPA.COMPLETION_DATE
FROM PA_PROJECTS_ALL PPA