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 217: msc_company_sites s,

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

Line 385: msc_company_sites s,

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

Line 523: msc_company_sites s,

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

Line 672: msc_company_sites s,

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

Line 799: msc_company_sites s,

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

Line 1613: msc_company_sites s,

1609: t_pub(j),
1610: t_pub_site_id(j),
1611: t_pub_site(j)
1612: from msc_companies c,
1613: msc_company_sites s,
1614: msc_trading_partner_maps m,
1615: msc_trading_partners t
1616: where t.sr_tp_id = t_org_id(j) and
1617: t.sr_instance_id = t_sr_instance_id(j) and

Line 1734: from msc_company_sites s,

1730: select s.company_site_id,
1731: s.company_site_name
1732: into t_supp_site_id(j),
1733: t_supp_site(j)
1734: from msc_company_sites s,
1735: msc_trading_partner_maps m,
1736: msc_item_suppliers mis
1737: where m.tp_key = mis.supplier_site_id and
1738: m.map_type = 3 and

Line 1780: from msc_company_sites s,

1776: select s.company_site_id,
1777: s.company_site_name
1778: into t_supp_site_id(j),
1779: t_supp_site(j)
1780: from msc_company_sites s,
1781: msc_trading_partner_maps m,
1782: msc_item_suppliers mis
1783: where m.map_type = 3 and
1784: s.company_site_id = m.company_key and

Line 3311: msc_company_sites cs,

3307: sd.plan_id = -1 and
3308: sd.publisher_id = 1 and
3309: exists (select cs.company_site_id
3310: from msc_plan_organizations o,
3311: msc_company_sites cs,
3312: msc_trading_partner_maps m,
3313: msc_trading_partners p
3314: where o.plan_id = p_plan_id and
3315: p.sr_tp_id = nvl(p_org_id, o.organization_id) and

Line 3341: msc_company_sites cs,

3337: sd.plan_id = -1 and
3338: sd.publisher_id = 1 and
3339: exists (select cs.company_site_id
3340: from msc_plan_organizations o,
3341: msc_company_sites cs,
3342: msc_trading_partner_maps m,
3343: msc_trading_partners p
3344: where o.plan_id = p_plan_id and
3345: p.sr_tp_id = nvl(p_org_id, o.organization_id) and