View: PA_PROJECTS_UPDATE_V

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

View Text

SELECT P.ORG_ID
, P.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE
, NVL(P.TEMPLATE_FLAG
, 'N') TEMPLATE_FLAG
, P.INVPROC_CURRENCY_TYPE
, P.REVPROC_CURRENCY_CODE
, P.PROJECT_CURRENCY_CODE
, P.PROJECT_BIL_RATE_DATE_CODE
, P.PROJECT_BIL_RATE_TYPE
, P.PROJECT_BIL_RATE_DATE
, P.PROJECT_BIL_EXCHANGE_RATE
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_BIL_RATE_DATE_CODE
, P.PROJFUNC_BIL_RATE_TYPE
, P.PROJFUNC_BIL_RATE_DATE
, P.PROJFUNC_BIL_EXCHANGE_RATE
, P.FUNDING_RATE_DATE_CODE
, P.FUNDING_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, P.BASELINE_FUNDING_FLAG
, P.MULTI_CURRENCY_BILLING_FLAG
, NVL(PT.CC_PRVDR_FLAG
, 'N') CC_PRVDR_FLAG
, P.PROJECT_STATUS_CODE
FROM PA_PROJECT_TYPES PT
, PA_PROJECTS_ALL P
WHERE 'Y' IN (SELECT PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID)
FROM SYS.DUAL)
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID

Columns