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_X_HZ_UPDATE dependencies on MSC_COMPANY_RELATIONSHIPS

Line 376: msc_company_relationships rel,

372: FROM msc_item_suppliers mis,
373: msc_trading_partner_maps map,
374: msc_trading_partners mtp,
375: msc_trading_partner_maps map1,
376: msc_company_relationships rel,
377: msc_trading_partner_maps map2
378: WHERE mis.inventory_item_id = p_i_item_id
379: AND mis.plan_id = -1
380: AND mis.organization_id = mtp.sr_tp_id

Line 407: msc_company_relationships r

403: msc_trading_partner_maps map,
404: msc_trading_partner_maps map1,
405: msc_trading_partner_maps map2,
406: msc_trading_partners mtp,
407: msc_company_relationships r
408: where mis.inventory_item_id = p_item_id and
409: mis.plan_id = -1 and
410: mis.organization_id = mtp.sr_tp_id and
411: mis.sr_instance_id = mtp.sr_instance_id and

Line 609: msc_company_relationships r

605: INTO l_primary_uom
606: FROM msc_item_customers mic,
607: msc_trading_partner_maps map,
608: msc_trading_partner_maps map1,
609: msc_company_relationships r
610: WHERE mic.inventory_item_id = v_i_item_id(cnt)
611: AND mic.plan_id = -1
612: AND mic.customer_id = map.tp_key
613: AND mic.customer_site_id = map1.tp_key

Line 680: msc_company_relationships r

676: INTO l_tp_uom
677: FROM msc_item_customers mic,
678: msc_trading_partner_maps map,
679: msc_trading_partner_maps map1,
680: msc_company_relationships r
681: WHERE mic.inventory_item_id = v_i_item_id(cnt)
682: AND mic.plan_id = -1
683: AND mic.customer_id = map.tp_key
684: AND mic.customer_site_id = map1.tp_key