APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_COMPANY_SITE_ID_LID

Line 613: ,msc_company_site_id_lid mcsil

609: msc_supplies ms
610: -- Table to get org equivalent company_site_id
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

Line 638: -- Join with msc_company_site_id_lid to get org equivalent company_site_id

634: -- Get only ODS records
635: -- ====================
636: and ms.plan_id = G_PLAN_ID
637: -- =======================================================================
638: -- Join with msc_company_site_id_lid to get org equivalent company_site_id
639: -- =======================================================================
640: and ms.organization_id = mcsil.sr_company_site_id
641: and ms.sr_instance_id = mcsil.sr_instance_id
642: and mcsil.partner_type = G_ORGANIZATION

Line 732: ,msc_company_site_id_lid mcsil

728: ,ms.NEED_BY_DATE request_date
729: from
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

Line 753: -- Join with msc_company_site_id_lid to get org equivalent company_site_id

749: -- Get only ODS records
750: -- ====================
751: and ms.plan_id = G_PLAN_ID
752: -- =======================================================================
753: -- Join with msc_company_site_id_lid to get org equivalent company_site_id
754: -- =======================================================================
755: and ms.organization_id = mcsil.sr_company_site_id
756: and ms.sr_instance_id = mcsil.sr_instance_id
757: and mcsil.partner_type = G_ORGANIZATION