VIEW: APPS.PA_PO_PROJECTS_EXPEND_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'