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.FND_IMP_PKG dependencies on FND_IMP_MENU_DEP_SUMMARY3

Line 533: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

529: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
530: BEGIN
531: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
532: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
533: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
534: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
535: SELECT COUNT(*) INTO cnt from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
536: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
537: commit;

Line 534: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

530: BEGIN
531: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
532: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
533: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
534: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
535: SELECT COUNT(*) INTO cnt from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
536: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
537: commit;
538: SELECT COUNT(*) INTO cnt from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 591: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

587: delete from FND_IMP_AffectedFiles where patch_id = patch_id__ and snapshot_id = snapshot_id__;
588: delete from FND_IMP_DiagMap where patch_id = patch_id__ and snapshot_id = snapshot_id__;
589:
590: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
591: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
592: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
593:
594: -- Adding this from refresh1/refresh1M - Moved it to this stage from
595: -- first stage

Line 600: insert into fnd_imp_menu_dep_summary3 (select * from fnd_imp_menu_dep_summary3_vl where patch_id = patch_id__ and snapshot_id = snapshot_id__);

596: insert into FND_IMP_AffectedFiles (select * from FND_IMP_AffectedFiles_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);
597: insert into FND_IMP_DiagMap (select * from FND_IMP_DiagMap_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);
598:
599: insert into fnd_imp_menu_dep_summary2 (select * from fnd_imp_menu_dep_summary2_vl where patch_id = patch_id__ and snapshot_id = snapshot_id__);
600: insert into fnd_imp_menu_dep_summary3 (select * from fnd_imp_menu_dep_summary3_vl where patch_id = patch_id__ and snapshot_id = snapshot_id__);
601: insert into FND_IMP_PISummary
602: (select * from FND_IMP_PISummary_VL
603: where patch_id = patch_id__ and snapshot_id = snapshot_id__);
604: commit;