View: GMS_PQH_EXP_TYPES_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_PQH_EXP_TYPES_V

View Text

SELECT PET.EXPENDITURE_TYPE
, T.PROJECT_ID
, T.TASK_ID
, GA.AWARD_ID
, PET.EXPND_TYP_START_DATE_ACTIVE
, PET.EXPND_TYP_END_DATE_ACTIVE
, GA.ORG_ID
FROM PA_EXPENDITURE_TYPES_EXPEND_V PET
, GMS_ALLOWABLE_EXPENDITURES GAE
, GMS_AWARDS GA
, GMS_PROJECT_TYPES GPT
, PA_PROJECTS_ALL P
, PA_TASKS T
WHERE T.PROJECT_ID = P.PROJECT_ID
AND P.PROJECT_TYPE=GPT.PROJECT_TYPE
AND GPT.SPONSORED_FLAG ='Y'
AND GAE.EXPENDITURE_TYPE=PET.EXPENDITURE_TYPE
AND PET.SYSTEM_LINKAGE_FUNCTION = 'PJ'
AND GAE.ALLOWABILITY_SCHEDULE_ID= GA.ALLOWABLE_SCHEDULE_ID

Columns