APPS.MSC_SNAPSHOT_PK dependencies on MSC_REGIONS

Line 1181: FROM MSC_REGIONS a,

1177: ((10 * (10 - a.zone_level)) + 1) REGION_TYPE,
1178: c.PARENT_REGION_FLAG,
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