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.PSP_XMLGEN dependencies on GMS_AWARDS_ALL

Line 1760: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

1756: AND paaf.assignment_number is not null -- Bug 8540341
1757: AND ROWNUM = 1),
1758: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1759: WHERE paa.project_id = perd.project_id),
1760: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1761: WHERE gaa.award_id = perd.award_id),
1762: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug : 16391366
1763: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1764: WHERE haou.organization_id = perd.expenditure_organization_id),

Line 1819: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

1815: AND paaf.assignment_number is not null -- Bug 8540341
1816: AND ROWNUM = 1),
1817: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1818: WHERE paa.project_id = perd.project_id),
1819: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1820: WHERE gaa.award_id = perd.award_id),
1821: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1822: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1823: WHERE haou.organization_id = perd.expenditure_organization_id),

Line 1853: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

1849: AND paaf.assignment_number is not null -- Bug 8540341
1850: AND ROWNUM = 1),
1851: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1852: WHERE paa.project_id = perd.project_id),
1853: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1854: WHERE gaa.award_id = perd.award_id),
1855: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1856: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1857: WHERE haou.organization_id = perd.expenditure_organization_id),

Line 1888: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

1884: AND paaf.assignment_number is not null -- Bug 8540341
1885: AND ROWNUM = 1),
1886: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1887: WHERE paa.project_id = perd.project_id),
1888: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1889: WHERE gaa.award_id = perd.award_id),
1890: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1891: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1892: WHERE haou.organization_id = perd.expenditure_organization_id),