DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PVT SQL Statements

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

Line: 15

  SELECT srv.ID1,
         srv.ID2,
         srv.NAME,
         srv.DESCRIPTION
  FROM OKX_SALESREPS_V srv
  WHERE ((nvl(srv.ORG_ID, -99) =  nvl(mo_global.get_current_org_id, -99)) or (nvl(mo_global.get_current_org_id, -99) = -99))
  AND   srv.name = NVL(p_name,srv.name)
  AND   srv.ID1  = NVL(p_id1,srv.ID1)
  AND   srv.ID2  = NVL(p_id2,srv.ID2)
  ORDER BY srv.NAME;
Line: 29

  SELECT pcv.ID1,
         pcv.ID2,
         pcv.NAME,
         pcv.DESCRIPTION
  FROM okx_party_contacts_v pcv
  WHERE pcv.name = NVL(p_name,pcv.name)
  AND   pcv.ID1  = NVL(p_id1,pcv.ID1)
  AND   pcv.ID2  = NVL(p_id2,pcv.ID2)
  ORDER BY pcv.NAME;
Line: 42

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

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

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

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

l_select_clause     varchar2(2000) default null;
Line: 266

l_select_clause     varchar2(2000) default null;
Line: 367

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

       select scs_code
       from   OKC_K_HEADERS_V
       where  id = p_chr_id;
Line: 421

                       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_contact_cur (p_cro_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 rs
       where   job.object_code = rs.jtot_object_code
       and     nvl(job.start_date_active,sysdate) <= sysdate
       and     nvl(job.end_date_active,sysdate + 1) > sysdate
       and     rs.rle_code = p_rle_code
       and     rs.cro_code     = p_cro_code
       and     rs.start_date <= sysdate
       and     nvl(rs.end_date,sysdate+1) > sysdate
       and     rs.buy_or_sell = p_intent;
Line: 457

             x_select_clause   := 'NOT FOUND';
Line: 463

             x_select_clause   := jtf_contact_rec.select_clause;
Line: 468

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

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' NAME like '||''''||p_name||'%'||''''
                into   l_where_clause
                from   dual;
Line: 501

l_select_clause     varchar2(2000) default null;