APPS.MSD_ASCP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

    select mtp.partner_id into v_ret
    from msc_trading_partners mtp, msd_level_values mlv
    where  mtp.sr_instance_id = mlv.instance
      and  mlv.level_id       = p_level_id
      and  mlv.level_pk       = p_level_pk
      and  mtp.partner_type   = 2
      and  mtp.sr_tp_id       = mlv.sr_level_pk;

Line: 21

    select mtp.partner_id into v_ret
    from msc_trading_partners mtp,
         msd_level_values site,
         msd_level_associations mla
    where  site.level_id         = 11
      and  site.level_pk         = p_level_pk
      and  site.instance         = mla.instance
      and  site.sr_level_pk      = mla.sr_level_pk
      and  mtp.partner_type      = 2
      and  to_char(mtp.sr_tp_id) = mla.sr_parent_level_pk
      and  mtp.sr_instance_id    = site.instance;

Line: 53

    select distinct mtps.partner_site_id into v_ret
    from msc_trading_partner_sites mtps,
         msd_level_values site,
         msd_level_associations mla
    where  site.level_id       = p_level_id
      and  site.level_pk       = p_level_pk
      and  mtps.sr_instance_id = site.instance
      and  mtps.partner_type   = 2
      and  mtps.sr_tp_site_id  = site.sr_level_pk
      and  mtps.sr_tp_id       = mla.sr_parent_level_pk
      /* and the customer is... */
      and  mla.sr_level_pk     = site.sr_level_pk
      and  mla.level_id        = 11
      and  mla.parent_level_id = 15
      and  mla.instance        = site.instance;