APPS.MSC_SNAPSHOT_PK dependencies on MSC_REGIONS

Line 1183: FROM MSC_REGIONS a,

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