APPS.MSC_X_UTIL dependencies on MSC_TRADING_PARTNER_SITES

Line 583: msc_trading_partner_sites tp_sites,

579: SELECT tps.sr_tp_site_id into
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

Line 1012: FROM msc_trading_partner_sites tp_sites,

1008: when too_many_rows then
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

Line 1309: msc_trading_partner_sites mtps

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
1313: and mtps.partner_type = a_partner_type;

Line 1319: msc_trading_partner_sites mtps

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
1323: and mtps.partner_type = a_partner_type