eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_PROJECTS_BASIC_V

Product:	PA - Projects
Description:	10SC Only - Retrofitted
Implementation/DBA Data:	APPS.PA_PROJECTS_BASIC_V

View Text

SELECT P.ORG_ID
, P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.LONG_NAME
, POU.OPERATING_UNIT
, PT.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_STATUS_CODE
, NVL(P.TEMPLATE_FLAG
, 'N')
, P.PM_PROJECT_REFERENCE
, P.SEGMENT1
, P.PROJECT_CURRENCY_CODE
, PT.CC_PRVDR_FLAG
, P.BASELINE_FUNDING_FLAG
, P.REVALUATE_FUNDING_FLAG
FROM PA_PROJECT_TYPES PT
, PA_PROJECTS_ALL P
, PA_OPERATING_UNITS_V POU
WHERE 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
FROM SYS.DUAL)
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE <> 'AWARD_PROJECT'
AND PT.ORG_ID = P.ORG_ID
AND POU.ORG_ID = P.ORG_ID

Columns

Name
ORG_ID
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
LONG_NAME
OPERATING_UNIT
PROJECT_TYPE_CLASS_CODE
PROJECT_STATUS_CODE
TEMPLATE_FLAG
PM_PROJECT_REFERENCE
PROJECT_NUMBER_SORT_ORDER
PROJECT_CURRENCY_CODE
CC_PRVDR_FLAG
BASELINE_FUNDING_FLAG
REVALUATE_FUNDING_FLAG