APPS.MSC_GET_NAME dependencies on MSC_TRADING_PARTNER_SITES

Line 434: from msc_trading_partner_sites s

430: and sr_instance_id = arg_instance_id;
431: ELSE
432: select location
433: into loc_code
434: from msc_trading_partner_sites s
435: where s.sr_tp_id = arg_org_id
436: and s.sr_instance_id = arg_instance_id;
437: END IF;
438:

Line 1324: from msc_trading_partner_sites

1320: supplier_site varchar2(240);
1321:
1322: cursor c_supplier_site is
1323: select tp_site_code
1324: from msc_trading_partner_sites
1325: where partner_site_id=arg_supplier_site_id;
1326:
1327: cursor c_supplier_site_tp is
1328: select tp_site_code

Line 1329: from msc_trading_partner_sites

1325: where partner_site_id=arg_supplier_site_id;
1326:
1327: cursor c_supplier_site_tp is
1328: select tp_site_code
1329: from msc_trading_partner_sites
1330: where sr_tp_site_id=arg_supplier_site_id;
1331:
1332: fetched number :=0;
1333:

Line 1384: from msc_trading_partner_sites

1380: return null;
1381: end if;
1382: select location
1383: into customer_site
1384: from msc_trading_partner_sites
1385: where partner_site_id=arg_customer_site_id;
1386:
1387: return customer_site;
1388:

Line 1400: from msc_trading_partner_sites

1396: return null;
1397: end if;
1398: select PARTNER_ADDRESS
1399: into customer_address
1400: from msc_trading_partner_sites
1401: where partner_site_id=arg_customer_site_id;
1402:
1403: return customer_address;
1404: