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.MSC_SNAPSHOT_PK dependencies on MSC_REGION_LOCATIONS

Line 1163: FROM MSC_REGION_LOCATIONS

1159: (10 * (10 - region_type)) REGION_TYPE ,
1160: PARENT_REGION_FLAG ,
1161: SR_INSTANCE_ID,
1162: 2 partner_type
1163: FROM MSC_REGION_LOCATIONS
1164: WHERE location_source = 'HZ'
1165: and region_id is not null
1166: and region_id in ( select distinct msa.region_id
1167: from msc_sr_assignments msa,

Line 1183: msc_region_locations c

1179: a.SR_INSTANCE_ID,
1180: 2 PARTNER_TYPE
1181: FROM MSC_REGIONS a,
1182: MSC_ZONE_REGIONS b,
1183: msc_region_locations c
1184: WHERE a.region_id = b.parent_region_id
1185: AND a.region_type = 10
1186: AND a.zone_level IS NOT NULL
1187: AND a.sr_instance_id = b.sr_instance_id