VIEW: APPS.PA_PROJECTS_UPDATE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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