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 743: from msc_sr_assignments msa,

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

Line 763: msc_sr_assignments msra,

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

Line 1167: from msc_sr_assignments msa,

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

Line 1193: from msc_sr_assignments msa,

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