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 1165: FROM MSC_REGION_LOCATIONS

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

Line 1185: msc_region_locations c

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