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.AMS_LIST_PURGE_PVT dependencies on AMS_QUERY_CONDITION

Line 986: DELETE from ams_query_condition_value value

982: DELETE from ams_list_rule_usages
983: WHERE list_header_id = p_id_tbl(i);
984:
985: FORALL i in 1 .. p_id_tbl.count
986: DELETE from ams_query_condition_value value
987: WHERE EXISTS (SELECT 1
988: FROM ams_query_temp_inst_cond_assoc assoc,
989: ams_query_template_instance inst
990: WHERE assoc.template_instance_id = inst.template_instance_id

Line 1013: UPDATE ams_query_condition cond

1009: WHERE qt.template_id = inst.template_id
1010: AND inst.instance_used_by_id is not null);
1011:
1012:
1013: UPDATE ams_query_condition cond
1014: SET condition_in_use_flag = 'N'
1015: WHERE NOT EXISTS (SELECT 1
1016: FROM ams_query_template_instance inst
1017: WHERE cond.template_id = inst.template_id