DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 184: msc_company_relationships r,

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,
187: msc_supplies sup,
188: fnd_lookup_values flv

Line 421: msc_company_relationships r,

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
424: where
425: /* msc_system_items msi pk:

Line 1178: msc_company_relationships r

1174: t_tp_uom(j)
1175: from msc_item_customers mcf,
1176: msc_trading_partner_maps m,
1177: msc_trading_partner_maps m2,
1178: msc_company_relationships r
1179: where mcf.inventory_item_id = t_item_id(j) and
1180: r.relationship_type = 1 and
1181: r.subject_id = t_pub_id(j) and
1182: r.object_id = t_cust_id(j) and

Line 1452: msc_company_relationships r,

1448: BEGIN
1449: select c.company_id
1450: into l_customer_id
1451: from msc_trading_partner_maps m,
1452: msc_company_relationships r,
1453: msc_companies c
1454: where m.tp_key = p_source_customer_id and
1455: m.map_type = 1 and
1456: m.company_key = r.relationship_id and