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 972: , msc_vmi_temp mvt

968: msc_trading_partners mtp,
969: msc_trading_partner_maps map1,
970: msc_trading_partner_maps map2,
971: msc_company_relationships mcr
972: , msc_vmi_temp mvt
973: WHERE
974: -- mpc.partner_type (+)= 2 ---Customer
975: -- AND mpc.sr_instance_id (+)= mtp.sr_instance_id
976: -- AND mpc.partner_site_id (+)= mtp.modeled_customer_site_id

Line 2048: , msc_vmi_temp mvt

2044: msc_trading_partners mtp,
2045: msc_trading_partner_maps map1,
2046: msc_trading_partner_maps map2,
2047: msc_company_relationships mcr
2048: , msc_vmi_temp mvt
2049: WHERE
2050: msi.inventory_planning_code = VMI_PLANNING_METHOD
2051: AND msi.sr_instance_id = mtp.sr_instance_id
2052: AND msi.organization_id = mtp.sr_tp_id

Line 2251: , msc_vmi_temp mvt

2247: msc_trading_partners mtp,
2248: msc_trading_partner_maps map1,
2249: msc_trading_partner_maps map2,
2250: msc_company_relationships mcr
2251: , msc_vmi_temp mvt
2252: WHERE
2253: msi.inventory_planning_code = VMI_PLANNING_METHOD
2254: AND msi.sr_instance_id = mtp.sr_instance_id
2255: AND msi.organization_id = mtp.sr_tp_id

Line 2339: FROM msc_vmi_temp mvt

2335: AND sd.primary_quantity > 0
2336: AND msi.drp_planned = 1 -- drp planned item
2337: AND msi.consigned_flag = 1 -- consigned item
2338: AND NOT EXISTS(SELECT mvt.inventory_item_id
2339: FROM msc_vmi_temp mvt
2340: WHERE mvt.plan_id = msi.plan_id
2341: and mvt.inventory_item_id = msi.inventory_item_id
2342: and mvt.organization_id = msi.organization_id
2343: and mvt.sr_instance_id = msi.sr_instance_id

Line 2894: , msc_vmi_temp mvt

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
2897: AND msi.sr_instance_id = mtp.sr_instance_id
2898: AND mtp.partner_type = 3 -- org