APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_TRADING_PARTNERS

Line 181: msc_trading_partners t,

177: msc_companies c1,
178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
184: msc_company_relationships r,
185: msc_plan_buckets mpb,

Line 182: msc_trading_partners t1,

178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
184: msc_company_relationships r,
185: msc_plan_buckets mpb,
186: msc_full_pegging mfp,

Line 196: msc_trading_partners pk:

192: PLAN_ID
193: ORGANIZATION_ID
194: INVENTORY_ITEM_ID
195:
196: msc_trading_partners pk:
197: PARTNER_ID
198: unique Key
199: SR_INSTANCE_ID
200: SR_TP_ID

Line 203: msc_trading_partners.partner_type

199: SR_INSTANCE_ID
200: SR_TP_ID
201: PARTNER_TYPE
202:
203: msc_trading_partners.partner_type
204: 1 - Suppliers
205: 2 - Customers
206: 3 - Org
207:

Line 222: msc_trading_partners pk:

218:
219: msc_companies pk:
220: COMPANY_ID
221:
222: msc_trading_partners pk:
223: PARTNER_ID
224: unique Key
225: SR_INSTANCE_ID
226: SR_TP_ID

Line 418: msc_trading_partners t,

414: msc_companies c1,
415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
421: msc_company_relationships r,
422: msc_plan_buckets mpb,

Line 419: msc_trading_partners t1,

415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
421: msc_company_relationships r,
422: msc_plan_buckets mpb,
423: fnd_lookup_values flv

Line 431: msc_trading_partners pk:

427: PLAN_ID
428: ORGANIZATION_ID
429: INVENTORY_ITEM_ID
430:
431: msc_trading_partners pk:
432: PARTNER_ID
433: unique Key
434: SR_INSTANCE_ID
435: SR_TP_ID

Line 438: msc_trading_partners.partner_type

434: SR_INSTANCE_ID
435: SR_TP_ID
436: PARTNER_TYPE
437:
438: msc_trading_partners.partner_type
439: 1 - Suppliers
440: 2 - Customers
441: 3 - Org
442:

Line 457: msc_trading_partners pk:

453:
454: msc_companies pk:
455: COMPANY_ID
456:
457: msc_trading_partners pk:
458: PARTNER_ID
459: unique Key
460: SR_INSTANCE_ID
461: SR_TP_ID

Line 660: from msc_trading_partners

656: print_debug_info('p_sr_instance_id := ' || p_sr_instance_id);
657:
658: select sr_tp_id
659: into p_org_id
660: from msc_trading_partners
661: where organization_code = p_org_code and
662: sr_instance_id = p_sr_instance_id and
663: partner_type = 3 and
664: company_id is null;

Line 700: FROM msc_trading_partners

696:
697: IF p_source_customer_id IS NOT NULL THEN
698: SELECT partner_name
699: INTO l_cust_name
700: FROM msc_trading_partners
701: WHERE partner_id = p_source_customer_id;
702: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUSTOMER',l_language_code) || ': ' || l_cust_name || fnd_global.local_chr(10);
703: END IF;
704:

Line 1502: msc_trading_partners p

1498: sd.publisher_site_id IN (select cs.company_site_id
1499: from msc_plan_organizations o,
1500: msc_company_sites cs,
1501: msc_trading_partner_maps m,
1502: msc_trading_partners p
1503: where o.plan_id = p_plan_id and
1504: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1505: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and
1506: p.partner_type = 3 and

Line 1545: msc_trading_partners p

1541: sd.publisher_site_id IN (select cs.company_site_id
1542: from msc_plan_organizations o,
1543: msc_company_sites cs,
1544: msc_trading_partner_maps m,
1545: msc_trading_partners p
1546: where o.plan_id = p_plan_id and
1547: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1548: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and
1549: p.partner_type = 3 and