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_CL_SUPPLIER_RESP dependencies on MSC_TRADING_PARTNER_MAPS

Line 615: ,msc_trading_partner_maps mtpm

611: ,msc_companies mc
612: ,msc_company_sites mcs
613: ,msc_company_site_id_lid mcsil
614: -- Tables to get Supplier's company_id
615: ,msc_trading_partner_maps mtpm
616: ,msc_company_relationships mcr
617: ,msc_companies mc1
618: -- Tables to get Supplier's company_site_id
619: ,msc_trading_partner_maps mtpm1

Line 619: ,msc_trading_partner_maps mtpm1

615: ,msc_trading_partner_maps mtpm
616: ,msc_company_relationships mcr
617: ,msc_companies mc1
618: -- Tables to get Supplier's company_site_id
619: ,msc_trading_partner_maps mtpm1
620: ,msc_company_sites mcs1
621: -- Table to get global item_id
622: ,msc_system_items mi
623: -- Table to get order type description

Line 666: -- with msc_trading_partner_maps since some order types

662: and mtpm.company_key = mcr.relationship_id
663: and mcr.object_id = mc1.company_id
664: -- ====================================================
665: -- Get the supplier's company_site_id. Use Outer joint
666: -- with msc_trading_partner_maps since some order types
667: -- supplier site is optional
668: -- ====================================================
669: and nvl(ms.supplier_site_id, -99) = mtpm1.tp_key
670: and mtpm1.map_type = 3

Line 734: ,msc_trading_partner_maps mtpm

730: msc_supplies ms
731: -- Table to get org equivalent company_site_id
732: ,msc_company_site_id_lid mcsil
733: -- Tables to get Supplier's company_id
734: ,msc_trading_partner_maps mtpm
735: ,msc_company_relationships mcr
736: -- Tables to get Supplier's company_site_id
737: ,msc_trading_partner_maps mtpm1
738: -- Table to get global item_id

Line 737: ,msc_trading_partner_maps mtpm1

733: -- Tables to get Supplier's company_id
734: ,msc_trading_partner_maps mtpm
735: ,msc_company_relationships mcr
736: -- Tables to get Supplier's company_site_id
737: ,msc_trading_partner_maps mtpm1
738: -- Table to get global item_id
739: ,msc_system_items mi
740: where
741: ms.sr_instance_id = p_sr_instance_id

Line 774: -- with msc_trading_partner_maps since some order types

770: and mtpm.map_type = 1
771: and mtpm.company_key = mcr.relationship_id
772: -- ====================================================
773: -- Get the supplier's company_site_id. Use Outer joint
774: -- with msc_trading_partner_maps since some order types
775: -- supplier site is optional
776: -- ====================================================
777: and ms.supplier_site_id = mtpm1.tp_key
778: and mtpm1.map_type = 3