APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_COMPANY_RELATIONSHIPS

Line 845: msc_company_relationships mcr

841: msc_sup_dem_entries sd,
842: msc_trading_partners mtp,
843: msc_trading_partner_maps map1,
844: msc_trading_partner_maps map2,
845: msc_company_relationships mcr
846: , msc_vmi_temp mvt
847: WHERE
848: -- mpc.partner_type (+)= 2 ---Customer
849: -- AND mpc.sr_instance_id (+)= mtp.sr_instance_id

Line 963: msc_company_relationships mcr

959: msc_system_items msi,
960: msc_trading_partners mtp,
961: msc_trading_partner_maps map1,
962: msc_trading_partner_maps map2,
963: msc_company_relationships mcr
964: , msc_vmi_temp mvt
965: WHERE
966: -- mpc.partner_type (+)= 2 ---Customer
967: -- AND mpc.sr_instance_id (+)= mtp.sr_instance_id

Line 2035: msc_company_relationships mcr

2031: msc_sup_dem_entries sd,
2032: msc_trading_partners mtp,
2033: msc_trading_partner_maps map1,
2034: msc_trading_partner_maps map2,
2035: msc_company_relationships mcr
2036: , msc_vmi_temp mvt
2037: WHERE
2038: msi.inventory_planning_code = VMI_PLANNING_METHOD
2039: AND msi.sr_instance_id = mtp.sr_instance_id

Line 2238: msc_company_relationships mcr

2234: msc_sup_dem_entries sd,
2235: msc_trading_partners mtp,
2236: msc_trading_partner_maps map1,
2237: msc_trading_partner_maps map2,
2238: msc_company_relationships mcr
2239: , msc_vmi_temp mvt
2240: WHERE
2241: msi.inventory_planning_code = VMI_PLANNING_METHOD
2242: AND msi.sr_instance_id = mtp.sr_instance_id

Line 2304: msc_company_relationships mcr

2300: msc_sup_dem_entries sd,
2301: msc_trading_partners mtp,
2302: msc_trading_partner_maps map1,
2303: msc_trading_partner_maps map2,
2304: msc_company_relationships mcr
2305: WHERE
2306: msi.inventory_planning_code = VMI_PLANNING_METHOD
2307: AND msi.sr_instance_id = mtp.sr_instance_id
2308: AND msi.organization_id = mtp.sr_tp_id