APPS.JTF_LOG_TO_PHY_PVT SQL Statements

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

Line: 61

    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: 90

      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: 120

        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: 149

          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;

Line: 268

    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
      b.access_name = l_accessname 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: 298

      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
        b.access_name = l_accessname 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: 328

        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
          b.access_name = l_accessname 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: 359

          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
            b.access_name = l_accessname 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;