APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_TRADING_PARTNERS

Line 278: msc_trading_partners t1,

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

Line 421: msc_trading_partners t1,

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

Line 526: msc_trading_partners t1,

522: 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 ))) --
523: from msc_plan_organizations_v ov,
524: msc_system_items i,
525: msc_demands dem,
526: msc_trading_partners t1,
527: msc_plan_buckets mpb
528: where ov.plan_id = p_plan_id and
529: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
530: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and

Line 670: from msc_trading_partners

666: log_message('p_sr_instance_id := ' || p_sr_instance_id);
667:
668: select sr_tp_id
669: into p_org_id
670: from msc_trading_partners
671: where organization_code = p_org_code and
672: sr_instance_id = p_sr_instance_id and
673: partner_type = 3 and
674: company_id is null;

Line 710: FROM msc_trading_partners

706:
707: IF p_supplier_id IS NOT NULL THEN
708: SELECT partner_name
709: INTO l_supp_name
710: FROM msc_trading_partners
711: WHERE partner_id = p_supplier_id;
712: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
713: END IF;
714:

Line 1546: msc_trading_partners t

1542: t_pub_site(j)
1543: from msc_companies c,
1544: msc_company_sites s,
1545: msc_trading_partner_maps m,
1546: msc_trading_partners t
1547: where t.sr_tp_id = t_org_id(j) and
1548: t.sr_instance_id = t_sr_instance_id(j) and
1549: t.partner_type = 3 and
1550: m.tp_key = t.partner_id and

Line 1646: msc_trading_partners part,

1642: into t_supp_item_name(j),
1643: t_supp_item_desc(j),
1644: t_tp_uom(j)
1645: from msc_system_items msi,
1646: msc_trading_partners part,
1647: msc_trading_partner_maps map
1648: where msi.plan_id = -1 and
1649: msi.inventory_item_id = t_item_id(j) and
1650: msi.organization_id = part.sr_tp_id and

Line 5130: msc_trading_partners p

5126: exists (select cs.company_site_id
5127: from msc_plan_organizations o,
5128: msc_company_sites cs,
5129: msc_trading_partner_maps m,
5130: msc_trading_partners p
5131: where o.plan_id = p_plan_id
5132: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
5133: AND O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID)
5134: AND P.SR_TP_ID = O.ORGANIZATION_ID

Line 5176: msc_trading_partners p

5172: exists (select cs.company_site_id
5173: from msc_plan_organizations o,
5174: msc_company_sites cs,
5175: msc_trading_partner_maps m,
5176: msc_trading_partners p
5177: where o.plan_id = p_plan_id and
5178: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
5179: p.sr_instance_id = nvl(p_sr_instance_id,
5180: o.sr_instance_id) and