DBA Data[Home] [Help]

APPS.MSC_X_UTIL dependencies on MSC_COMPANY_SITES

Line 1407: msc_company_sites mcs

1403:
1404: select mcs.company_id, mcs.company_site_id
1405: INTO l_customer_id, l_customer_site_id
1406: from msc_companies mc,
1407: msc_company_sites mcs
1408: where mc.company_id = mcs.company_id
1409: and upper(mc.company_name) = upper(p_customer_name)
1410: and upper(mcs.company_site_name) = upper(p_customer_site_name);
1411:

Line 1415: msc_company_sites mcs

1411:
1412: select mcs.company_id, mcs.company_site_id
1413: INTO l_supplier_id, l_supplier_site_id
1414: from msc_companies mc,
1415: msc_company_sites mcs
1416: where mc.company_id = mcs.company_id
1417: and upper(mc.company_name) = upper(p_supplier_name)
1418: and upper(mcs.company_site_name) = upper(p_supplier_site_name);
1419: