APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_SYSTEM_ITEMS

Line 839: msc_system_items msi,

835: -- msc_planners mp,
836: msc_companies customer,
837: msc_company_sites customer_site,
838: msc_companies oem,
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,

Line 967: msc_system_items msi,

963: -- msc_planners mp,
964: msc_companies customer,
965: msc_company_sites customer_site,
966: msc_companies oem,
967: msc_system_items msi,
968: msc_trading_partners mtp,
969: msc_trading_partner_maps map1,
970: msc_trading_partner_maps map2,
971: msc_company_relationships mcr

Line 1828: , msc_system_items msi

1824: BEGIN
1825: SELECT mp.user_name
1826: INTO l_supplier_contact
1827: FROM msc_planners mp
1828: , msc_system_items msi
1829: WHERE msi.plan_id = -1 -- p_plan_id
1830: AND msi.organization_id = p_customer_model_org_id
1831: AND msi.inventory_item_id = p_inventory_item_id
1832: AND msi.sr_instance_id = p_sr_instance_id

Line 2042: msc_system_items msi,

2038: , nvl(msi.vmi_maximum_days, -1)
2039: , nvl(mvt.average_daily_demand, 0)
2040: , mtp.partner_name
2041: FROM
2042: msc_system_items msi,
2043: msc_sup_dem_entries sd,
2044: msc_trading_partners mtp,
2045: msc_trading_partner_maps map1,
2046: msc_trading_partner_maps map2,

Line 2245: msc_system_items msi,

2241: , mtp.partner_name
2242: , sd.publisher_order_type_desc
2243:
2244: FROM
2245: msc_system_items msi,
2246: msc_sup_dem_entries sd,
2247: msc_trading_partners mtp,
2248: msc_trading_partner_maps map1,
2249: msc_trading_partner_maps map2,

Line 2311: msc_system_items msi,

2307: , sd.END_ORDER_LINE_NUMBER
2308: , mtp.partner_name
2309: , sd.publisher_order_type_desc
2310: FROM
2311: msc_system_items msi,
2312: msc_sup_dem_entries sd,
2313: msc_trading_partners mtp,
2314: msc_trading_partner_maps map1,
2315: msc_trading_partner_maps map2,

Line 2892: FROM msc_system_items msi

2888: , mtp.modeled_customer_site_id
2889: , msi.forecast_horizon
2890: , msi.vmi_forecast_type
2891: , mvt.average_daily_demand
2892: FROM msc_system_items msi
2893: , msc_trading_partners mtp
2894: , msc_vmi_temp mvt
2895: WHERE msi.inventory_planning_code = 7 -- (?)
2896: AND msi.organization_id = mtp.sr_tp_id

Line 2923: UPDATE msc_system_items

2919: || '-' || forecast_item.sr_instance_id
2920: || '-' || forecast_item.modeled_customer_id
2921: || '-' || forecast_item.modeled_customer_site_id
2922: );
2923: UPDATE msc_system_items
2924: SET vmi_refresh_flag = 0
2925: WHERE plan_id = forecast_item.plan_id
2926: AND inventory_item_id = forecast_item.inventory_item_id
2927: AND organization_id = forecast_item.organization_id