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_SR_ASSIGNMENTS

Line 745: from msc_sr_assignments msa,

741: IF (lv_launch_refresh_gf = FALSE) THEN
742: l_latest_change_date := NULL;
743: BEGIN
744: select max(msa.last_update_date) into l_latest_change_date
745: from msc_sr_assignments msa,
746: msc_plans mp
747: where mp.plan_id = p_plan_id
748: and mp.FORECAST_ASSIGNMENT_SET_ID = msa.assignment_set_id;
749: EXCEPTION WHEN OTHERS THEN

Line 765: msc_sr_assignments msra,

761: l_latest_change_date := NULL;
762: BEGIN
763: select max(msr.last_update_date) into l_latest_change_date
764: from msc_sourcing_rules msr,
765: msc_sr_assignments msra,
766: msc_plans mp
767: where mp.plan_id = p_plan_id
768: and mp.FORECAST_ASSIGNMENT_SET_ID = msra.ASSIGNMENT_SET_ID
769: and msra.sourcing_rule_id = msr.sourcing_rule_id;

Line 1169: from msc_sr_assignments msa,

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,
1170: msc_plans mp
1171: where msa.assignment_type in (7,8,9)
1172: and mp.plan_id = p_plan_id
1173: and msa.assignment_set_id = mp.curr_assignment_set_id

Line 1195: from msc_sr_assignments msa,

1191: and b.sr_instance_id = c.sr_instance_id
1192: and c.region_id is not null
1193: and c.location_source = 'HZ'
1194: and a.region_id in ( select distinct msa.region_id
1195: from msc_sr_assignments msa,
1196: msc_plans mp
1197: where msa.assignment_type in (7,8,9)
1198: and mp.plan_id = p_plan_id
1199: and msa.assignment_set_id = mp.curr_assignment_set_id