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 3342: AHL_APPLICABLE_MR_RELNS REL

3338:
3339: -- delete MRs from relationships table to remove duplicates.
3340: DELETE AHL_APPLICABLE_MRS A
3341: WHERE EXISTS ( select 'x' FROM
3342: AHL_APPLICABLE_MR_RELNS REL
3343: WHERE REL.related_mr_header_id = A.mr_header_id
3344: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
3345:
3346: -- Delete corressponding records for the above deletes from relationships table.

Line 3347: DELETE AHL_APPLICABLE_MR_RELNS A

3343: WHERE REL.related_mr_header_id = A.mr_header_id
3344: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
3345:
3346: -- Delete corressponding records for the above deletes from relationships table.
3347: DELETE AHL_APPLICABLE_MR_RELNS A
3348: WHERE NOT EXISTS (SELECT 'x' FROM AHL_APPLICABLE_MRS B
3349: WHERE B.MR_HEADER_ID = A.ORIG_MR_HEADER_ID
3350: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
3351: