DBA Data[Home] [Help]

APPS.OKL_STREAMS_UTIL SQL Statements

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

Line: 12

   SELECT MESSAGE_TEXT
   FROM FND_NEW_MESSAGES
   WHERE LANGUAGE_CODE = 'US'
   AND MESSAGE_NAME LIKE p_name;
Line: 70

   SELECT MESSAGE_TEXT
   FROM FND_NEW_MESSAGES
   WHERE LANGUAGE_CODE = 'US'
   AND MESSAGE_NAME LIKE p_name;
Line: 236

      SELECT PRECISION
      FROM fnd_currencies_vl
      WHERE currency_code = p_currency_code
      AND enabled_flag = 'Y'
      AND NVL(start_date_active, SYSDATE) <= SYSDATE
      AND NVL(end_date_active, SYSDATE) >= SYSDATE;
Line: 248

    SELECT b.stm_apply_rounding_difference
    FROM fnd_lookups a,
         OKL_SYS_ACCT_OPTS b
    WHERE a.lookup_type = p_lookup_type
    AND a.lookup_code = b.stm_apply_rounding_difference;
Line: 257

    SELECT authoring_org_id,
           currency_code
    FROM okc_k_headers_b
    WHERE id = p_chr_id;
Line: 279

      SELECT stm_rounding_rule
      FROM OKL_SYS_ACCT_OPTS;
Line: 689

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 694

SELECT PRIMARY_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND    (STL.START_DATE <= l_contract_start_date)
AND    (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose;
Line: 794

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 799

SELECT PRIMARY_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND    (STL.START_DATE <= l_contract_start_date)
AND    (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose;
Line: 893

SELECT pdt.reporting_pdt_id, khr.start_date
FROM     okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND   khr.pdt_id = pdt.id;
Line: 899

SELECT PRIMARY_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND    (STL.START_DATE <= l_contract_start_date)
AND    (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose;
Line: 999

SELECT pdt.reporting_pdt_id, khr.start_date
FROM     okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND   khr.pdt_id = pdt.id;
Line: 1005

SELECT PRIMARY_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND    (STL.START_DATE <= l_contract_start_date)
AND    (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose;
Line: 1100

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 1105

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1204

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 1209

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_ID =   p_primary_sty_id
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1312

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 1317

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1408

SELECT pdt.reporting_pdt_id, khr.start_date
FROM     okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND   khr.pdt_id = pdt.id;
Line: 1414

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1513

SELECT pdt.reporting_pdt_id, khr.start_date
FROM     okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND   khr.pdt_id = pdt.id;
Line: 1519

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_ID =   p_primary_sty_id
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1622

SELECT pdt.reporting_pdt_id, khr.start_date
FROM     okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND   khr.pdt_id = pdt.id;
Line: 1628

SELECT DEPENDENT_STY_ID
FROM   OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   PRIMARY_STY_PURPOSE =   p_primary_sty_purpose
AND	   DEPENDENT_STY_PURPOSE =   p_dependent_sty_purpose;
Line: 1720

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id;
Line: 1725

SELECT '1'
FROM   OKL_STRM_TMPT_FULL_UV STL
WHERE STL.PDT_ID = l_product_id
AND    (STL.START_DATE <= l_contract_start_date)
AND   (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND	   STY_ID =   p_sty_id;
Line: 1786

    SELECT sis_code, log_file FROM okl_stream_interfaces
	WHERE transaction_number = trx_number;
Line: 1845

SELECT
   gts.pricing_engine
FROM
  okl_k_headers khr,
  okl_products_v pdt,
  okl_ae_tmpt_sets_v aes,
  OKL_ST_GEN_TMPT_SETS gts
WHERE
  khr.pdt_id = pdt.id AND
  pdt.aes_id = aes.id AND
  aes.gts_id = gts.id AND
  khr.id  = p_khr_id;
Line: 1897

SELECT
   gts.name
FROM
  okl_k_headers khr,
  okl_products_v pdt,
  okl_ae_tmpt_sets_v aes,
  OKL_ST_GEN_TMPT_SETS gts
WHERE
  khr.pdt_id = pdt.id AND
  pdt.aes_id = aes.id AND
  aes.gts_id = gts.id AND
  khr.id  = p_khr_id;
Line: 2035

      SELECT PRECISION
      FROM fnd_currencies_vl
      WHERE currency_code = p_currency_code
      AND enabled_flag = 'Y'
      AND NVL(start_date_active, SYSDATE) <= SYSDATE
      AND NVL(end_date_active, SYSDATE) >= SYSDATE;
Line: 2047

    SELECT b.stm_apply_rounding_difference
    FROM fnd_lookups a,
         OKL_SYS_ACCT_OPTS b
    WHERE a.lookup_type = p_lookup_type
    AND a.lookup_code = b.stm_apply_rounding_difference;
Line: 2056

    SELECT authoring_org_id,
           currency_code
    FROM okc_k_headers_b
    WHERE id = p_chr_id;
Line: 2063

    SELECT stm_rounding_rule
    FROM OKL_SYS_ACCT_OPTS;
Line: 2497

    SELECT authoring_org_id,
           currency_code
    FROM okc_k_headers_b
    WHERE id = p_chr_id;
Line: 2504

      SELECT PRECISION
      FROM fnd_currencies_vl
      WHERE currency_code = p_currency_code
        AND enabled_flag = 'Y'
        AND NVL(start_date_active, SYSDATE) <= SYSDATE
        AND NVL(end_date_active, SYSDATE) >= SYSDATE;
Line: 2513

      SELECT stm_rounding_rule
      FROM OKL_SYS_ACCT_OPTS;
Line: 2518

    SELECT b.stm_apply_rounding_difference
    FROM fnd_lookups a,
         OKL_SYS_ACCT_OPTS b
    WHERE a.lookup_type = p_lookup_type
    AND a.lookup_code = b.stm_apply_rounding_difference;
Line: 2764

   SELECT    SILB.KLE_ID
   FROM OKL_SIF_RET_LEVELS SRLB,
        OKL_SIF_RETS SIRB,
        OKL_STREAM_INTERFACES SIFB,
        OKL_SIF_LINES SILB
   WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
   AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
   AND SILB.SIF_ID = SIFB.ID
   AND SRLB.SIR_ID = SIRB.ID
   AND SRLB.INDEX_NUMBER = SILB.INDEX_NUMBER
   AND SRLB.INDEX_NUMBER = p_index_number;