APPS.MSC_NETCHANGE_PKG dependencies on MSC_TRADING_PARTNERS

Line 812: MSC_TRADING_PARTNERS PT,

808: , MPO.SIMULATION_SET
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

Line 871: MSC_TRADING_PARTNERS PT,

867: , MPO.SIMULATION_SET
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

Line 930: MSC_TRADING_PARTNERS PT,

926: , MPO.SIMULATION_SET
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

Line 995: MSC_TRADING_PARTNERS PT,

991: , MPS.PROBABILITY
992: , MPS.input_type
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

Line 1055: MSC_TRADING_PARTNERS PT,

1051: , MPS.PROBABILITY
1052: , MPS.input_type
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

Line 1115: MSC_TRADING_PARTNERS PT,

1111: , MPS.PROBABILITY
1112: , MPS.input_type
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,