eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMS_PQH_EXP_TYPES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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