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_UTIL dependencies on MSC_TRADING_PARTNER_MAPS

Line 61: msc_trading_partner_maps map

57: SELECT category_name
58: INTO l_category_code
59: FROM msc_item_categories mic,
60: msc_trading_partners tp,
61: msc_trading_partner_maps map
62: WHERE map.company_key = l_org_id
63: and map.map_type = 2
64: and map.tp_key = tp.partner_id
65: and tp.sr_tp_id = mic.organization_id

Line 112: msc_trading_partner_maps map

108:
109: SELECT buyer_name into l_buyer_code
110: FROM msc_system_items msi,
111: msc_trading_partners tp,
112: msc_trading_partner_maps map
113: WHERE map.company_key = l_org_id
114: and map.map_type = 2
115: and map.tp_key = tp.partner_id
116: and tp.sr_tp_id = msi.organization_id

Line 490: FROM msc_trading_partner_maps map

486:
487: BEGIN
488: SELECT tp_key
489: INTO l_tp_org_partner_id
490: FROM msc_trading_partner_maps map
491: WHERE map.map_type = 2
492: and map.company_key = l_org_id;
493: EXCEPTION WHEN OTHERS THEN
494: l_result_date := get_default_res_date(1,

Line 536: msc_trading_partner_maps map,

532: SELECT tpl.sr_tp_id INTO
533: l_tp_customer_id
534: FROM
535: msc_tp_id_lid tpl,
536: msc_trading_partner_maps map,
537: msc_company_relationships rels
538: WHERE tpl.tp_id = map.tp_key
539: and tpl.partner_type = 2
540: and tpl.sr_company_id = -1

Line 570: msc_trading_partner_maps map

566: SELECT tps.sr_tp_site_id into
567: l_tp_customer_site_id
568: FROM
569: msc_tp_site_id_lid tps,
570: msc_trading_partner_maps map
571: WHERE tps.sr_company_id = -1
572: and tps.tp_site_id = map.tp_key
573: and tps.sr_instance_id = l_sr_instance_id
574: and tps.partner_type = 2

Line 584: msc_trading_partner_maps map

580: l_tp_customer_site_id
581: FROM
582: msc_tp_site_id_lid tps,
583: msc_trading_partner_sites tp_sites,
584: msc_trading_partner_maps map
585: WHERE tps.sr_company_id = -1
586: and tps.tp_site_id = tp_sites.partner_site_id
587: and tps.sr_instance_id = l_sr_instance_id
588: and tps.partner_type = 2

Line 737: FROM msc_trading_partner_maps map

733:
734: BEGIN
735: SELECT tp_key
736: INTO l_tp_org_partner_id
737: FROM msc_trading_partner_maps map
738: WHERE map.map_type = 2
739: and map.company_key = l_org_id;
740: EXCEPTION WHEN OTHERS THEN
741: l_result_date := get_default_res_date(1,

Line 781: msc_trading_partner_maps map,

777: BEGIN
778: SELECT map.tp_key INTO
779: l_tp_supplier_id
780: FROM
781: msc_trading_partner_maps map,
782: msc_company_relationships rels
783: WHERE map.map_type = 1
784: and map.company_key = rels.relationship_id
785: and rels.object_id = l_supplier_id

Line 803: msc_trading_partner_maps map

799: BEGIN
800: SELECT map.tp_key INTO
801: l_tp_supplier_site_id
802: FROM
803: msc_trading_partner_maps map
804: WHERE map.map_type = 3
805: and map.company_key = l_supplier_site_id;
806: EXCEPTION WHEN OTHERS THEN
807: l_result_date := get_default_res_date(2,

Line 979: FROM msc_trading_partner_maps map,

975: if (p_map_type = G_ORGANIZATION_MAPPING) then
976:
977: SELECT tp.sr_tp_id,tp.sr_instance_id
978: INTO aps_partner_id, aps_sr_instance_id
979: FROM msc_trading_partner_maps map,
980: msc_trading_partners tp
981: WHERE map.map_type = G_ORGANIZATION_MAPPING
982: AND map.company_key = p_sce_company_site_id
983: AND map.tp_key = tp.partner_id;

Line 990: FROM msc_trading_partner_maps map,

986:
987: --dbms_output.put_line(' Inside SCE TO APS ' );
988: SELECT map.tp_key
989: INTO aps_partner_id
990: FROM msc_trading_partner_maps map,
991: msc_company_relationships cr
992: WHERE map.map_type = G_COMPANY_MAPPING
993: AND cr.object_id = p_sce_company_id
994: AND map.company_key = cr.relationship_id

Line 1004: FROM msc_trading_partner_maps map

1000:
1001: begin
1002: SELECT map.tp_key
1003: INTO aps_partner_site_id
1004: FROM msc_trading_partner_maps map
1005: WHERE map.map_type = G_COMPANY_SITE_MAPPING
1006: AND map.company_key = p_sce_company_site_id;
1007: exception
1008: when too_many_rows then

Line 1013: msc_trading_partner_maps map

1009: BEGIN
1010: SELECT tp_sites.partner_site_id
1011: INTO aps_partner_site_id
1012: FROM msc_trading_partner_sites tp_sites,
1013: msc_trading_partner_maps map
1014: WHERE tp_sites.partner_site_id = map.tp_key
1015: and tp_sites.tp_site_code = 'SHIP_TO'
1016: and tp_sites.partner_type = 2
1017: and map.map_type = G_COMPANY_SITE_MAPPING

Line 1308: from msc_trading_partner_maps mtpm,

1304:
1305: CURSOR C_SHIPPING_CONTROL(a_site_id NUMBER,
1306: a_partner_type NUMBER) IS
1307: SELECT decode(upper(mtps.shipping_control), 'BUYER', 2,1)
1308: from msc_trading_partner_maps mtpm,
1309: msc_trading_partner_sites mtps
1310: where mtpm.company_key = a_site_id
1311: and mtpm.map_type = G_COMPANY_SITE
1312: and mtpm.tp_key = mtps.partner_site_id

Line 1318: from msc_trading_partner_maps mtpm,

1314:
1315: CURSOR C_SHIPPING_CONTROL_SHIP_TO(a_site_id NUMBER,
1316: a_partner_type NUMBER) IS
1317: SELECT decode(upper(mtps.shipping_control), 'BUYER', 2,1)
1318: from msc_trading_partner_maps mtpm,
1319: msc_trading_partner_sites mtps
1320: where mtpm.company_key = a_site_id
1321: and mtpm.map_type = G_COMPANY_SITE
1322: and mtpm.tp_key = mtps.partner_site_id