APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_SYSTEM_ITEMS

Line 622: ,msc_system_items mi

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
624: ,fnd_lookup_values flv
625: where
626: ms.sr_instance_id = p_sr_instance_id

Line 651: -- Join with msc_system_items to get Item related information

647: -- Make sure that Sales Orders for OEM are published
648: -- =================================================
649: and mcs.company_id = G_OEM_ID
650: -- ==========================================================
651: -- Join with msc_system_items to get Item related information
652: -- ==========================================================
653: and ms.inventory_item_id = mi.inventory_item_id
654: and ms.organization_id = mi.organization_id
655: and ms.sr_instance_id = mi.sr_instance_id

Line 739: ,msc_system_items mi

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
742: -- =====================================================================
743: -- Get Supplier Sales Order related transactions and also make sure that

Line 760: -- Join with msc_system_items to get Item related information

756: and ms.sr_instance_id = mcsil.sr_instance_id
757: and mcsil.partner_type = G_ORGANIZATION
758: and mcsil.sr_company_id = G_SR_OEM_ID
759: -- ==========================================================
760: -- Join with msc_system_items to get Item related information
761: -- ==========================================================
762: and ms.inventory_item_id = mi.inventory_item_id
763: and ms.organization_id = mi.organization_id
764: and ms.sr_instance_id = mi.sr_instance_id