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.AHL_FMP_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 4306: AHL_APPLICABLE_MR_RELNS REL

4302:
4303: -- delete MRs from relationships table to remove duplicates.
4304: DELETE AHL_APPLICABLE_MRS A
4305: WHERE EXISTS ( select 'x' FROM
4306: AHL_APPLICABLE_MR_RELNS REL
4307: WHERE REL.related_mr_header_id = A.mr_header_id
4308: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
4309:
4310: -- Delete corressponding records for the above deletes from relationships table.

Line 4311: DELETE AHL_APPLICABLE_MR_RELNS A

4307: WHERE REL.related_mr_header_id = A.mr_header_id
4308: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
4309:
4310: -- Delete corressponding records for the above deletes from relationships table.
4311: DELETE AHL_APPLICABLE_MR_RELNS A
4312: WHERE NOT EXISTS (SELECT 'x' FROM AHL_APPLICABLE_MRS B
4313: WHERE B.MR_HEADER_ID = A.ORIG_MR_HEADER_ID
4314: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
4315: