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_RECEIVE_CAPACITY_PKG dependencies on MSC_TRADING_PARTNERS

Line 44: msc_trading_partners tp,

40: map3.tp_key, -- supplier_site aps id
41: item1.ROUNDING_CONTROL_TYPE
42: FROM msc_sup_dem_entries_v sd,
43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,

Line 50: msc_trading_partners tp2,

46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
51: msc_system_items item1
52: WHERE sd.plan_id = -1
53: AND sd.publisher_order_type = SUPPLY_COMMIT
54: AND sd.bucket_Type = G_DAY

Line 120: msc_trading_partners tp,

116: map3.tp_key,
117: item1.ROUNDING_CONTROL_TYPE
118: FROM msc_sup_dem_entries_v sd,
119: msc_trading_partner_maps map1,
120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,

Line 127: msc_trading_partners tp2,

123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
128: msc_system_items item1
129: WHERE sd.plan_id = -1
130: AND sd.publisher_order_type = SUPPLY_COMMIT
131: AND sd.bucket_Type = G_WEEK

Line 204: msc_trading_partners tp,

200: map3.tp_key,
201: item1.ROUNDING_CONTROL_TYPE
202: FROM msc_sup_dem_entries_v sd,
203: msc_trading_partner_maps map1,
204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,

Line 211: msc_trading_partners tp2,

207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
212: msc_system_items item1
213: WHERE sd.plan_id = -1
214: AND sd.publisher_order_type = SUPPLY_COMMIT
215: AND sd.bucket_Type = G_MONTH

Line 275: msc_trading_partners tp,

271: p_bucket_type IN NUMBER) IS
272: SELECT sum(sd.tp_quantity)
273: FROM msc_sup_dem_entries_v sd,
274: msc_trading_partner_maps map1,
275: msc_trading_partners tp,
276: msc_system_items item
277: WHERE sd.plan_id = -1
278: AND sd.publisher_order_type = SUPPLY_COMMIT
279: AND map1.tp_key = tp.partner_id

Line 323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;

319: p_mps_designator_id IN Number,
320: p_overwrite in Number,
321: p_spread in number) IS
322:
323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;
324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;

Line 339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;

335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;
342: l_calendar_code msc_trading_partners.calendar_code%type;
343: l_aps_organization_id msc_item_suppliers.organization_id%type;

Line 340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;

336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;
342: l_calendar_code msc_trading_partners.calendar_code%type;
343: l_aps_organization_id msc_item_suppliers.organization_id%type;
344: l_aps_supplier_id msc_item_suppliers.supplier_id%type;

Line 341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;

337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;
342: l_calendar_code msc_trading_partners.calendar_code%type;
343: l_aps_organization_id msc_item_suppliers.organization_id%type;
344: l_aps_supplier_id msc_item_suppliers.supplier_id%type;
345: l_aps_supplier_site_id msc_item_suppliers.supplier_site_id%type;

Line 342: l_calendar_code msc_trading_partners.calendar_code%type;

338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;
342: l_calendar_code msc_trading_partners.calendar_code%type;
343: l_aps_organization_id msc_item_suppliers.organization_id%type;
344: l_aps_supplier_id msc_item_suppliers.supplier_id%type;
345: l_aps_supplier_site_id msc_item_suppliers.supplier_site_id%type;
346: l_rounding_control number;

Line 348: l_org_code msc_trading_partners.organization_code%type;

344: l_aps_supplier_id msc_item_suppliers.supplier_id%type;
345: l_aps_supplier_site_id msc_item_suppliers.supplier_site_id%type;
346: l_rounding_control number;
347: l_bucket_type msc_sup_dem_entries.bucket_type%type;
348: l_org_code msc_trading_partners.organization_code%type;
349: l_plan_id Number := -1; --ods load
350: l_collected_flag Number := 3; --means from destination
351: l_capacity Number;
352: l_err_text Varchar2(2000);

Line 384: FROM msc_trading_partners

380: the instance.
381:
382: Cursor get_org_c(p_sr_instance_id IN Number) IS
383: SELECT distinct sr_tp_id, organization_code
384: FROM msc_trading_partners
385: WHERE sr_instance_id = p_sr_instance_id
386: AND partner_type = 3
387: AND company_id is null; -- if type is 3 (org) then use sr_tp_id
388:

Line 396: FROM msc_item_suppliers mis, msc_trading_partners tp

392: p_aps_supplier_id In Number,
393: p_aps_supplier_site_id In Number,
394: p_item_id In Number) IS
395: SELECT distinct mis.organization_id, tp.organization_code
396: FROM msc_item_suppliers mis, msc_trading_partners tp
397: WHERE plan_id = -1
398: AND mis.sr_instance_id = p_sr_instance_id
399: AND mis.supplier_id = p_aps_supplier_id
400: AND mis.supplier_site_id = p_aps_supplier_site_id

Line 461: msc_trading_partners tp

457: INTO l_map_supplier_id
458: FROM msc_trading_partner_maps map1,
459: msc_company_relationships rel,
460: msc_companies c,
461: msc_trading_partners tp
462: WHERE rel.relationship_type =2 AND --supplier
463: rel.object_id = c.company_id AND
464: rel.subject_id = 1 AND --other company (OEM)
465: rel.relationship_id = map1.company_key AND

Line 490: msc_trading_partners tp,

486: INTO l_map_supplier_site_id
487: FROM msc_trading_partner_maps map1,
488: msc_companies c,
489: msc_company_sites s,
490: msc_trading_partners tp,
491: msc_trading_partner_sites tps
492: WHERE map1.map_type = 3 AND
493: map1.tp_key = tps.partner_site_id AND
494: tps.partner_site_id = p_supplier_site_id AND

Line 655: msc_trading_partners tp

651: INTO l_aps_supplier_id
652: FROM msc_trading_partner_maps map1,
653: msc_company_relationships rel,
654: msc_item_suppliers sup,
655: msc_trading_partners tp
656: WHERE rel.relationship_type =2 AND --supplier
657: rel.object_id = l_sce_supplier_id AND
658: rel.subject_id = 1 AND --other company (OEM)
659: rel.relationship_id = map1.company_key AND

Line 687: msc_trading_partners tp,

683: INTO l_aps_supplier_site_id
684: FROM msc_trading_partner_maps map1,
685: msc_companies c,
686: msc_company_sites s,
687: msc_trading_partners tp,
688: msc_trading_partner_sites tps
689: WHERE map1.map_type = 3 AND
690: map1.tp_key = tps.partner_site_id AND
691: tp.partner_id = tps.partner_id AND

Line 718: msc_trading_partners tp

714: INTO l_map_supplier_id
715: FROM msc_trading_partner_maps map1,
716: msc_company_relationships rel,
717: msc_companies c,
718: msc_trading_partners tp
719: WHERE rel.relationship_type =2 AND --supplier
720: rel.object_id = c.company_id AND
721: rel.subject_id = 1 AND --other company (OEM)
722: rel.relationship_id = map1.company_key AND

Line 745: msc_trading_partners tp,

741: INTO l_map_supplier_site_id
742: FROM msc_trading_partner_maps map1,
743: msc_companies c,
744: msc_company_sites s,
745: msc_trading_partners tp,
746: msc_trading_partner_sites tps
747: WHERE map1.map_type = 3 AND
748: map1.tp_key = tps.partner_site_id AND
749: tps.partner_site_id = l_aps_supplier_site_id AND

Line 1030: l_mod_org_code msc_trading_partners.organization_code%type;

1026: l_end_date Date;
1027: l_num_day Number;
1028: i Number;
1029: l_mod_org_id Number := -1;
1030: l_mod_org_code msc_trading_partners.organization_code%type;
1031: l_cal_sr_instance_id Number;
1032: l_cal_org_id Number;
1033: l_calendar_code msc_trading_partners.calendar_code%type;
1034:

Line 1033: l_calendar_code msc_trading_partners.calendar_code%type;

1029: l_mod_org_id Number := -1;
1030: l_mod_org_code msc_trading_partners.organization_code%type;
1031: l_cal_sr_instance_id Number;
1032: l_cal_org_id Number;
1033: l_calendar_code msc_trading_partners.calendar_code%type;
1034:
1035: lv_avg number;
1036: lv_diff number;
1037: lv_new_x number;

Line 1060: FROM msc_trading_partners tp

1056: --------------------------------------------------------------------*/
1057: BEGIN
1058: SELECT distinct tp.sr_tp_id, tp.organization_code
1059: INTO l_mod_org_id, l_mod_org_code
1060: FROM msc_trading_partners tp
1061: WHERE tp.sr_instance_id = p_sr_instance_id AND
1062: tp.modeled_supplier_id = p_supplier_id AND
1063: tp.modeled_supplier_site_id = p_supplier_site_id AND
1064: tp.partner_type = 3 AND

Line 1806: l_supplier_name msc_trading_partners.partner_name%type;

1802:
1803: l_nextid Number;
1804: l_user_id Number := fnd_global.user_id;
1805: l_refresh_number Number;
1806: l_supplier_name msc_trading_partners.partner_name%type;
1807: l_supplier_site_name msc_trading_partner_sites.tp_site_code%type;
1808: l_desc msc_designators.description%type;
1809: BEGIN
1810:

Line 1821: from msc_trading_partners

1817:
1818: begin
1819: select partner_name
1820: into l_supplier_name
1821: from msc_trading_partners
1822: where partner_id = p_supplier_id
1823: and partner_type = 1;
1824:
1825: select tp_site_code