APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_TRADING_PARTNERS

Line 559: log_message('MSC.MSC_TRADING_PARTNERS');

555: log_message('MSC.MSC_PLAN_ORGANIZATIONS');
556: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLAN_ORGANIZATIONS TO ' || x_dem_schema;
557: execute immediate x_grant_sql;
558:
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');

Line 560: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TRADING_PARTNERS TO ' || x_dem_schema;

556: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLAN_ORGANIZATIONS TO ' || x_dem_schema;
557: execute immediate x_grant_sql;
558:
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;

Line 1485: from msc_trading_partners

1481: and using_organization_id = p_using_organization_id;
1482:
1483: cursor c2 (p_sr_instance_id IN NUMBER, p_organization_id IN number) IS
1484: select calendar_code
1485: from msc_trading_partners
1486: where partner_type = 3
1487: and sr_tp_id = p_organization_id
1488: and sr_instance_id = p_sr_instance_id;
1489:

Line 1625: msc_trading_partners mtp,

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
1629: mtps.partner_site_id = p_customer_site_id

Line 1642: FROM msc_trading_partners mtp,

1638: ELSIF (p_customer_id IS NOT NULL)
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

Line 1811: msc_trading_partners

1807: calendar_code
1808: INTO
1809: x_calendar_code
1810: FROM
1811: msc_trading_partners
1812: WHERE
1813: partner_type = 3
1814: AND sr_tp_id = x_organization_id
1815: AND sr_instance_id = x_sr_instance_id;

Line 3640: msc_trading_partners mtp_app_org '

3636: BEGIN
3637:
3638: x_sql := 'select '':'' || mtp_app_org.partner_name '
3639: || 'from msc_location_associations mla,
3640: msc_trading_partners mtp_app_org '
3641: || 'where mla.sr_instance_id = ' || p_sr_instance_id
3642: || 'and mla.partner_id = ' || p_partner_id
3643: || 'and mla.partner_site_id = ' || p_tp_site_id
3644: || 'and mtp_app_org.sr_instance_id = mla.sr_instance_id '