View: PA_PO_PROJECTS_EXPEND_V

Product:	PA - Projects
Description:	PA_PO_PROJECTS_EXPEND_V shows the projects included in the list of values for expenditure entry from PO.
Implementation/DBA Data:	APPS.PA_PO_PROJECTS_EXPEND_V

View Text

SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, START_DATE
, COMPLETION_DATE
, PROJECT_TYPE_CLASS_CODE
, PROJECT_NUMBER_SORT_ORDER
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_OU
, EXPENDITURE_OU
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, PROJECT_STATUS_CODE
, OPERATING_UNIT
FROM PA_PROJECTS_EXPEND_V P
WHERE PA_PO_INTEGRATION_UTILS.PA_USER_PO_ACCESS_PROJ(PROJECT_ID
, FND_GLOBAL.USER_ID) <> 'N'

Columns