eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STRY_CALL_CO_PUB SQL Statements

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

Line: 21


         select sysdate + 10/24/60 into l_wait_period  from dual;

Line: 37


      SELECT email_address
        FROM HZ_PARTIES
       WHERE party_ID =p_party_ID;

Line: 42


      SELECT email_address
        FROM HZ_CONTACT_POINTS
       WHERE owner_table_ID = p_party_ID
         AND Contact_point_type = 'EMAIL'
         AND primary_flag = 'Y';

Line: 79


Select user_name
from jtf_rs_resource_extns
where resource_id =p_resource_id;

Line: 136


select object_id from iex_case_objects
where cas_id =p_case_id ;

Line: 164


    CURSOR l_vendor_csr(cp_case_number IN VARCHAR2) IS SELECT pv.vendor_id
           ,pv.vendor_name
           --,pvs.email_address
     FROM  iex_cases_all_b ica
          ,iex_case_objects ico
          ,okc_k_party_roles_v opr
          ,po_vendors pv
          --,po_vendor_sites_all pvs
     WHERE ica.case_number = cp_case_number
     AND   ica.cas_id = ico.cas_id
     AND   ico.object_id =opr.dnz_chr_id
     AND   opr.rle_code = 'OKL_VENDOR'
     AND   opr.object1_id1 = pv.vendor_id;

Line: 180


    CURSOR l_khr_csr(cp_case_number IN VARCHAR2) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_cases_all_b ica
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ica.case_number = cp_case_number
    AND ica.cas_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 191


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 211


    SELECT pvs.email_address
    FROM po_vendor_sites_all pvs
    WHERE pvs.vendor_site_code = cp_vendor_site_code;

Line: 300


select c.case_number  from iex_cases_all_b c,iex_Delinquencies_all d
where c.cas_id=d.case_id
and   d.delinquency_id =p_delinquency_id;

Line: 459


 *  flow is over and also updates the work item
 * the send signal is send when the agent REJECTS the
 * notification since the vendor didn't approve it ,
 * so set the status to 'CANCELLED'.
 **/

procedure wf_send_signal(
  itemtype    in   varchar2,
  itemkey     in   varchar2,
  actid       in   number,
  funcmode    in   varchar2,
  result      out nocopy  varchar2)
IS

l_work_item_id      number;

Line: 528


    iex_stry_utl_pub.update_work_item(
                           p_api_version   => 1.0,
                           p_commit        => FND_API.G_FALSE,
                           p_init_msg_list => FND_API.G_FALSE,
                           p_work_item_id  => l_work_item_id,
                           p_status        => l_wk_status,
                           x_return_status => l_return_status,
                           x_msg_count     => l_msg_count,
                           x_msg_data      => l_msg_data
                           );

Line: 548


   end if; -- if update is succcessful;

Line: 587


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 597


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 620


   select resource_id from iex_strategy_work_items
   where work_item_id =p_workitemid;

Line: 703


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 713


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 806


    IS SELECT  contract_number
    FROM    okc_k_headers_b
    WHERE    id = p_contract_id;

Line: 812


    SELECT ico.object_id, okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 821


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 840


    select case_id from
    iex_Delinquencies_all d
    where delinquency_id =p_delinquency_id;

Line: 943


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 953


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 1040


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 1050


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 1133


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 1143


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 1228


    CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
    , okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 1238


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 1328


    IS SELECT  contract_number
    FROM    okc_k_headers_b
    WHERE    id = p_contract_id;

Line: 1334


    SELECT ico.object_id, okh.contract_number
    FROM iex_delinquencies_all ida
        ,iex_case_objects ico
        ,okc_k_headers_b okh
    WHERE ida.delinquency_id = cp_delinquency_id
    AND ida.case_id = ico.cas_id
    AND ico.object_id = okh.id;

Line: 1343


    SELECT   prog.id program_id
            ,prog.contract_number program_number
            ,lease.id contract_id
            ,rgp.dnz_chr_id
            ,lease.contract_number contract_number
            ,rgp.rgd_code
    FROM    okc_k_headers_b prog,
            okc_k_headers_b lease,
            okl_k_headers   khr,
            okc_rule_groups_b rgp
    WHERE   khr.id = lease.id
    AND     khr.khr_id = prog.id
    AND     prog.scs_code = 'PROGRAM'
    AND     lease.scs_code in ('LEASE','LOAN')
    AND     rgp.rgd_code = 'COAGRM'
    AND     rgp.dnz_chr_id = prog.id
    AND     lease.contract_number = cp_contract_number;

Line: 1362


    select case_id from
    iex_Delinquencies_all d
    where delinquency_id =p_delinquency_id;