APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_TP_SITE_ID_LID

Line 571: log_message('MSC.MSC_TP_SITE_ID_LID');

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;
573: execute immediate x_grant_sql;
574:
575: log_message('MSC.MSC_REGIONS');

Line 572: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_SITE_ID_LID TO ' || x_dem_schema;

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;
573: execute immediate x_grant_sql;
574:
575: log_message('MSC.MSC_REGIONS');
576: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_REGIONS TO ' || x_dem_schema;

Line 1627: msc_tp_site_id_lid mtsil

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
1631: AND mtil.tp_id = mtp.partner_id

Line 1645: msc_tp_site_id_lid mtsil, '

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 ||
1649: ' AND mtil.tp_id = mtp.partner_id

Line 1673: SELECT /* INDEX(mtpsil MSC_TP_SITE_ID_LID_N1) */

1669:
1670: IF (p_customer_site_id IS NOT NULL)
1671: THEN
1672:
1673: SELECT /* INDEX(mtpsil MSC_TP_SITE_ID_LID_N1) */
1674: to_char(p_sr_instance_id) || '::' || to_char(mtpsil.sr_tp_site_id)
1675: INTO x_site
1676: FROM msc_tp_site_id_lid mtpsil
1677: WHERE

Line 1676: FROM msc_tp_site_id_lid mtpsil

1672:
1673: SELECT /* INDEX(mtpsil MSC_TP_SITE_ID_LID_N1) */
1674: to_char(p_sr_instance_id) || '::' || to_char(mtpsil.sr_tp_site_id)
1675: INTO x_site
1676: FROM msc_tp_site_id_lid mtpsil
1677: WHERE
1678: mtpsil.tp_site_id = p_customer_site_id
1679: AND mtpsil.sr_instance_id = p_sr_instance_id
1680: AND mtpsil.partner_type = 2;

Line 1689: msc_tp_site_id_lid mtsil, '

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 ||
1693: ' AND mtps.tp_site_code = ''SHIP_TO''