APPS.MSC_AATP_PVT dependencies on MSC_TRADING_PARTNERS

Line 2364: MSC_TRADING_PARTNERS MTP,--bug3263368

2360: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2361: D.REQUEST_SHIP_DATE) --bug3263368
2362: FROM -- MSC_CALENDAR_DATES C, --2859130
2363: MSC_DEMANDS D,
2364: MSC_TRADING_PARTNERS MTP,--bug3263368
2365: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2366: WHERE D.PLAN_ID = p_plan_id
2367: AND D.SR_INSTANCE_ID = p_instance_id
2368: AND D.INVENTORY_ITEM_ID = p_item_id

Line 2877: MSC_TRADING_PARTNERS MTP,--bug3263368

2873: D.REQUEST_SHIP_DATE) --bug3263368
2874:
2875: FROM MSC_CALENDAR_DATES C,
2876: MSC_DEMANDS D,
2877: MSC_TRADING_PARTNERS MTP,--bug3263368
2878: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2879:
2880: WHERE D.PLAN_ID = p_plan_id
2881: AND D.SR_INSTANCE_ID = p_instance_id

Line 8696: FROM msc_trading_partners tp,

8692: l_calendar_code := p_sup_atp_info_rec.manufacturing_cal_code;
8693: ELSE
8694: SELECT tp.calendar_code
8695: INTO l_calendar_code
8696: FROM msc_trading_partners tp,
8697: msc_plans mp
8698: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
8699: AND tp.sr_instance_id = mp.sr_instance_id
8700: AND tp.partner_type = 3

Line 10637: msc_trading_partners tp,

10633: BEGIN
10634: SELECT min(mdr.plan_id) as plan_id
10635: INTO l_plan_id
10636: FROM msc_department_resources mdr,
10637: msc_trading_partners tp,
10638: msc_apps_instances ins,
10639: msc_plans plans,
10640: msc_designators desig
10641: WHERE desig.inventory_atp_flag = 1