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_TRADING_PARTNER_MAPS

Line 136: msc_trading_partner_maps m,

132: msc_company_sites cs,
133: msc_company_sites cs1,
134: msc_companies c,
135: msc_companies c1,
136: msc_trading_partner_maps m,
137: msc_trading_partner_maps m2,
138: msc_trading_partners t,
139: msc_tp_site_id_lid tsi1,
140: msc_trading_partner_sites ts1

Line 137: msc_trading_partner_maps m2,

133: msc_company_sites cs1,
134: msc_companies c,
135: msc_companies c1,
136: msc_trading_partner_maps m,
137: msc_trading_partner_maps m2,
138: msc_trading_partners t,
139: msc_tp_site_id_lid tsi1,
140: msc_trading_partner_sites ts1
141: -- msc_tp_id_lid ti1

Line 730: msc_trading_partner_maps m,

726: into t_cust_item_name(j),
727: t_cust_item_desc(j),
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

Line 731: msc_trading_partner_maps m2,

727: t_cust_item_desc(j),
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

Line 755: msc_trading_partner_maps m,

751: into t_cust_item_name(j),
752: t_cust_item_desc(j),
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

Line 756: msc_trading_partner_maps m2,

752: t_cust_item_desc(j),
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

Line 1068: from msc_trading_partner_maps m,

1064: if p_customer_id is not null then
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

Line 1091: from msc_trading_partner_maps m,

1087: if p_customer_site_id is not null then
1088: BEGIN
1089: select cs.company_site_id
1090: into l_customer_site_id
1091: from msc_trading_partner_maps m,
1092: msc_company_sites cs
1093: where m.tp_key = p_customer_site_id and
1094: m.map_type = 3 and
1095: cs.company_site_id = m.company_key;

Line 1111: msc_trading_partner_maps m,

1107: BEGIN
1108: select distinct cs.company_site_id
1109: into l_supplier_site_id
1110: from msc_company_sites cs,
1111: msc_trading_partner_maps m,
1112: msc_trading_partners t
1113: where t.sr_tp_id = p_org_id and
1114: t.sr_instance_id = p_sr_instance_id and
1115: t.partner_type = 3 and