APPS.OKL_PRINT_CONS_BILL SQL Statements

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

Line: 12

	   SELECT a.*
	   FROM okl_cnsld_ar_hdrs_v a
       WHERE EXISTS (SELECT 1 FROM
                                  (SELECT x.id
                                   FROM okl_cnsld_ar_hdrs_v x,
                                        okl_cnsld_ar_lines_v y,
                                        okl_cnsld_ar_strms_v z
                                   WHERE x.trx_status_code like 'PROCESSED%' AND
                                         x.id              = y.cnr_id        AND
                                         y.id              = z.lln_id        AND
                                         z.receivables_invoice_id            IS NOT NULL) b
                     WHERE b.id = a.id
       -- nikshah bug 6747706 added org check
       AND NVL(a.ORG_ID, MO_GLOBAL.GET_CURRENT_ORG_ID) = MO_GLOBAL.GET_CURRENT_ORG_ID)
       -- nikshah bug 6747706 end
       ORDER BY to_number(a.consolidated_invoice_number);

Line: 30

	   SELECT sequence_number,
			  nvl(amount, 0) + nvl(tax_amount, 0) amount,
			  ilt_id,
			  khr_id,
			  kle_id
	   FROM okl_cnsld_ar_lines_v
	   WHERE cnr_id = p_cnr_id;

Line: 39

	 SELECT name
 	 FROM okl_invc_line_types_v
	 WHERE id = p_ilt_id;

Line: 44

	   SELECT contract_number
	   FROM okc_k_headers_b
	   WHERE id = p_khr_id;

Line: 49

	 SELECT name, description
 	 FROM okx_asset_lines_v
	 WHERE parent_line_id = p_kle_id;

Line: 54

	   SELECT party_name,
	   		  party_id
	   FROM hz_parties
	   where party_id = p_party_id;

Line: 61

	   Select name
	   from fnd_currencies_vl
	   WHERE currency_code = p_code;

Line: 83

	 SELECT
       CA.account_number,
       PY.PARTY_NAME,
  	   PY.ADDRESS1,
  	   PY.ADDRESS2,
  	   PY.ADDRESS3,
  	   PY.ADDRESS4,
  	   PY.CITY,
  	   PY.STATE,
  	   PY.POSTAL_CODE,
  	   PY.COUNTRY
     FROM HZ_CUST_ACCOUNTS CA,
  		  HZ_PARTIES PY
     WHERE CA.CUST_ACCOUNT_ID = p_id AND
  		   PY.PARTY_ID 		  = CA.PARTY_ID;