eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 698: msc_company_relationships r

694: t_tp_uom(j)
695: from msc_item_customers mcf,
696: msc_trading_partner_maps m,
697: msc_trading_partner_maps m2,
698: msc_company_relationships r
699: where mcf.inventory_item_id = t_item_id(j) and
700: mcf.plan_id = -1 and
701: r.relationship_type = 1 and
702: r.subject_id = t_pub_id(j) and

Line 723: msc_company_relationships r

719: t_tp_uom(j)
720: from msc_item_customers mcf,
721: msc_trading_partner_maps m,
722: msc_trading_partner_maps m2,
723: msc_company_relationships r
724: where mcf.inventory_item_id = t_item_id(j) and
725: r.relationship_type = 1 and
726: r.subject_id = t_pub_id(j) and
727: r.object_id = t_cust_id(j) and

Line 1035: msc_company_relationships r,

1031: BEGIN
1032: select c.company_id
1033: into l_customer_id
1034: from msc_trading_partner_maps m,
1035: msc_company_relationships r,
1036: msc_companies c
1037: where m.tp_key = p_customer_id and
1038: m.map_type = 1 and
1039: m.company_key = r.relationship_id and