[Home] [Help]
View: PA_PM_REFERENCE_V
Product: | PA - Projects |
Description: | Oracle Projects identifiers and external project management system references |
Implementation/DBA Data: |
APPS.PA_PM_REFERENCE_V
|
View Text
SELECT P.ORG_ID
, P.PROJECT_ID
, P.PM_PROJECT_REFERENCE
, P.PM_PRODUCT_CODE
, P.DESCRIPTION
, P.START_DATE
, P.COMPLETION_DATE
, P.PROJECT_STATUS_CODE
, T.TASK_ID
, T.PARENT_TASK_ID
, T.TOP_TASK_ID
, T.TASK_NUMBER
, T.PM_TASK_REFERENCE
, T.START_DATE
, T.COMPLETION_DATE
, T.SERVICE_TYPE_CODE
, T.CHARGEABLE_FLAG
, T.BILLABLE_FLAG
FROM PA_TASKS T
, PA_PROJECTS P
WHERE P.PROJECT_ID = T.PROJECT_ID
Columns
Name |
ORG_ID |
PROJECT_ID |
PM_PROJECT_REFERENCE |
PM_PRODUCT_CODE |
DESCRIPTION |
PROJECT_START_DATE |
PROJECT_COMPLETION_DATE |
PROJECT_STATUS_CODE |
TASK_ID |
PARENT_TASK_ID |
TOP_TASK_ID |
TASK_NUMBER |
PM_TASK_REFERENCE |
TASK_START_DATE |
TASK_COMPLETION_DATE |
SERVICE_TYPE_CODE |
CHARGEABLE_FLAG |
BILLABLE_FLAG |