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 968: msc_trading_partners mtp,

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

Line 1125: msc_trading_partners tp

1121:
1122: select maps.company_key
1123: into l_source_site_id
1124: from msc_trading_partner_maps maps,
1125: msc_trading_partners tp
1126: where tp.partner_type = 3
1127: and tp.sr_instance_id = t_sr_instance_id(j)
1128: and tp.sr_tp_id = t_source_org_id(j)
1129: and tp.partner_id = maps.tp_key

Line 2044: msc_trading_partners mtp,

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,
2047: msc_company_relationships mcr
2048: , msc_vmi_temp mvt

Line 2247: msc_trading_partners mtp,

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,
2250: msc_company_relationships mcr
2251: , msc_vmi_temp mvt

Line 2313: msc_trading_partners mtp,

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,
2316: msc_company_relationships mcr
2317: WHERE

Line 2893: , msc_trading_partners mtp

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