APPS.OKS_USAGE_SETTLE_PUB SQL Statements

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

Line: 13

 SELECT line.id, rline.settlement_interval, rline.usage_type,rline.usage_period, line.line_number --Bug 5284103
   FROM oks_k_lines_b   rline,
        okc_k_lines_b   line
   WHERE line.dnz_chr_id = p_chr_id
   AND   rline.cle_id    = line.id
   AND   line.lse_id     = 12
   AND   rline.usage_type = 'VRT'
   AND not exists (select 1 from oks_bill_cont_lines bcl
                   where line.id = bcl.cle_id
                   and   bcl.bill_action = 'SRI');

Line: 26

  SELECT line.id,rline.minimum_quantity,
         line.start_date,line.end_date
   FROM OKC_K_LINES_B  line,
        OKS_K_LINES_B  rline
  WHERE line.cle_id = p_cle_id
  AND   line.lse_id = 13
  AND   rline.cle_id = line.id;

Line: 36

 SELECT max(date_end),max(date_start)
  FROM  oks_level_elements
 WHERE cle_id   = p_cle_id;

Line: 43

 SELECT  id
   FROM oks_bill_sub_lines
   WHERE cle_id = p_cle_id
   AND   trunc(date_billed_From)= trunc(p_date_billed_From)
   AND   trunc(date_billed_to)  = trunc(p_date_billed_to) ;

Line: 50

  SELECT  NVL(sum(NVL(Result,0)),0)  qty,
          sum(line.amount)           amt,
          max(line.date_billed_to)   max_bill_to
   FROM    oks_bill_sub_line_dtls ldtl
          ,oks_bill_sub_lines line
   WHERE   line.cle_id = p_cle_id
   AND     ldtl.bsl_id = line.id;

Line: 61

SELECT bsl.id,
       bsl.date_billed_from,
       bsl.date_billed_to,
       bsl.amount,
       bsd.result
  FROM oks_bill_cont_lines    bcl,
       oks_bill_sub_lines     bsl,
       oks_bill_sub_line_dtls bsd
  WHERE bcl.id  =  bsl.bcl_id
  AND   bcl.bill_action = 'RI'
  AND   bsl.cle_id = p_cle_id
  AND   bsd.bsl_id = bsl.id
 ORDER by bsl.date_billed_to desc;

Line: 77

 SELECT date_billed_from,date_billed_to
 FROM  oks_bill_sub_lines
 WHERE cle_id   = p_cle_id;

Line: 82

  SELECT uom_code
  FROM   Okc_time_code_units_v
  WHERE  tce_code = 'DAY'
  AND    quantity = 1;

Line: 88

  SELECT mtl.primary_uom_code
  FROM   Okc_K_items Item
        ,mtl_system_items_b   mtl  --Okx_system_items_v mtl
        ,okc_k_headers_b      hdr
        ,okc_k_lines_b   line
  WHERE  item.cle_id = line.id     --p_cle_id
  AND    line.id     = p_cle_id
  AND    line.dnz_chr_id = hdr.id
  --AND    mtl.id1 = item.object1_id1
  AND    mtl.inventory_item_id = item.object1_id1
  AND    mtl.organization_id = hdr.inv_organization_id;

Line: 104

        select value_timestamp from cs_counter_values
        where counter_id = p_id
        and   counter_reading = p_lock_read;

Line: 109

	SELECT	Fnd.Meaning
	FROM	FND_LOOKUPS Fnd
	WHERE	Fnd.Lookup_Type = 'OKS_SETTLEMENT_INTERVAL'
	AND	Fnd.Lookup_Code = 'BP';