APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_TRADING_PARTNER_MAPS

Line 843: msc_trading_partner_maps map1,

839: msc_system_items msi,
840: msc_sup_dem_entries sup_dem,
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

Line 844: msc_trading_partner_maps map2,

840: msc_sup_dem_entries sup_dem,
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

Line 961: msc_trading_partner_maps map1,

957: msc_company_sites customer_site,
958: msc_companies oem,
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

Line 962: msc_trading_partner_maps map2,

958: msc_companies oem,
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

Line 1112: from msc_trading_partner_maps maps,

1108: lead time calc func can handle aps id's */
1109:
1110: select maps.company_key
1111: into l_source_site_id
1112: from msc_trading_partner_maps maps,
1113: msc_trading_partners tp
1114: where tp.partner_type = 3
1115: and tp.sr_instance_id = t_sr_instance_id(j)
1116: and tp.sr_tp_id = t_source_org_id(j)

Line 2033: msc_trading_partner_maps map1,

2029: FROM
2030: msc_system_items msi,
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

Line 2034: msc_trading_partner_maps map2,

2030: msc_system_items msi,
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

Line 2236: msc_trading_partner_maps map1,

2232: FROM
2233: msc_system_items msi,
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

Line 2237: msc_trading_partner_maps map2,

2233: msc_system_items msi,
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

Line 2302: msc_trading_partner_maps map1,

2298: FROM
2299: msc_system_items msi,
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

Line 2303: msc_trading_partner_maps map2,

2299: msc_system_items msi,
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