APPS.OKL_JTOT_EXTRACT SQL Statements

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

Line: 21

  SELECT prv.id1,
         prv.id2,
         prv.name,
         prv.description
  FROM  okx_parties_v prv
  WHERE prv.name = NVL(p_name,prv.name)
  AND   prv.id1  = NVL(p_id1,prv.id1)
  AND   prv.id2  = NVL(p_id2,prv.id2)
  ORDER BY prv.name;

Line: 33

  SELECT ord.id1,
         ord.id2,
         ord.name,
         ord.description
  FROM  okx_organization_defs_v ord
  WHERE ord.organization_type = 'OPERATING_UNIT'
  AND   ord.information_type = 'Operating Unit Information'
  AND   ord.name = NVL(p_name,ord.name)
  AND   ord.id1  = NVL(p_id1,ord.id1)
  AND   ord.id2  = NVL(p_id2,ord.id2)
  ORDER BY ord.NAME;

Line: 48

  SELECT  vev.id1,
          vev.id2,
          vev.name,
          vev.description
  FROM okx_vendors_v vev
  WHERE vev.name = NVL(p_name,vev.name)
  AND   vev.id1  = NVL(p_id1,vev.id1)
  AND   vev.id2  = NVL(p_id2,vev.id2)
  ORDER BY vev.NAME;

Line: 83

       select object1_id1,
              object1_id2,
              jtot_object1_code,
              rle_code
       from   OKC_K_PARTY_ROLES_V
       where  rle_code = nvl(p_role_code,rle_code)
       and    nvl(cle_id,-99999)   = p_cle_id
       and    nvl(chr_id,-99999)   = p_chr_id
       and    dnz_chr_id           = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)
       order  by rle_code;

Line: 94

l_select_clause     varchar2(2000) default null;

Line: 363

l_select_clause     varchar2(2000) default null;

Line: 588

    select scs_code,
           rle_code
    from   okc_subclass_roles
    where  scs_code = p_scs_code
    and    nvl(start_date,sysdate) <= sysdate
    and    nvl(end_date,sysdate+1) > sysdate;

Line: 671

       select scs_code
       from   OKC_K_HEADERS_B
       where  id = p_chr_id;

Line: 766

          x_select_clause       OUT NOCOPY VARCHAR2,
          x_from_clause         OUT NOCOPY VARCHAR2,
          x_where_clause        OUT NOCOPY VARCHAR2,
          x_order_by_clause     OUT NOCOPY VARCHAR2,
          x_object_code         OUT NOCOPY VARCHAR2) is
CURSOR jtf_contacts_cur(p_contact_code VARCHAR2, p_role_code VARCHAR2, p_intent VARCHAR2) is
       select job.object_code OBJECT_CODE,
              job.object_code||'.ID1, '||
              job.object_code||'.ID2, '||
              job.object_code||'.NAME, '||
		      job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
              from_table FROM_CLAUSE,
              where_clause WHERE_CLAUSE,
              order_by_clause ORDER_BY_CLAUSE
       from   jtf_objects_b job,
              okc_contact_sources cs
       where  job.object_code = cs.jtot_object_code
       and     nvl(job.start_date_active,sysdate) <= sysdate
       and     nvl(job.end_date_active,sysdate + 1) > sysdate
       and    cs.cro_code = p_contact_code
       and    cs.rle_code = p_role_code
       and    cs.start_date <= sysdate
       and    nvl(cs.end_date,sysdate+1) > sysdate
       and    cs.buy_or_sell = p_intent;

Line: 837

             x_select_clause   := jtf_contacts_rec.select_clause;

Line: 842

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
                into   l_where_clause
                from   dual;

Line: 848

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' NAME = '||''''||p_name||''''
                into   l_where_clause
                from   dual;

Line: 854

             select ' SELECT count(*) rec_count'||
                    ' FROM '||x_from_clause||
                    decode(x_where_clause,null,' ',' WHERE ')||x_where_clause||
                    decode(x_order_by_clause,null,null,' ORDER BY ')||x_order_by_clause
             into   l_query_string from dual;