APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_COMPANY_SITES

Line 1756: l_customer_site_name msc_company_sites.company_site_name%type;

1752: l_min_cust NUMBER := 0;
1753: l_min_supp NUMBER := 0;
1754:
1755: l_customer_name msc_companies.company_name%type;
1756: l_customer_site_name msc_company_sites.company_site_name%type;
1757: l_supplier_name msc_companies.company_name%type;
1758: l_supplier_site_name msc_company_sites.company_site_name%type;
1759:
1760: BEGIN

Line 1758: l_supplier_site_name msc_company_sites.company_site_name%type;

1754:
1755: l_customer_name msc_companies.company_name%type;
1756: l_customer_site_name msc_company_sites.company_site_name%type;
1757: l_supplier_name msc_companies.company_name%type;
1758: l_supplier_site_name msc_company_sites.company_site_name%type;
1759:
1760: BEGIN
1761: log_message(' p_sr_instance_id : ' || p_sr_instance_id);
1762: log_message(' p_customer_id : ' || p_customer_id);

Line 1777: from msc_companies c1, msc_company_sites c2

1773: --------------------------------------------------------------*/
1774: /*
1775: select c1.company_name, c2.company_site_name
1776: into l_supplier_name, l_supplier_site_name
1777: from msc_companies c1, msc_company_sites c2
1778: where c1.company_id = p_supplier_id
1779: and c1.company_id = c2.company_id
1780: and c2.company_site_id = p_supplier_site_id;
1781:

Line 1784: from msc_companies c1, msc_company_sites c2

1780: and c2.company_site_id = p_supplier_site_id;
1781:
1782: select c1.company_name, c2.company_site_name
1783: into l_customer_name, l_customer_site_name
1784: from msc_companies c1, msc_company_sites c2
1785: where c1.company_id = p_customer_id
1786: and c1.company_id = c2.company_id
1787: and c2.company_site_id = p_customer_site_id;
1788: