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.GME_GANTT_RSRC_PKG dependencies on GME_RESOURCE_TXNS_SUMMARY

Line 271: * with GME_RESOURCE_TXNS_SUMMARY table.

267: * is retrieved from this new table, replacing the
268: * GME_BATCH_STEP_RESOURCES table.
269: * 10OCT02 Eddie Oumerretane.
270: * Bug # 2565952 Replaced table GME_BATCH_STEP_RSRC_SUMMARY
271: * with GME_RESOURCE_TXNS_SUMMARY table.
272: */
273: PROCEDURE fetch_resource_load (
274: p_resource_code IN OUT NOCOPY VARCHAR2
275: ,p_organization_id IN NUMBER

Line 296: FROM gme_resource_txns_summary

292: CURSOR rsrc_load
293: IS
294: SELECT start_date from_date, end_date end_DATE
295: ,SUM (required_units) rsrc_count
296: FROM gme_resource_txns_summary
297: WHERE resource_id = l_resource_id
298: AND start_date >= p_from_date
299: AND start_date <= p_to_date
300: GROUP BY start_date, end_date

Line 304: FROM gme_resource_txns_summary

300: GROUP BY start_date, end_date
301: UNION
302: SELECT start_date from_date, end_date end_DATE
303: ,SUM (required_units) rsrc_count
304: FROM gme_resource_txns_summary
305: WHERE resource_id = l_resource_id
306: AND end_date >= p_from_date
307: AND start_date <= p_to_date
308: GROUP BY start_date, end_date