APPS.MSC_GET_NAME dependencies on MSC_TRADING_PARTNER_SITES

Line 328: from msc_trading_partner_sites s

324: and sr_instance_id = arg_instance_id;
325: ELSE
326: select location
327: into loc_code
328: from msc_trading_partner_sites s
329: where s.sr_tp_id = arg_org_id
330: and s.sr_instance_id = arg_instance_id;
331: END IF;
332:

Line 1163: from msc_trading_partner_sites

1159: return null;
1160: end if;
1161: select tp_site_code
1162: into supplier_site
1163: from msc_trading_partner_sites
1164: where partner_site_id=arg_supplier_site_id;
1165:
1166: return supplier_site;
1167:

Line 1196: from msc_trading_partner_sites

1192: return null;
1193: end if;
1194: select location
1195: into customer_site
1196: from msc_trading_partner_sites
1197: where partner_site_id=arg_customer_site_id;
1198:
1199: return customer_site;
1200:

Line 1212: from msc_trading_partner_sites

1208: return null;
1209: end if;
1210: select PARTNER_ADDRESS
1211: into customer_address
1212: from msc_trading_partner_sites
1213: where partner_site_id=arg_customer_site_id;
1214:
1215: return customer_address;
1216: