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.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_COMPANY_SITES

Line 220: msc_company_sites s,

216: msc_plan_buckets mpb,
217: msc_plan_organizations_v ov,
218: msc_system_items item,
219: msc_companies c,
220: msc_company_sites s,
221: msc_trading_partners t,
222: msc_trading_partner_maps m,
223: msc_plans p
224: WHERE p.plan_id = mst.plan_id

Line 388: msc_company_sites s,

384: msc_supplies rec,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
387: msc_companies c,
388: msc_company_sites s,
389: msc_trading_partners t,
390: msc_trading_partner_maps m
391: WHERE p.plan_id = p_plan_id
392: AND p.plan_id = msi.plan_id

Line 526: msc_company_sites s,

522: msc_demands mgr,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
525: msc_companies c,
526: msc_company_sites s,
527: msc_trading_partners t,
528: msc_trading_partner_maps m
529: WHERE p.plan_id = p_plan_id
530: AND p.plan_id = mgr.plan_id

Line 675: msc_company_sites s,

671: msc_trading_partners param,
672: msc_system_items msi,
673: msc_supplies rec,
674: msc_companies c,
675: msc_company_sites s,
676: msc_trading_partners t,
677: msc_trading_partner_maps m
678: WHERE p.plan_id = p_plan_id
679: AND p.plan_id = msi.plan_id

Line 802: msc_company_sites s,

798: msc_trading_partners param,
799: msc_system_items msi,
800: msc_demands mgr,
801: msc_companies c,
802: msc_company_sites s,
803: msc_trading_partners t,
804: msc_trading_partner_maps m
805: WHERE p.plan_id = p_plan_id
806: AND p.plan_id = mgr.plan_id

Line 1629: msc_company_sites s,

1625: t_pub(j),
1626: t_pub_site_id(j),
1627: t_pub_site(j)
1628: from msc_companies c,
1629: msc_company_sites s,
1630: msc_trading_partner_maps m,
1631: msc_trading_partners t
1632: where t.sr_tp_id = t_org_id(j) and
1633: t.sr_instance_id = t_sr_instance_id(j) and

Line 1750: from msc_company_sites s,

1746: select s.company_site_id,
1747: s.company_site_name
1748: into t_supp_site_id(j),
1749: t_supp_site(j)
1750: from msc_company_sites s,
1751: msc_trading_partner_maps m,
1752: msc_item_suppliers mis
1753: where m.tp_key = mis.supplier_site_id and
1754: m.map_type = 3 and

Line 1796: from msc_company_sites s,

1792: select s.company_site_id,
1793: s.company_site_name
1794: into t_supp_site_id(j),
1795: t_supp_site(j)
1796: from msc_company_sites s,
1797: msc_trading_partner_maps m,
1798: msc_item_suppliers mis
1799: where m.map_type = 3 and
1800: s.company_site_id = m.company_key and

Line 3327: msc_company_sites cs,

3323: sd.plan_id = -1 and
3324: sd.publisher_id = 1 and
3325: exists (select cs.company_site_id
3326: from msc_plan_organizations o,
3327: msc_company_sites cs,
3328: msc_trading_partner_maps m,
3329: msc_trading_partners p
3330: where o.plan_id = p_plan_id and
3331: p.sr_tp_id = nvl(p_org_id, o.organization_id) and

Line 3357: msc_company_sites cs,

3353: sd.plan_id = -1 and
3354: sd.publisher_id = 1 and
3355: exists (select cs.company_site_id
3356: from msc_plan_organizations o,
3357: msc_company_sites cs,
3358: msc_trading_partner_maps m,
3359: msc_trading_partners p
3360: where o.plan_id = p_plan_id and
3361: p.sr_tp_id = nvl(p_org_id, o.organization_id) and