APPS.MSC_ATP_ALLOC dependencies on MSC_TRADING_PARTNERS

Line 433: msc_trading_partners mtp

429: l_inv_item_name,
430: l_org_code, l_atp_flag
431: --, G_ROUNDING_CONTROL_FLAG
432: FROM msc_system_items msi,
433: msc_trading_partners mtp
434: WHERE msi.plan_id = p_plan_id
435: AND msi.sr_instance_id = p_instance_id
436: AND msi.organization_id = p_organization_id
437: AND msi.sr_inventory_item_id = p_inventory_item_id

Line 668: MSC_TRADING_PARTNERS MTP,--bug3263368

664: AD.REQUEST_DATE col24 --bug3263368
665: FROM
666: MSC_ALLOC_DEMANDS AD,
667: MSC_ALLOC_TEMP TEMP,
668: MSC_TRADING_PARTNERS MTP,--bug3263368
669: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
670: WHERE
671: AD.PLAN_ID = p_plan_id
672: AND AD.SR_INSTANCE_ID = p_instance_id

Line 718: MSC_TRADING_PARTNERS MTP,--bug3684383

714: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
715: FROM
716: MSC_ALLOC_SUPPLIES SA,
717: MSC_ALLOC_TEMP TEMP,
718: MSC_TRADING_PARTNERS MTP,--bug3684383
719: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
720: WHERE
721: SA.PLAN_ID = p_plan_id
722: AND SA.SR_INSTANCE_ID = p_instance_id

Line 1303: MSC_TRADING_PARTNERS MTP, --bug3263368

1299: MSC_DEMANDS D,
1300: --Bug 3823042, donot use msc_calendar_dates
1301: --MSC_CALENDAR_DATES C,
1302: MSC_ALLOC_TEMP TEMP,
1303: MSC_TRADING_PARTNERS MTP, --bug3263368
1304: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
1305: WHERE
1306: D.PLAN_ID = p_plan_id
1307: AND D.SR_INSTANCE_ID = p_instance_id

Line 1613: MSC_TRADING_PARTNERS MTP, --bug3263368

1609: FROM
1610: MSC_DEMANDS D,
1611: MSC_CALENDAR_DATES C,
1612: MSC_ALLOC_TEMP TEMP,
1613: MSC_TRADING_PARTNERS MTP, --bug3263368
1614: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
1615: WHERE
1616: D.PLAN_ID = p_plan_id
1617: AND D.SR_INSTANCE_ID = p_instance_id

Line 1992: msc_trading_partners mtp, msc_trading_partner_sites mtps

1988: LEVEL_3_DEMAND_CLASS_PRIORITY, ALLOCATION_PERCENT, CUSTOMER_NAME, CUSTOMER_SITE_NAME)
1989: SELECT A.demand_class, B.demand_class, A.class, A.partner_id,
1990: A.partner_site_id, A.priority, A.allocation_percent, mtp.partner_name, mtps.location
1991: FROM msc_item_hierarchy_mv A, msc_item_hierarchy_mv B,
1992: msc_trading_partners mtp, msc_trading_partner_sites mtps
1993: WHERE A.inventory_item_id = l_item_to_use
1994: AND A.organization_id = p_organization_id
1995: AND A.sr_instance_id = p_instance_id
1996: AND p_request_date BETWEEN A.effective_date AND A.disable_date

Line 2285: MSC_TRADING_PARTNERS MTP,--bug3263368

2281: MSC_DEMANDS D,
2282: -- Bug 3823042
2283: --MSC_CALENDAR_DATES C,
2284: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2285: MSC_TRADING_PARTNERS MTP,--bug3263368
2286: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2287:
2288: WHERE
2289: D.PLAN_ID = p_plan_id

Line 2595: MSC_TRADING_PARTNERS MTP,--bug3263368

2591: FROM
2592: MSC_DEMANDS D,
2593: MSC_CALENDAR_DATES C,
2594: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2595: MSC_TRADING_PARTNERS MTP,--bug3263368
2596: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2597:
2598: WHERE
2599: D.PLAN_ID = p_plan_id