APPS.JTF_PHY_MEDIA_PVT SQL Statements

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

Line: 61

    select a.item_id
      into l_logid
    from
      jtf_dsp_obj_lgl_ctnt a,
      jtf_dsp_context_b b
    where
      a.object_id = p_pid and
      a.context_id = b.context_id and
      b.access_name = p_dcname and
      a.object_type = 'I' ;

Line: 84

      select a.item_id
        into l_logid
      from
        jtf_dsp_obj_lgl_ctnt a,
        jtf_dsp_context_b b
      where
        a.object_id = p_catgid and
        a.context_id = b.context_id and
        b.access_name = p_dcname and
        a.object_type = 'C' ;

Line: 107

        select item_id
          into l_logid
        from
     	  jtf_dsp_context_b
        where
          access_name = p_dcname;

Line: 137

    select a.file_name, b.description, a.file_id
      into l_filename, l_description, l_fileid

    from
      jtf_amv_attachments a,
      jtf_amv_items_vl b,
      jtf_dsp_lgl_phys_map c
    where
      c.item_id = l_logid and
      c.msite_id = p_siteid and
      c.language_code = p_langcode and
      c.item_id = b.item_id and
      c.attachment_id = a.attachment_id and
      a.application_id = 671 and
      b.application_id = 671;

Line: 167

      select a.file_name, b.description, a.file_id
      into l_filename, l_description, l_fileid

      from
        jtf_amv_attachments a,
        jtf_amv_items_vl b,
        jtf_dsp_lgl_phys_map c
      where
        c.item_id = l_logid and
        c.default_site = 'Y' and
        c.language_code = p_langcode and
        c.default_language = 'N' and
        c.attachment_id = a.attachment_id and
        c.item_id = b.item_id and
        a.application_id = 671 and
        b.application_id = 671;

Line: 198

        select a.file_name, b.description, a.file_id
        into l_filename, l_description, l_fileid

        from
          jtf_amv_attachments a,
          jtf_amv_items_vl b,
          jtf_dsp_lgl_phys_map c
        where
          c.item_id = l_logid and
          c.msite_id = p_siteid  and
          c.default_site = 'N' and
          c.default_language = 'Y' and
          c.attachment_id = a.attachment_id and
          c.item_id = b.item_id and
          a.application_id = 671 and
          b.application_id = 671;

Line: 229

          select a.file_name, b.description, a.file_id
            into l_filename, l_description, l_fileid

          from
            jtf_amv_attachments a,
            jtf_amv_items_vl b,
            jtf_dsp_lgl_phys_map c
          where
            c.item_id = l_logid and
            c.default_site = 'Y' and
            c.default_language = 'Y' and
            c.attachment_id = a.attachment_id and
            c.item_id = b.item_id and
            a.application_id = 671 and
            b.application_id = 671;