VIEW: APPS.AP_WEB_PA_PROJECTS_TASKS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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