APPS.OKL_COMBI_CASH_APP_RLS_PVT SQL Statements

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

Line: 77

  SELECT distinct(consolidated_invoice_number), due_date
  FROM   okl_rcpt_consinv_balances_uv
  WHERE  customer_number = cp_cust_num
  AND org_id= cp_org_id
  ORDER BY due_date;

Line: 87

  SELECT distinct(contract_number)
  FROM   okl_rcpt_cust_cont_balances_uv
  WHERE  customer_number = cp_cust_num
    AND org_id= cp_org_id
  ORDER BY invoice_due_date;

Line: 98

   SELECT distinct(invoice_number), invoice_due_date due_date
  FROM   okl_rcpt_arinv_balances_uv
  WHERE  customer_number = cp_cust_num
    AND org_id= cp_org_id
  ORDER BY invoice_due_date;

Line: 367

 SELECT AR_INVOICE_ID,
            AR_INVOICE_NUMBER,
            AR_INVOICE_LINE_ID INVOICE_LINE_ID,
            LINE_NUMBER,
            AMOUNT_DUE_REMAINING,
            CURRENCY_CODE
 FROM okl_rcpt_consinv_balances_uv lpt
   WHERE    lpt.consolidated_invoice_number    = cp_cons_bill_num
   AND    lpt.customer_number = NVL (cp_customer_num, lpt.customer_number)
   AND lpt.stream_type_id = NVL (cp_stream_type_id, lpt.stream_type_id)
   AND    lpt.amount_due_remaining > 0
   AND lpt.org_id=cp_org_id
   AND lpt.status='OP';

Line: 391

Select AR_INVOICE_ID  Ar_Invoice_Id,
            Invoice_Number  AR_INVOICE_NUMBER,
            INVOICE_LINE_ID invoice_line_id,
            Line_Identifier Line_Number,
            amount_due_remaining amount_due_remaining,
            invoice_currency_code CURRENCY_CODE
    From   OKL_RCPT_ARINV_BALANCES_UV
    Where  Invoice_Number = cp_ar_bill_num
    And Org_id = cp_org_id
    AND	amount_due_remaining > 0
    AND	status = 'OP'
    And sty_Id = Nvl(cp_stream_type_id,sty_id);

Line: 411

 SELECT  AR_INVOICE_ID,
            AR_INVOICE_NUMBER,
            INVOICE_LINE_ID,
            LINE_NUMBER,
            AMOUNT_DUE_REMAINING,
            CURRENCY_CODE
    FROM    OKL_RCPT_CUST_CONT_BALANCES_UV
    WHERE   CONTRACT_NUMBER = NVL (cp_contract_num, CONTRACT_NUMBER)
    AND     STY_ID = NVL(cp_stream_type_id, STY_ID)
    AND     CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
	AND     ORG_ID = cp_org_id
    AND     STATUS = 'OP'
    AND 	AMOUNT_DUE_REMAINING > 0;

Line: 430

  SELECT id, sequence_number, cash_search_type
  FROM   okl_csh_allct_srchs
  ORDER BY sequence_number;

Line: 438

  SELECT sty_id, add_yn
  FROM   okl_srch_strm_typs
  WHERE  cah_id = cp_cah_id;