DBA Data[Home] [Help]

APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 732: msc_company_relationships r

728: t_tp_uom(j)
729: from msc_item_customers mcf,
730: msc_trading_partner_maps m,
731: msc_trading_partner_maps m2,
732: msc_company_relationships r
733: where mcf.inventory_item_id = t_item_id(j) and
734: mcf.plan_id = -1 and
735: r.relationship_type = 1 and
736: r.subject_id = t_pub_id(j) and

Line 757: msc_company_relationships r

753: t_tp_uom(j)
754: from msc_item_customers mcf,
755: msc_trading_partner_maps m,
756: msc_trading_partner_maps m2,
757: msc_company_relationships r
758: where mcf.inventory_item_id = t_item_id(j) and
759: r.relationship_type = 1 and
760: r.subject_id = t_pub_id(j) and
761: r.object_id = t_cust_id(j) and

Line 1069: msc_company_relationships r,

1065: BEGIN
1066: select c.company_id
1067: into l_customer_id
1068: from msc_trading_partner_maps m,
1069: msc_company_relationships r,
1070: msc_companies c
1071: where m.tp_key = p_customer_id and
1072: m.map_type = 1 and
1073: m.company_key = r.relationship_id and