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.OKS_OC_INT_KTO_PVT SQL Statements

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

Line: 28


SELECT
      object_version_number
     ,authoring_org_id
     ,inv_organization_id
     ,contract_number
     ,contract_number_modifier
     ,currency_code
     ,estimated_amount
     ,date_renewed
     ,scs_code
     ,total_line_list_price
     ,price_list_id
FROM okc_k_headers_b
WHERE id = p_chr_id;

Line: 46


CURSOR c_cle(p_cle_id NUMBER) IS SELECT
  object_version_number
FROM okc_k_lines_b
WHERE id = p_cle_id;

Line: 54


SELECT
	   kh.ID                     ,
	   kh.SCS_CODE               ,
	   kh.CONTRACT_NUMBER        ,
	   kh.CURRENCY_CODE          ,
	   kh.CONTRACT_NUMBER_MODIFIER,
	   kh.TEMPLATE_YN            ,
	   kh.TEMPLATE_USED          ,
	   kh.CHR_TYPE               ,
	   kh.DATE_TERMINATED        ,
	   kh.DATE_RENEWED           ,
	   kh.START_DATE             ,
	   kh.END_DATE               ,
	   kh.AUTHORING_ORG_ID       ,
	   kh.INV_ORGANIZATION_ID    ,
	   kh.BUY_OR_SELL            ,
	   kh.ISSUE_OR_RECEIVE       ,
	   kh.ESTIMATED_AMOUNT       ,
	   ks.cls_code               ,
	   ks.meaning                ,
	   kst.ste_code
FROM       okc_statuses_b   kst,
           okc_k_headers_b  kh,
           okc_subclasses_v ks
WHERE      kh.id     = p_chr_id
AND        ks.code   = kh.scs_code
AND        kst.code  = kh.sts_code;

Line: 91


SELECT
      cpr.id
     ,cpr.jtot_object1_code
     ,cpr.object1_id1
     ,cpr.object1_id2
     ,cpr.rle_code
FROM okc_k_party_roles_b cpr
    ,okc_role_sources  rsc
WHERE
     rsc.buy_or_sell  = 'S'              -- sell contract
AND  rsc.rle_code     = cpr.rle_code     -- role
AND  rsc.start_date   <= sysdate
AND  NVL(rsc.end_date, sysdate) >= sysdate
AND  cpr.cle_id       IS NULL            -- parties
AND  cpr.dnz_chr_id   = b_chr_id;

Line: 258


select 'x' from jtf_objects_b
where object_code = b_object_code
  and from_table like  b_from_table||'%';

Line: 309


SELECT  ID
       ,CUST_ACCT_ID
       ,BILL_TO_SITE_USE_ID
       ,INV_RULE_ID
       ,SHIP_TO_SITE_USE_ID
       ,CONVERSION_TYPE
       ,CONVERSION_RATE
       ,CONVERSION_RATE_DATE
       ,CONVERSION_EURO_RATE
FROM   OKC_K_HEADERS_B
WHERE id = p_chr_id;

Line: 324


SELECT
        CLE_ID
       ,CUST_ACCT_ID
       ,BILL_TO_SITE_USE_ID
       ,INV_RULE_ID
       ,SHIP_TO_SITE_USE_ID
       ,PRICE_LIST_ID
FROM   OKC_K_LINES_B
WHERE dnz_chr_id = p_chr_id
AND   id = p_cle_id;

Line: 339


SELECT
         party_site_id
        ,cust_account_id
        ,party_id
        ,address1
        ,address2
        ,address3
        ,address4
        ,city
        ,state
        ,province
        ,postal_code
        ,county
        ,country
FROM    okx_cust_site_uses_v
WHERE   id1 = b_id1;

Line: 369


  l_k_attr_tab_h.delete;

Line: 370


  l_k_attr_tab_l.delete;

Line: 608


SELECT
  cle.id          	line_id
  ,cle.cle_id      	cle_id
  ,cle.lse_id		lse_id
  ,cle.line_number 	line_number
  ,sts.ste_code
  ,cim.number_of_items qty
  ,cim.uom_code
  ,'Y'                 customer_order_enabled_flag
  ,cle.name            item_name
  ,cim.priced_item_yn
  ,cle.price_unit
  ,'0' price_negotiated
  ,cle.line_list_price
  ,cle.price_list_id
  ,cle.price_list_line_id
  ,cle.currency_code
  ,cle.start_date
  ,cle.end_date
  ,cim.id cim_id
  ,cim.object1_id1 object1_id1
  ,cim.object1_id2 object1_id2
  ,lse.lse_type         line_style
  ,lse.lty_code         line_type
FROM
	okc_k_lines_v		cle,
	okc_k_items		    cim,
	okc_line_styles_b 	lse,
	okc_statuses_b		sts
WHERE
	cim.cle_id = cle.id
AND	lse.id = cle.lse_id
AND	sts.code = cle.sts_code
AND	cle.dnz_chr_id = b_chr_id
AND	cle.id = b_line_id;

Line: 676


  l_line_info_tab.delete;

Line: 680


  l_kh_attr_tab.delete   ;

Line: 681


  l_kl_attr_tab.delete   ;

Line: 683


  l_kh_sto_data_tab.delete;

Line: 684


  l_kh_bto_data_tab.delete;

Line: 686


  l_kl_sto_data_tab.delete;

Line: 687


  l_kl_bto_data_tab.delete;

Line: 689


  l_line_info_tab.delete;

Line: 764


 select description into l_item_name
 from okx_system_items_v
 where id1=r_cle.object_id1
 and id2 = r_cle.object_id2;

Line: 904


      FND_MSG_PUB.Delete_Msg ( p_msg_index       =>      l_msg_count);

Line: 1349


  select
  hdr.id,
  hdr.contract_number
  from
  okc_k_headers_b hdr,
  okc_k_party_roles_b pr
  where hdr.id = nvl(p_contract_id ,hdr.id)
   and   hdr.id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),hdr.id)
   and   nvl(nvl(p_contract_id,p_contract_hdr_id_hi),hdr.id)
   And    pr.chr_id      =  hdr.id
  And    pr.rle_code    = 'SUBSCRIBER'
  And    pr.object1_id1 = nvl(p_customer_id,pr.object1_id1)
  And    Hdr.authoring_org_id = NVL(p_org_id, Hdr.authoring_org_id)
  AND    hdr.sts_code <> 'QA_HOLD'
  And    exists (Select 'x' from OKC_K_GRPINGS  okg
                       Where  okg.included_chr_id = hdr.id
                       And    okg.cgp_parent_id = nvl(p_grp_id,okg.cgp_parent_id) );

Line: 1369


  select sub.id,
  sub.dnz_chr_id,
  sub.dnz_cle_id,
  sub.start_date,
  sub.end_date,
  sub.om_interface_date
  from   oks_subscr_elements sub ,
         okc_k_lines_b line,
         okc_statuses_b sts
   where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
   and   sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
   and   nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)
  and sub.order_header_id  is null
  and sub.om_interface_date <= nvl(p_default_date,sysdate)
  and sub.dnz_cle_id = line.id
  and line.lse_id = 46
  and line.sts_code = sts.code
  and sts.ste_code IN('ACTIVE','SIGNED','EXPIRED','TERMINATED')
   -- Bug 4915691 --
  and   line.id between nvl(p_contract_line_id_lo,line.id)
  and   nvl(p_contract_line_id_hi,line.id);

Line: 1393


  select sub.id,
  sub.dnz_chr_id,
  sub.dnz_cle_id,
  sub.start_date,
  sub.end_date,
  sub.om_interface_date,
  hdr.contract_number
  from   oks_subscr_elements sub,
         okc_k_headers_b hdr,
         okc_k_party_roles_b pr,
         okc_statuses_b st
   where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
--==   and   sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
--==   and   nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)
  and hdr.id = sub.dnz_chr_id
  and pr.chr_id = hdr.id
  and pr.rle_code = 'SUBSCRIBER'
  and st.code = hdr.sts_code
  And    pr.object1_id1 = nvl(p_customer_id,pr.object1_id1)
  And    Hdr.authoring_org_id = NVL(p_org_id, Hdr.authoring_org_id)
  And    exists (Select 'x' from OKC_K_GRPINGS  okg
                       Where  okg.included_chr_id = hdr.id
                       And    okg.cgp_parent_id = nvl(p_grp_id,okg.cgp_parent_id) )
  and sub.order_header_id  is null
  and sub.om_interface_date <= nvl(p_default_date,sysdate)
  and st.ste_code in ('ACTIVE','SIGNED')
   -- Bug 4915674 --
  and   sub.dnz_cle_id between nvl(p_contract_line_id_lo,sub.dnz_cle_id)
  and   nvl(p_contract_line_id_hi,sub.dnz_cle_id);

Line: 1430


        l_quote_line_tab.DELETE;

Line: 1431


        l_qte_line_dtl_tab.DELETE;

Line: 1433


        l_quote_hd_shipment_tab.DELETE;

Line: 1434


        l_quote_ln_shipment_tab.DELETE;

Line: 1436


        l_k2q_line_rel_tab.DELETE;

Line: 1437


        l_line_rltship_tab.DELETE;

Line: 1438


        x_line_rltship_tab.DELETE;

Line: 1440


        l_order_hd_sales_credit_tab.DELETE;

Line: 1441


        l_order_ln_sales_credit_tab.DELETE;

Line: 1443


        l_header_sales_credit_tbl.DELETE;

Line: 1444


        l_line_sales_credit_tbl.DELETE;

Line: 1446


        l_quote_hd_price_adj_tab.DELETE;

Line: 1447


        l_quote_ln_price_adj_tab.DELETE;

Line: 1449


        l_quote_hd_price_adj_attr_tab.DELETE;

Line: 1450


        l_quote_ln_price_adj_attr_tab.DELETE;

Line: 1452


        l_qte_hd_price_adj_rltship_tab.DELETE;

Line: 1453


        l_qte_ln_price_adj_rltship_tab.DELETE;

Line: 1455


        l_quote_hd_price_attr_tab.DELETE;

Line: 1456


        l_quote_ln_price_attr_tab.DELETE;

Line: 1705


        update oks_subscr_elements
        set  order_header_id = lx_order_line_tbl(i).order_header_id
        ,order_line_id = lx_order_line_tbl(i).order_line_id
        where id= get_elements_rec.id;

Line: 1763


     SELECT creation_date,
		  order_number,
		  version_number,
		  NVL(expiration_date, OKC_API.G_MISS_DATE)
	INTO l_ord_creation_date,
		l_ord_num,
		l_ord_version_number,
		l_ord_expiration_date
	FROM oe_order_headers_all
	WHERE header_id = lx_order_header_rec.order_header_id;

Line: 1795


     FND_MSG_PUB.Delete_Msg ( p_msg_index       =>      x_msg_count);

Line: 1834


       FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);

Line: 1898


       FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);

Line: 1968


     FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);

Line: 2053


       FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);

Line: 2112


       FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);

Line: 2172


       FND_MSG_PUB.Delete_Msg ( p_msg_index     =>      x_msg_count);