[Home] [Help]
View: PA_ONLINE_PROJECTS_V
Product: | PA - Projects |
Description: | Customizable view for projects used in Self Service Time application.
PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application |
Implementation/DBA Data: |
APPS.PA_ONLINE_PROJECTS_V
|
View Text
SELECT DISTINCT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, PROJECT_TYPE
, START_DATE
, COMPLETION_DATE
, CARRYING_OUT_ORGANIZATION_ID
, (SELECT NAME
FROM HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = CARRYING_OUT_ORGANIZATION_ID) CARRYING_OUT_ORGANIZATION_NAME
FROM PA_PROJECTS_EXPEND_V
Columns
Name |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_ID |
PROJECT_TYPE |
START_DATE |
COMPLETION_DATE |
CARRYING_OUT_ORGANIZATION_ID |
CARRYING_OUT_ORGANIZATION_NAME |