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_PARTNER_MAPS

Line 373: msc_trading_partner_maps map,

369: p_pub_id IN NUMBER,
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

Line 375: msc_trading_partner_maps map1,

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
379: AND mis.plan_id = -1

Line 377: msc_trading_partner_maps map2

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
381: AND mis.sr_instance_id = mtp.sr_instance_id

Line 403: msc_trading_partner_maps map,

399: p_supp_id NUMBER,
400: p_supp_site_id NUMBER) IS
401: SELECT mis.uom_code
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

Line 404: msc_trading_partner_maps map1,

400: p_supp_site_id NUMBER) IS
401: SELECT mis.uom_code
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

Line 405: msc_trading_partner_maps map2,

401: SELECT mis.uom_code
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

Line 547: msc_trading_partner_maps map

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
551: AND msi.plan_id = -1

Line 578: msc_trading_partner_maps map

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
582: AND msi.plan_id = -1

Line 607: msc_trading_partner_maps map,

603: BEGIN
604: SELECT mic.uom_code
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

Line 608: msc_trading_partner_maps map1,

604: SELECT mic.uom_code
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

Line 629: msc_trading_partner_maps map

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
633: AND msi.plan_id = -1

Line 660: msc_trading_partner_maps map

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
664: AND msi.plan_id = -1

Line 678: msc_trading_partner_maps map,

674: BEGIN
675: SELECT mic.uom_code
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

Line 679: msc_trading_partner_maps map1,

675: SELECT mic.uom_code
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

Line 707: msc_trading_partner_maps map

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
711: AND msi.plan_id = -1