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_PLAN_SCHEDULES

Line 997: MSC_PLAN_SCHEDULES MPS,

993: , mp.compile_designator
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

Line 1007: from MSC_PLAN_SCHEDULES MPS2

1003: AND MPS.ORGANIZATION_ID = PT.SR_TP_ID
1004: AND PT.partner_type =3
1005: and mps.plan_id = g_from_plan
1006: and not exists ( select 1
1007: from MSC_PLAN_SCHEDULES MPS2
1008: where MPS2.plan_id = g_to_plan
1009: and MPS2.organization_id = MPS.organization_id
1010: and MPS2.sr_instance_id = MPS.sr_instance_id
1011: and mps2.input_type = mps.input_type

Line 1057: MSC_PLAN_SCHEDULES MPS,

1053: , mp.compile_designator
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

Line 1067: from MSC_PLAN_SCHEDULES MPS2

1063: AND MPS.ORGANIZATION_ID = PT.SR_TP_ID
1064: AND PT.partner_type =3
1065: and mps.plan_id = g_to_plan
1066: and not exists ( select 1
1067: from MSC_PLAN_SCHEDULES MPS2
1068: where MPS2.plan_id = g_from_plan
1069: and MPS2.organization_id = MPS.organization_id
1070: and MPS2.sr_instance_id = MPS.sr_instance_id
1071: and mps2.input_type = mps.input_type

Line 1117: MSC_PLAN_SCHEDULES MPS,

1113: , mp.compile_designator||'&'||mp2.compile_designator
1114: FROM
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

Line 1118: MSC_PLAN_SCHEDULES MPS2,

1114: FROM
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