APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_TRADING_PARTNERS

Line 515: from msc_trading_partners

511: if (l_consigned_flag = CONSIGNED) then
512: if (l_source_org_id <> NOT_EXISTS) and (l_source_org_id is not null) then
513: select organization_code
514: into l_supplier_site_name
515: from msc_trading_partners
516: where partner_type = 3
517: and sr_instance_id = l_sr_instance_id
518: and sr_tp_id = l_source_org_id;
519: print_debug_info(' Source Org: '|| l_supplier_site_name);

Line 842: msc_trading_partners mtp,

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,
844: msc_trading_partner_maps map2,
845: msc_company_relationships mcr
846: , msc_vmi_temp mvt

Line 960: msc_trading_partners mtp,

956: msc_companies customer,
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

Line 1113: msc_trading_partners tp

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)
1117: and tp.partner_id = maps.tp_key

Line 2032: msc_trading_partners mtp,

2028: , mtp.partner_name
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

Line 2235: msc_trading_partners mtp,

2231:
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

Line 2301: msc_trading_partners mtp,

2297: , sd.publisher_order_type_desc
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

Line 2881: , msc_trading_partners mtp

2877: , msi.forecast_horizon
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