APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_TRADING_PARTNERS

Line 172: msc_trading_partners t,

168: msc_companies c1,
169: msc_trading_partner_maps m,
170: msc_trading_partner_maps m1,
171: msc_trading_partner_maps m2,
172: msc_trading_partners t,
173: msc_trading_partners t1,
174: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
175: msc_company_relationships r,
176: msc_plan_buckets mpb,

Line 173: msc_trading_partners t1,

169: msc_trading_partner_maps m,
170: msc_trading_partner_maps m1,
171: msc_trading_partner_maps m2,
172: msc_trading_partners t,
173: msc_trading_partners t1,
174: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
175: msc_company_relationships r,
176: msc_plan_buckets mpb,
177: msc_full_pegging mfp,

Line 187: msc_trading_partners pk:

183: PLAN_ID
184: ORGANIZATION_ID
185: INVENTORY_ITEM_ID
186:
187: msc_trading_partners pk:
188: PARTNER_ID
189: unique Key
190: SR_INSTANCE_ID
191: SR_TP_ID

Line 194: msc_trading_partners.partner_type

190: SR_INSTANCE_ID
191: SR_TP_ID
192: PARTNER_TYPE
193:
194: msc_trading_partners.partner_type
195: 1 - Suppliers
196: 2 - Customers
197: 3 - Org
198:

Line 213: msc_trading_partners pk:

209:
210: msc_companies pk:
211: COMPANY_ID
212:
213: msc_trading_partners pk:
214: PARTNER_ID
215: unique Key
216: SR_INSTANCE_ID
217: SR_TP_ID

Line 409: msc_trading_partners t,

405: msc_companies c1,
406: msc_trading_partner_maps m,
407: msc_trading_partner_maps m1,
408: msc_trading_partner_maps m2,
409: msc_trading_partners t,
410: msc_trading_partners t1,
411: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
412: msc_company_relationships r,
413: msc_plan_buckets mpb,

Line 410: msc_trading_partners t1,

406: msc_trading_partner_maps m,
407: msc_trading_partner_maps m1,
408: msc_trading_partner_maps m2,
409: msc_trading_partners t,
410: msc_trading_partners t1,
411: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
412: msc_company_relationships r,
413: msc_plan_buckets mpb,
414: fnd_lookup_values flv

Line 422: msc_trading_partners pk:

418: PLAN_ID
419: ORGANIZATION_ID
420: INVENTORY_ITEM_ID
421:
422: msc_trading_partners pk:
423: PARTNER_ID
424: unique Key
425: SR_INSTANCE_ID
426: SR_TP_ID

Line 429: msc_trading_partners.partner_type

425: SR_INSTANCE_ID
426: SR_TP_ID
427: PARTNER_TYPE
428:
429: msc_trading_partners.partner_type
430: 1 - Suppliers
431: 2 - Customers
432: 3 - Org
433:

Line 448: msc_trading_partners pk:

444:
445: msc_companies pk:
446: COMPANY_ID
447:
448: msc_trading_partners pk:
449: PARTNER_ID
450: unique Key
451: SR_INSTANCE_ID
452: SR_TP_ID

Line 633: from msc_trading_partners

629: print_debug_info('p_sr_instance_id := ' || p_sr_instance_id);
630:
631: select sr_tp_id
632: into p_org_id
633: from msc_trading_partners
634: where organization_code = p_org_code and
635: sr_instance_id = p_sr_instance_id and
636: partner_type = 3 and
637: company_id is null;

Line 673: FROM msc_trading_partners

669:
670: IF p_source_customer_id IS NOT NULL THEN
671: SELECT partner_name
672: INTO l_cust_name
673: FROM msc_trading_partners
674: WHERE partner_id = p_source_customer_id;
675: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUSTOMER',l_language_code) || ': ' || l_cust_name || fnd_global.local_chr(10);
676: END IF;
677:

Line 1466: msc_trading_partners p

1462: sd.publisher_site_id IN (select cs.company_site_id
1463: from msc_plan_organizations o,
1464: msc_company_sites cs,
1465: msc_trading_partner_maps m,
1466: msc_trading_partners p
1467: where o.plan_id = p_plan_id and
1468: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1469: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and
1470: p.partner_type = 3 and

Line 1509: msc_trading_partners p

1505: sd.publisher_site_id IN (select cs.company_site_id
1506: from msc_plan_organizations o,
1507: msc_company_sites cs,
1508: msc_trading_partner_maps m,
1509: msc_trading_partners p
1510: where o.plan_id = p_plan_id and
1511: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1512: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and
1513: p.partner_type = 3 and