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_ORGANIZATIONS

Line 813: MSC_PLAN_ORGANIZATIONS MPO,

809: , MPO.BILL_OF_RESOURCES
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

Line 821: from MSC_PLAN_ORGANIZATIONS MPO2

817: AND PT.partner_type =3
818: and mp.plan_id = mpo.plan_id
819: and mpo.plan_id = g_from_plan
820: and not exists ( select 1
821: from MSC_PLAN_ORGANIZATIONS MPO2
822: where MPO2.plan_id = g_to_plan
823: and MPO2.organization_id = MPO.organization_id
824: and MPO2.sr_instance_id = MPO.sr_instance_id
825: and nvl(MPO2.NET_WIP,0) = nvl(MPO.NET_WIP,0)

Line 872: MSC_PLAN_ORGANIZATIONS MPO,

868: , MPO.BILL_OF_RESOURCES
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

Line 880: from MSC_PLAN_ORGANIZATIONS MPO2

876: AND PT.partner_type =3
877: and mpo.plan_id = g_to_plan
878: and mp.plan_id = mpo.plan_id
879: and not exists ( select 1
880: from MSC_PLAN_ORGANIZATIONS MPO2
881: where MPO2.plan_id = g_from_plan
882: and MPO2.organization_id = MPO.organization_id
883: and MPO2.sr_instance_id = MPO.sr_instance_id
884: and nvl(MPO2.NET_WIP,0) = nvl(MPO.NET_WIP,0)

Line 931: MSC_PLAN_ORGANIZATIONS MPO,

927: , MPO.BILL_OF_RESOURCES
928: , nvl(decode(MPO.INCLUDE_SALESORDER,1,g_yes,g_no),g_no)
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

Line 932: MSC_PLAN_ORGANIZATIONS MPO2,

928: , nvl(decode(MPO.INCLUDE_SALESORDER,1,g_yes,g_no),g_no)
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