APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_TRADING_PARTNER_SITES

Line 567: log_message('MSC.MSC_TRADING_PARTNER_SITES');

563: log_message('MSC.MSC_TP_ID_LID');
564: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_ID_LID TO ' || x_dem_schema;
565: execute immediate x_grant_sql;
566:
567: log_message('MSC.MSC_TRADING_PARTNER_SITES');
568: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNER_SITES TO ' || x_dem_schema;
569: execute immediate x_grant_sql;
570:
571: log_message('MSC.MSC_TP_SITE_ID_LID');

Line 568: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNER_SITES TO ' || x_dem_schema;

564: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_ID_LID TO ' || x_dem_schema;
565: execute immediate x_grant_sql;
566:
567: log_message('MSC.MSC_TRADING_PARTNER_SITES');
568: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNER_SITES TO ' || x_dem_schema;
569: execute immediate x_grant_sql;
570:
571: log_message('MSC.MSC_TP_SITE_ID_LID');
572: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_SITE_ID_LID TO ' || x_dem_schema;

Line 1624: FROM msc_trading_partner_sites mtps,

1620: || ':' || mtil.sr_cust_account_number
1621: || ':' || mtps.location
1622: || ':' || mtps.operating_unit_name
1623: INTO x_site
1624: FROM msc_trading_partner_sites mtps,
1625: msc_trading_partners mtp,
1626: msc_tp_id_lid mtil,
1627: msc_tp_site_id_lid mtsil
1628: WHERE

Line 1644: msc_trading_partner_sites mtps,

1640: /* bug#9634704 -- nalkuma*/
1641: l_sql := ' select s.site
1642: FROM msc_trading_partners mtp,
1643: msc_tp_id_lid mtil,
1644: msc_trading_partner_sites mtps,
1645: msc_tp_site_id_lid mtsil, '
1646: || C_MSD_DEM_SCHEMA || '.t_ep_site s
1647: WHERE
1648: mtp.partner_id = ' || p_customer_id ||

Line 1685: l_sql := ' select /* INDEX(mtps MSC_TRADING_PARTNER_SITES_U3) */

1681:
1682: ELSIF (p_customer_id IS NOT NULL)
1683: THEN
1684: /* bug#9634704 -- nalkuma*/
1685: l_sql := ' select /* INDEX(mtps MSC_TRADING_PARTNER_SITES_U3) */
1686: to_char(' || p_sr_instance_id || ') || ''::'' || to_char(mtsil.sr_tp_site_id)
1687: from
1688: msc_trading_partner_sites mtps,
1689: msc_tp_site_id_lid mtsil, '

Line 1688: msc_trading_partner_sites mtps,

1684: /* bug#9634704 -- nalkuma*/
1685: l_sql := ' select /* INDEX(mtps MSC_TRADING_PARTNER_SITES_U3) */
1686: to_char(' || p_sr_instance_id || ') || ''::'' || to_char(mtsil.sr_tp_site_id)
1687: from
1688: msc_trading_partner_sites mtps,
1689: msc_tp_site_id_lid mtsil, '
1690: || C_MSD_DEM_SCHEMA || '.t_ep_site s
1691: WHERE
1692: mtps.partner_id = ' || p_customer_id ||