DBA Data[Home] [Help]

APPS.FND_APD SQL Statements

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

Line: 33

    SELECT sid
    INTO   session
    FROM   v$session
    WHERE  audsid = userenv('SESSIONID');
Line: 47

    SELECT value
    INTO   udump
    FROM   v$parameter
    WHERE  name = 'user_dump_dest';
Line: 61

     select application_short_name , concurrent_program_name,
            round((sysdate-fcr.actual_start_date)*24*60*60,2)
            , fcr.phase_code , fcr.status_code , actual_start_date,
             actual_completion_date,
           lower(instance_name) || '_ora_' || fcr.oracle_process_id
           || '.trc'  , instance_name, parent_request_id,
           version
     into   module_id, flow_id, vduration, phase_code , status_code,
            sdate, cdate, tracefile , vdbname, parentreqid, vversion
     from   fnd_concurrent_requests fcr, fnd_application fa,
            fnd_concurrent_programs fcp, v$instance
     where  fcr.request_id = p_req_id
     and    fcr.program_application_id = fa.application_id
     and    fcr.concurrent_program_id = fcp.concurrent_program_id
     and    fcr.program_application_id = fcp.application_id;
Line: 133

    SELECT sid
    INTO   session
    FROM   v$session
    WHERE  audsid = userenv('SESSIONID');
Line: 147

    SELECT value
    INTO   udump
    FROM   v$parameter
    WHERE  name = 'user_dump_dest';
Line: 161

     select application_short_name , concurrent_program_name,
           lower(instance_name) || '_ora_' || fcr.oracle_process_id
           || '_' || p_req_id || '.trc'  , instance_name, parent_request_id,
           version
     into   module_id, flow_id, tracefile , vdbname, parentreqid, vversion
     from   fnd_concurrent_requests fcr, fnd_application fa,
            fnd_concurrent_programs fcp, v$instance
     where  fcr.request_id = p_req_id
     and    fcr.program_application_id = fa.application_id
     and    fcr.concurrent_program_id = fcp.concurrent_program_id
     and    fcr.program_application_id = fcp.application_id;
Line: 220

    SELECT sid
    INTO   session
    FROM   v$session
    WHERE  audsid = userenv('SESSIONID');
Line: 234

    SELECT value
    INTO   udump
    FROM   v$parameter
    WHERE  name = 'user_dump_dest';
Line: 248

     select application_short_name , concurrent_program_name,
            round((sysdate-fcr.actual_start_date)*24*60*60,2),
           lower(instance_name) || '_ora_' || fcr.oracle_process_id
           || '_' || p_req_id || '.trc'  , instance_name, parent_request_id,
           version
     into  module_id,flow_id,vduration,tracefile,vdbname,parentreqid,vversion
     from   fnd_concurrent_requests fcr, fnd_application fa,
            fnd_concurrent_programs fcp, v$instance
     where  fcr.request_id = p_req_id
     and    fcr.program_application_id = fa.application_id
     and    fcr.concurrent_program_id = fcp.concurrent_program_id;
Line: 326

  select spid into vspid
  from   v$process p,v$session s
  where  p.addr = s.paddr
  and    s.audsid = userenv('SESSIONID');
Line: 332

    raise_application_error(-20100,'Error select SPID ...');
Line: 338

  select instance_name
  into   vinstance
  from   v$instance i;
Line: 343

    raise_application_error(-20100,'Error select Instance ...');
Line: 350

    vsql := 'insert into rt_icx_data@rtperf
             ( icxid , spid , instance , techstack , creation_date, request_id)              select :b1 , :b2, upper(:b3), :b4, sysdate, :b5 from dual
             where not exists ( select ''x'' from rt_icx_data@rtperf
              where icxid = :b6 and   spid = :b7 and   instance = upper(:b8)
              and   techstack = upper(:b9)) ';