eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_VMI_TEMP

Line 846: , msc_vmi_temp mvt

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
850: -- AND mpc.partner_site_id (+)= mtp.modeled_customer_site_id

Line 964: , msc_vmi_temp mvt

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
968: -- AND mpc.partner_site_id (+)= mtp.modeled_customer_site_id

Line 2036: , msc_vmi_temp mvt

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
2040: AND msi.organization_id = mtp.sr_tp_id

Line 2239: , msc_vmi_temp mvt

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
2243: AND msi.organization_id = mtp.sr_tp_id

Line 2327: FROM msc_vmi_temp mvt

2323: AND sd.primary_quantity > 0
2324: AND msi.drp_planned = 1 -- drp planned item
2325: AND msi.consigned_flag = 1 -- consigned item
2326: AND NOT EXISTS(SELECT mvt.inventory_item_id
2327: FROM msc_vmi_temp mvt
2328: WHERE mvt.plan_id = msi.plan_id
2329: and mvt.inventory_item_id = msi.inventory_item_id
2330: and mvt.organization_id = msi.organization_id
2331: and mvt.sr_instance_id = msi.sr_instance_id

Line 2882: , msc_vmi_temp mvt

2878: , msi.vmi_forecast_type
2879: , mvt.average_daily_demand
2880: FROM msc_system_items msi
2881: , msc_trading_partners mtp
2882: , msc_vmi_temp mvt
2883: WHERE msi.inventory_planning_code = 7 -- (?)
2884: AND msi.organization_id = mtp.sr_tp_id
2885: AND msi.sr_instance_id = mtp.sr_instance_id
2886: AND mtp.partner_type = 3 -- org