DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 175: msc_company_relationships r,

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,
178: msc_supplies sup,
179: fnd_lookup_values flv

Line 412: msc_company_relationships r,

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
415: where
416: /* msc_system_items msi pk:

Line 1144: msc_company_relationships r

1140: t_tp_uom(j)
1141: from msc_item_customers mcf,
1142: msc_trading_partner_maps m,
1143: msc_trading_partner_maps m2,
1144: msc_company_relationships r
1145: where mcf.inventory_item_id = t_item_id(j) and
1146: r.relationship_type = 1 and
1147: r.subject_id = t_pub_id(j) and
1148: r.object_id = t_cust_id(j) and

Line 1416: msc_company_relationships r,

1412: BEGIN
1413: select c.company_id
1414: into l_customer_id
1415: from msc_trading_partner_maps m,
1416: msc_company_relationships r,
1417: msc_companies c
1418: where m.tp_key = p_source_customer_id and
1419: m.map_type = 1 and
1420: m.company_key = r.relationship_id and