APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_TRADING_PARTNERS

Line 275: msc_trading_partners t1,

271: ) --reciept_date
272: from msc_plan_organizations_v ov,
273: msc_system_items i,
274: msc_supplies sup,
275: msc_trading_partners t1,
276: msc_plan_buckets mpb
277: where ov.plan_id = p_plan_id and
278: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
279: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and

Line 418: msc_trading_partners t1,

414: NULL line_number -- dummy type not to be used
415: from msc_plan_organizations_v ov,
416: msc_system_items i,
417: msc_supplies sup,
418: msc_trading_partners t1,
419: msc_plan_buckets mpb
420: where ov.plan_id = p_plan_id and
421: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
422: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and

Line 523: msc_trading_partners t1,

519: TRIM(decode(instr(dem.order_number,'(',-1,1),0,null,substr(dem.order_number,instr(dem.order_number,'(',-1,1) + 1,instr(dem.order_number,')',-1,1) - instr(dem.order_number,'(',-1,1) -1 ))) --
520: from msc_plan_organizations_v ov,
521: msc_system_items i,
522: msc_demands dem,
523: msc_trading_partners t1,
524: msc_plan_buckets mpb
525: where ov.plan_id = p_plan_id and
526: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
527: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and

Line 653: from msc_trading_partners

649: log_message('p_sr_instance_id := ' || p_sr_instance_id);
650:
651: select sr_tp_id
652: into p_org_id
653: from msc_trading_partners
654: where organization_code = p_org_code and
655: sr_instance_id = p_sr_instance_id and
656: partner_type = 3 and
657: company_id is null;

Line 693: FROM msc_trading_partners

689:
690: IF p_supplier_id IS NOT NULL THEN
691: SELECT partner_name
692: INTO l_supp_name
693: FROM msc_trading_partners
694: WHERE partner_id = p_supplier_id;
695: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
696: END IF;
697:

Line 1529: msc_trading_partners t

1525: t_pub_site(j)
1526: from msc_companies c,
1527: msc_company_sites s,
1528: msc_trading_partner_maps m,
1529: msc_trading_partners t
1530: where t.sr_tp_id = t_org_id(j) and
1531: t.sr_instance_id = t_sr_instance_id(j) and
1532: t.partner_type = 3 and
1533: m.tp_key = t.partner_id and

Line 1629: msc_trading_partners part,

1625: into t_supp_item_name(j),
1626: t_supp_item_desc(j),
1627: t_tp_uom(j)
1628: from msc_system_items msi,
1629: msc_trading_partners part,
1630: msc_trading_partner_maps map
1631: where msi.plan_id = -1 and
1632: msi.inventory_item_id = t_item_id(j) and
1633: msi.organization_id = part.sr_tp_id and

Line 5113: msc_trading_partners p

5109: exists (select cs.company_site_id
5110: from msc_plan_organizations o,
5111: msc_company_sites cs,
5112: msc_trading_partner_maps m,
5113: msc_trading_partners p
5114: where o.plan_id = p_plan_id
5115: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
5116: AND O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID)
5117: AND P.SR_TP_ID = O.ORGANIZATION_ID

Line 5159: msc_trading_partners p

5155: exists (select cs.company_site_id
5156: from msc_plan_organizations o,
5157: msc_company_sites cs,
5158: msc_trading_partner_maps m,
5159: msc_trading_partners p
5160: where o.plan_id = p_plan_id and
5161: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
5162: p.sr_instance_id = nvl(p_sr_instance_id,
5163: o.sr_instance_id) and