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_TRADING_PARTNERS

Line 374: msc_trading_partners mtp,

370: p_i_pub_site_id IN NUMBER) IS
371: SELECT mis.uom_code
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

Line 406: msc_trading_partners mtp,

402: FROM msc_item_suppliers mis,
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

Line 546: msc_trading_partners part,

542: BEGIN
543: SELECT msi.uom_code
544: INTO l_primary_uom
545: FROM msc_system_items msi,
546: msc_trading_partners part,
547: msc_trading_partner_maps map
548: WHERE msi.inventory_item_id = v_i_item_id(cnt)
549: AND msi.organization_id = part.sr_tp_id
550: AND msi.sr_instance_id = part.sr_instance_id

Line 577: msc_trading_partners part,

573: BEGIN
574: SELECT msi.uom_code
575: INTO l_primary_uom
576: FROM msc_system_items msi,
577: msc_trading_partners part,
578: msc_trading_partner_maps map
579: WHERE msi.inventory_item_id = v_i_item_id(cnt)
580: AND msi.organization_id = part.sr_tp_id
581: AND msi.sr_instance_id = part.sr_instance_id

Line 628: msc_trading_partners part,

624: BEGIN
625: SELECT msi.uom_code
626: INTO l_primary_uom
627: FROM msc_system_items msi,
628: msc_trading_partners part,
629: msc_trading_partner_maps map
630: WHERE msi.inventory_item_id = v_i_item_id(cnt)
631: AND msi.organization_id = part.sr_tp_id
632: AND msi.sr_instance_id = part.sr_instance_id

Line 659: msc_trading_partners part,

655: BEGIN
656: SELECT msi.uom_code
657: INTO l_tp_uom
658: FROM msc_system_items msi,
659: msc_trading_partners part,
660: msc_trading_partner_maps map
661: WHERE msi.inventory_item_id = v_i_item_id(cnt)
662: AND msi.organization_id = part.sr_tp_id
663: AND msi.sr_instance_id = part.sr_instance_id

Line 706: msc_trading_partners part,

702: BEGIN
703: SELECT msi.uom_code
704: INTO l_tp_uom
705: FROM msc_system_items msi,
706: msc_trading_partners part,
707: msc_trading_partner_maps map
708: WHERE msi.inventory_item_id = v_i_item_id(cnt)
709: AND msi.organization_id = part.sr_tp_id
710: AND msi.sr_instance_id = part.sr_instance_id