View: AP_WEB_PA_PROJECTS_TASKS_V

Product:	AP - Payables
Description:	In Oracle Internet Expenses, both the view projects and Task Function and the Task Number List of Values are based on this view
Implementation/DBA Data:	APPS.AP_WEB_PA_PROJECTS_TASKS_V

View Text

SELECT DISTINCT P.PROJECT_ID
, P.PROJECT_NAME
, P.PROJECT_NUMBER
, P.PROJECT_DESCRIPTION
, P.PROJECT_TYPE
, P.START_DATE PROJECT_START_DATE
, P.COMPLETION_DATE PROJECT_COMPLETION_DATE
, P.CARRYING_OUT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, O.NAME PROJECT_ORGANIZATION_NAME
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.START_DATE TASK_START_DATE
, T.COMPLETION_DATE TASK_COMPLETION_DATE
, T.CHARGEABLE_FLAG
, DECODE(T.CHARGEABLE_FLAG
, 'Y'
, AP_WEB_FND_LOOKUPS_PKG.GETYESNOMEANING('Y')
, AP_WEB_FND_LOOKUPS_PKG.GETYESNOMEANING('N')) ALLOW_CHARGES
, GMS.AWARD_NUMBER
, GMS.AWARD_SHORT_NAME
, GMS.START_DATE AWARD_START_DATE
, GMS.CLOSE_DATE AWARD_CLOSE_DATE
, GMS.END_DATE AWARD_END_DATE
, GMS.AWARD_ORGANIZATION_NAME AWARD_ORGANIZATION_NAME FROM PA_TASKS_EXPEND_V T
, PA_PROJECTS_EXPEND_V P
, HR_ORGANIZATION_UNITS O
, GMS_SSA_AWARDS_V GMS
WHERE T.PROJECT_ID = P.PROJECT_ID
AND P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID
AND T.CHARGEABLE_FLAG = 'Y'
AND GMS.PROJECT_ID(+) = P.PROJECT_ID

Columns