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_NETCHANGE_PKG dependencies on MSC_PLANS

Line 300: from msc_plans mp,

296: decode(mp.CURR_HARD_PEGGING_LEVEL, --3
297: 1,g_misc(2), -- 'Project',
298: 2, g_misc(3), --'Project-Task',
299: 3, g_misc(4)) --'None')
300: from msc_plans mp,
301: mfg_lookups ml,
302: msc_assignment_sets mas
303: where mp.plan_id = p_plan_id
304: and ml.lookup_type = 'MRP_PLAN_TYPE'

Line 442: from msc_plans mp

438: 2,g_misc(22))||', '|| -- 'BOR') ||','||
439: decode(mp.PERIOD_RTG_AGGREGATION_LEVEL,
440: 1,g_misc(22), --'Routings',
441: 2,g_misc(22)) -- 'BOR')
442: from msc_plans mp
443: where mp.plan_id = p_plan_id;
444:
445: TYPE CharTab IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
446: plan_a_rec CharTab;

Line 518: from msc_plans mp

514: mp.SUPPLIER_CAP_OVER_UTIL_COST,
515: mp.TRANSPORT_CAP_OVER_UTIL_COST,
516: mp.RESOURCE_OVER_UTIL_COST,
517: mp.DMD_LATENESS_PENALTY_COST -- end optimize
518: from msc_plans mp
519: where mp.plan_id = p_plan_id;
520:
521:
522: TYPE CharTab IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 629: from msc_plans mp

625: decode(mp.CURR_PLANNED_RESOURCES,
626: 1, g_misc(11), -- 'All Resources',
627: 2, g_misc(12)), --'Bottleneck Resources'),
628: mp.CURR_BOTTLENECK_RES_GROUP
629: from msc_plans mp
630: where mp.plan_id = p_plan_id;
631: TYPE CharTab IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
632: plan_a_rec CharTab;
633: plan_b_rec CharTab;

Line 717: from msc_plans mp

713: nvl(decode(mp.USE_ALTERNATE_RESOURCES,1,g_yes,g_no),g_no),
714: nvl(decode(mp.USE_SUBSTITUTE_COMPONENTS,1,g_yes,g_no),g_no),
715: nvl(decode(mp.USE_ALTERNATE_BOM_ROUTING,1,g_yes,g_no),g_no),
716: nvl(decode(mp.USE_ALTERNATE_SOURCES,1,g_yes,g_no),g_no)
717: from msc_plans mp
718: where mp.plan_id = p_plan_id;
719:
720: TYPE CharTab IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
721: plan_a_rec CharTab;

Line 814: msc_plans mp

810: , nvl(decode(MPO.INCLUDE_SALESORDER,1,g_yes,g_no),g_no)
811: FROM
812: MSC_TRADING_PARTNERS PT,
813: MSC_PLAN_ORGANIZATIONS MPO,
814: msc_plans mp
815: where MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
816: AND MPO.ORGANIZATION_ID = PT.SR_TP_ID
817: AND PT.partner_type =3
818: and mp.plan_id = mpo.plan_id

Line 873: msc_plans mp

869: , nvl(decode(MPO.INCLUDE_SALESORDER,1,g_yes,g_no),g_no)
870: FROM
871: MSC_TRADING_PARTNERS PT,
872: MSC_PLAN_ORGANIZATIONS MPO,
873: msc_plans mp
874: where MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
875: AND MPO.ORGANIZATION_ID = PT.SR_TP_ID
876: AND PT.partner_type =3
877: and mpo.plan_id = g_to_plan

Line 933: msc_plans mp,

929: FROM
930: MSC_TRADING_PARTNERS PT,
931: MSC_PLAN_ORGANIZATIONS MPO,
932: MSC_PLAN_ORGANIZATIONS MPO2,
933: msc_plans mp,
934: msc_plans mp2
935: where MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
936: AND MPO.ORGANIZATION_ID = PT.SR_TP_ID
937: AND PT.partner_type =3

Line 934: msc_plans mp2

930: MSC_TRADING_PARTNERS PT,
931: MSC_PLAN_ORGANIZATIONS MPO,
932: MSC_PLAN_ORGANIZATIONS MPO2,
933: msc_plans mp,
934: msc_plans mp2
935: where MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
936: AND MPO.ORGANIZATION_ID = PT.SR_TP_ID
937: AND PT.partner_type =3
938: and mpo.plan_id = g_to_plan

Line 998: msc_plans mp

994: FROM
995: MSC_TRADING_PARTNERS PT,
996: MSC_DESIGNATORS DESIG,
997: MSC_PLAN_SCHEDULES MPS,
998: msc_plans mp
999: WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID
1000: and mp.plan_id = mps.plan_id
1001: AND MPS.DESIGNATOR_TYPE <> 7
1002: and MPS.SR_INSTANCE_ID = PT.SR_INSTANCE_ID

Line 1058: msc_plans mp

1054: FROM
1055: MSC_TRADING_PARTNERS PT,
1056: MSC_DESIGNATORS DESIG,
1057: MSC_PLAN_SCHEDULES MPS,
1058: msc_plans mp
1059: WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID
1060: and mp.plan_id = mps.plan_id
1061: AND MPS.DESIGNATOR_TYPE <> 7
1062: and MPS.SR_INSTANCE_ID = PT.SR_INSTANCE_ID

Line 1119: msc_plans mp,

1115: MSC_TRADING_PARTNERS PT,
1116: MSC_DESIGNATORS DESIG,
1117: MSC_PLAN_SCHEDULES MPS,
1118: MSC_PLAN_SCHEDULES MPS2,
1119: msc_plans mp,
1120: msc_plans mp2
1121: WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID
1122: and mp.plan_id = mps.plan_id
1123: AND MPS.DESIGNATOR_TYPE <> 7

Line 1120: msc_plans mp2

1116: MSC_DESIGNATORS DESIG,
1117: MSC_PLAN_SCHEDULES MPS,
1118: MSC_PLAN_SCHEDULES MPS2,
1119: msc_plans mp,
1120: msc_plans mp2
1121: WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID
1122: and mp.plan_id = mps.plan_id
1123: AND MPS.DESIGNATOR_TYPE <> 7
1124: and MPS.SR_INSTANCE_ID = PT.SR_INSTANCE_ID

Line 1162: from msc_plans

1158:
1159:
1160: cursor plan_type_c(v_plan_id number) is
1161: select curr_plan_type
1162: from msc_plans
1163: where plan_id = v_plan_id;
1164:
1165: p_plan_status number;
1166: p_report_id number;

Line 2280: from msc_plans

2276: l_def_pref_id number;
2277:
2278: cursor plan_type_c(v_plan_id number) is
2279: select curr_plan_type
2280: from msc_plans
2281: where plan_id = v_plan_id;
2282:
2283: CURSOR cat_name_cur(v_category_set_id number) IS
2284: SELECT category_set_name