APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_TP_ID_LID

Line 563: log_message('MSC.MSC_TP_ID_LID');

559: log_message('MSC.MSC_TRADING_PARTNERS');
560: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNERS TO ' || x_dem_schema;
561: execute immediate x_grant_sql;
562:
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');

Line 564: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_ID_LID TO ' || x_dem_schema;

560: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNERS TO ' || x_dem_schema;
561: execute immediate x_grant_sql;
562:
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;

Line 1626: msc_tp_id_lid mtil,

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
1629: mtps.partner_site_id = p_customer_site_id
1630: AND mtp.partner_id = mtps.partner_id

Line 1643: msc_tp_id_lid mtil,

1639: THEN
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