View: AP_WEB_PA_PROJECTS_V

Product:	AP - Payables
Description:	The Project number list of values in Oracle Internet Expenses is based on this view
Implementation/DBA Data:	APPS.AP_WEB_PA_PROJECTS_V

View Text

SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, START_DATE
, COMPLETION_DATE
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, O.NAME PROJECT_ORGANIZATION_NAME
, PROJECT_TYPE_CLASS_CODE FROM PA_PROJECTS_EXPEND_V P
, HR_ORGANIZATION_UNITS O
WHERE P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID

Columns