APPS.MSC_AATP_PVT dependencies on MSC_TRADING_PARTNERS

Line 2562: MSC_TRADING_PARTNERS MTP,--bug3263368

2558: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2559: D.REQUEST_SHIP_DATE) --bug3263368
2560: FROM -- MSC_CALENDAR_DATES C, --2859130
2561: MSC_DEMANDS D,
2562: MSC_TRADING_PARTNERS MTP,--bug3263368
2563: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2564: WHERE D.PLAN_ID = p_plan_id
2565: AND D.SR_INSTANCE_ID = p_instance_id
2566: AND D.INVENTORY_ITEM_ID = p_item_id

Line 3101: MSC_TRADING_PARTNERS MTP,--bug3263368

3097: D.REQUEST_SHIP_DATE) --bug3263368
3098:
3099: FROM MSC_CALENDAR_DATES C,
3100: MSC_DEMANDS D,
3101: MSC_TRADING_PARTNERS MTP,--bug3263368
3102: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3103:
3104: WHERE D.PLAN_ID = p_plan_id
3105: AND D.SR_INSTANCE_ID = p_instance_id

Line 8927: FROM msc_trading_partners tp,

8923: l_calendar_code := p_sup_atp_info_rec.manufacturing_cal_code;
8924: ELSE
8925: SELECT tp.calendar_code
8926: INTO l_calendar_code
8927: FROM msc_trading_partners tp,
8928: msc_plans mp
8929: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
8930: AND tp.sr_instance_id = mp.sr_instance_id
8931: AND tp.partner_type = 3

Line 10868: msc_trading_partners tp,

10864: BEGIN
10865: SELECT min(mdr.plan_id) as plan_id
10866: INTO l_plan_id
10867: FROM msc_department_resources mdr,
10868: msc_trading_partners tp,
10869: msc_apps_instances ins,
10870: msc_plans plans,
10871: msc_designators desig
10872: WHERE desig.inventory_atp_flag = 1