APPS.MSC_ATP_FUNC dependencies on MSC_TRADING_PARTNERS

Line 247: from msc_trading_partners mtp

243: AND loc.sr_instance_id = tpsid.sr_instance_id
244:
245: --bug 6833430 to ensure loc record is that of customer
246: AND NOT EXISTS (select NULL
247: from msc_trading_partners mtp
248: where mtp.sr_instance_id = loc.sr_instance_id AND
249: mtp.partner_id = loc.partner_id AND
250: mtp.partner_type = 3);
251:

Line 345: msc_trading_partners tp,

341: INTO l_infinite_time_fence_date
342: FROM msc_calendar_dates c2,
343: msc_calendar_dates c1,
344: msc_atp_rules r,
345: msc_trading_partners tp,
346: msc_system_items i
347: WHERE i.sr_inventory_item_id = p_inventory_item_id
348: AND i.organization_id = p_organization_id
349: --AND i.plan_id = p_plan_id

Line 430: FROM msc_trading_partners

426: BEGIN
427:
428: SELECT organization_code
429: INTO l_org_code
430: FROM msc_trading_partners
431: WHERE sr_tp_id = p_organization_id
432: AND sr_instance_id = p_instance_id
433: AND partner_type = 3;
434:

Line 609: FROM msc_trading_partners s

605: BEGIN
606:
607: SELECT partner_name
608: INTO l_supplier_name
609: FROM msc_trading_partners s
610: WHERE s.partner_id = p_supplier_id;
611:
612: return l_supplier_name;
613:

Line 690: msc_trading_partners tp

686: BEGIN
687: SELECT cal.prior_date
688: INTO l_date
689: FROM msc_calendar_dates cal,
690: msc_trading_partners tp
691: WHERE cal.exception_set_id = tp.calendar_exception_set_id
692: AND cal.calendar_code = tp.calendar_code
693: AND cal.calendar_date = TRUNC(p_date)
694: AND cal.sr_instance_id = tp.sr_instance_id

Line 783: MSC_TRADING_PARTNERS TP

779: BEGIN
780: SELECT C.NEXT_SEQ_NUM
781: INTO l_seq_num
782: FROM MSC_CALENDAR_DATES C,
783: MSC_TRADING_PARTNERS TP
784: WHERE TP.SR_TP_ID = p_organization_id
785: AND TP.SR_INSTANCE_ID = p_instance_id
786: AND TP.PARTNER_TYPE = 3
787: AND C.CALENDAR_CODE = TP.CALENDAR_CODE