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.

APPS.GMS_WF_PKG dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 2863: FROM gms_status_commitments_v gscv ,gms_summary_project_fundings gmpf

2859: ,p_installment_end_date DATE ) IS
2860: SELECT gscv.commitment_number
2861: ,gscv.document_type
2862: ,SUM(gscv.burdened_cost)
2863: FROM gms_status_commitments_v gscv ,gms_summary_project_fundings gmpf
2864: WHERE gmpf.installment_id = p_installment_id
2865: AND gscv.award_id = p_award_id
2866: AND gscv.project_id = gmpf.project_id
2867: AND gscv.task_id = nvl(gmpf.task_id,gscv.task_id)

Line 2896: FROM gms_summary_project_fundings gmpf

2892: )
2893: FROM gms_commitment_encumbered_v cmt
2894: WHERE cmt.award_id = p_award_id
2895: AND (cmt.project_id,cmt.task_id) IN (SELECT gmpf.project_id,nvl(gmpf.task_id,cmt.task_id)
2896: FROM gms_summary_project_fundings gmpf
2897: WHERE gmpf.installment_id =p_installment_id )
2898: AND cmt.expenditure_item_date BETWEEN p_installment_start_date AND p_installment_end_date
2899: AND cmt.document_type IN ('AP','PO','REQ')
2900: GROUP BY document_type , cmt.project_id , cmt.task_id , cmt.award_id , cmt.cmt_number ;