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.GCS_PURGE_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 215: gcs_cons_eng_run_dtls gcerd_outer,

211: p_run_entity_id IN NUMBER
212: ) IS
213: SELECT DISTINCT gcerd_outer.entry_id,gcerd_outer.child_entity_id,geh.entry_name,geh.description
214: FROM gcs_cons_eng_runs gcer_outer,
215: gcs_cons_eng_run_dtls gcerd_outer,
216: gcs_entry_headers geh
217: WHERE gcer_outer.run_name = gcerd_outer.run_name
218: AND gcer_outer.run_entity_id = gcerd_outer.consolidation_entity_id
219: AND gcerd_outer.entry_id = geh.entry_id

Line 227: gcs_cons_eng_run_dtls gcerd_inner

223: AND gcerd_outer.entry_id IS NOT NULL
224: AND NOT EXISTS (
225: SELECT 'X'
226: FROM gcs_cons_eng_runs gcer_inner,
227: gcs_cons_eng_run_dtls gcerd_inner
228: WHERE gcer_inner.most_recent_flag = 'Y'
229: AND gcer_inner.hierarchy_id = gcer_outer.hierarchy_id
230: AND gcer_inner.run_entity_id = gcer_outer.run_entity_id
231: AND gcer_inner.cal_period_id = gcer_outer.cal_period_id

Line 240: gcs_cons_eng_run_dtls gcerd_outer,

236: UNION ALL
237:
238: SELECT DISTINCT gcerd_outer.stat_entry_id,gcerd_outer.child_entity_id,geh.entry_name,geh.description
239: FROM gcs_cons_eng_runs gcer_outer,
240: gcs_cons_eng_run_dtls gcerd_outer,
241: gcs_entry_headers geh
242: WHERE gcer_outer.run_name = gcerd_outer.run_name
243: AND gcer_outer.run_entity_id = gcerd_outer.consolidation_entity_id
244: AND gcerd_outer.stat_entry_id = geh.entry_id

Line 252: gcs_cons_eng_run_dtls gcerd_inner

248: AND gcerd_outer.stat_entry_id IS NOT NULL
249: AND NOT EXISTS (
250: SELECT 'X'
251: FROM gcs_cons_eng_runs gcer_inner,
252: gcs_cons_eng_run_dtls gcerd_inner
253: WHERE gcer_inner.most_recent_flag = 'Y'
254: AND gcer_inner.hierarchy_id = gcer_outer.hierarchy_id
255: AND gcer_inner.run_entity_id = gcer_outer.run_entity_id
256: AND gcer_inner.cal_period_id = gcer_outer.cal_period_id

Line 415: DELETE FROM gcs_cons_eng_run_dtls gcerd

411: END LOOP; -- end of inner cursor(c_purge_entry) loop
412: CLOSE c_purge_entry;
413:
414: -- To purge the run detial information
415: DELETE FROM gcs_cons_eng_run_dtls gcerd
416: WHERE gcerd.run_name = l_purge_cons_entity_list(i).run_name
417: AND gcerd.consolidation_entity_id = l_purge_cons_entity_list(i).run_entity_id;
418:
419: -- To update the run information to PURGED.