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