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_ATP_24X7 dependencies on MSC_PLAN_ORGANIZATIONS

Line 1069: msc_plan_organizations mpo

1065: select max (md1.demand_id),
1066: md1.sr_instance_id
1067: from msc_demands md1,
1068: msc_plan_refreshes mpr,
1069: msc_plan_organizations mpo
1070: where md1.plan_id = p_old_plan_id
1071: and md1.origination_type in (6,30)
1072: and mpr.plan_id = p_new_plan_id
1073: and mpr.plan_id = mpo.plan_id

Line 1355: FROM msc_plan_organizations

1351: conc_log ('ATP Downtime Complete');
1352:
1353: SELECT so_lrn, sr_instance_id, organization_id
1354: BULK COLLECT INTO l_mpo_so_lrn, l_mpo_sr_instance_id, l_mpo_org_id
1355: FROM msc_plan_organizations
1356: WHERE plan_id = p_new_plan_id;
1357:
1358: -- CALL UI API HERE
1359: BEGIN

Line 1403: --Reset the value of msc_plan_organizations.so_lrn to msc_instance_orgs.so_lrn

1399:
1400: return;
1401: end if;
1402:
1403: --Reset the value of msc_plan_organizations.so_lrn to msc_instance_orgs.so_lrn
1404: --as it got changed during Plan Switch : Bug#8301235
1405: conc_debug ('Resetting the value of msc_plan_organizations.so_lrn...');
1406:
1407: FORALL j IN l_mpo_org_id.FIRST.. l_mpo_org_id.LAST

Line 1405: conc_debug ('Resetting the value of msc_plan_organizations.so_lrn...');

1401: end if;
1402:
1403: --Reset the value of msc_plan_organizations.so_lrn to msc_instance_orgs.so_lrn
1404: --as it got changed during Plan Switch : Bug#8301235
1405: conc_debug ('Resetting the value of msc_plan_organizations.so_lrn...');
1406:
1407: FORALL j IN l_mpo_org_id.FIRST.. l_mpo_org_id.LAST
1408: UPDATE msc_plan_organizations
1409: SET so_lrn = l_mpo_so_lrn(j)

Line 1408: UPDATE msc_plan_organizations

1404: --as it got changed during Plan Switch : Bug#8301235
1405: conc_debug ('Resetting the value of msc_plan_organizations.so_lrn...');
1406:
1407: FORALL j IN l_mpo_org_id.FIRST.. l_mpo_org_id.LAST
1408: UPDATE msc_plan_organizations
1409: SET so_lrn = l_mpo_so_lrn(j)
1410: WHERE sr_instance_id = l_mpo_sr_instance_id(j)
1411: AND organization_id = l_mpo_org_id(j)
1412: AND plan_id = p_new_plan_id;