DBA Data[Home] [Help]

APPS.MSC_X_CVMI_PLANNING dependencies on MSC_TRADING_PARTNERS

Line 41: , msc_trading_partners mtp

37: , msi.vmi_forecast_type
38: , msi.uom_code
39: , mvt.average_daily_demand
40: FROM msc_system_items msi
41: , msc_trading_partners mtp
42: , msc_vmi_temp mvt
43: WHERE msi.inventory_planning_code = 7
44: AND msi.organization_id = mtp.sr_tp_id
45: AND msi.sr_instance_id = mtp.sr_instance_id

Line 359: , msc_trading_partners tp

355:
356: CURSOR c_company_key_2 IS
357: SELECT map.company_key
358: FROM msc_trading_partner_maps map
359: , msc_trading_partners tp
360: WHERE map.map_type = p_map_type
361: AND tp.partner_id = map.tp_key
362: AND tp.sr_tp_id = p_tp_key
363: AND tp.sr_instance_id = p_sr_instance_id

Line 423: , msc_trading_partners tp

419:
420: CURSOR c_tp_key_2 IS
421: SELECT tp.sr_tp_id
422: FROM msc_trading_partner_maps map
423: , msc_trading_partners tp
424: WHERE map.map_type = p_map_type
425: AND tp.partner_id = map.tp_key
426: AND map.company_key= p_company_key
427: ;