DBA Data[Home] [Help]

APPS.OKL_ISG_UTILS_PVT SQL Statements

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

Line: 30

    SELECT

           pdt.id  pdt_id,
           chr.start_date,
           khr.deal_type,
           nvl(pdt.reporting_pdt_id, -1) report_pdt_id
    FROM   okc_k_headers_v chr,
           okl_k_headers khr,
           okl_products_v pdt
    WHERE khr.id = chr.id
        AND chr.id = l_khr_id
        AND khr.pdt_id = pdt.id(+);
Line: 44

SELECT
  TLN.PRIMARY_STY_ID,
  STY.NAME PRIMARY_STY_NAME
FROM
  OKL_ST_GEN_TMPT_LNS TLN,
  OKL_ST_GEN_TEMPLATES TMPT,
  OKL_ST_GEN_TMPT_SETS Tst,
  OKL_AE_TMPT_SETS AES,
  OKL_PRODUCTS_V PDT,
  OKL_STRM_TYPE_v STY

WHERE
  TLN.GTT_ID = TMPT.ID AND
  TMPT.GTS_ID = Tst.ID AND
  Tst.ID = AES.GTS_ID AND
  --TST.deal_type = p_deal_type AND
  AES.ID = PDT.AES_ID AND
  TLN.PRIMARY_STY_ID = STY.ID
  AND TLN.PRIMARY_YN = 'Y'
AND PDT.ID = l_pdt_id
AND    (TMPT.START_DATE <= l_contract_start_date)
AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND	   STY.STREAM_TYPE_PURPOSE =   p_primary_sty_purpose;
Line: 148

    SELECT

           pdt.id  pdt_id,
           chr.start_date,
           khr.deal_type,
           nvl(pdt.reporting_pdt_id, -1) report_pdt_id
    FROM   okc_k_headers_v chr,
           okl_k_headers khr,
           okl_products_v pdt
    WHERE khr.id = chr.id
        AND chr.id = l_khr_id
        AND khr.pdt_id = pdt.id(+);
Line: 162

SELECT
  TLN.PRIMARY_STY_ID,
  STY.NAME PRIMARY_STY_NAME
FROM
  OKL_ST_GEN_TMPT_LNS TLN,
  OKL_ST_GEN_TEMPLATES TMPT,
  OKL_ST_GEN_TMPT_SETS Tst,
  OKL_AE_TMPT_SETS AES,
  OKL_PRODUCTS_V PDT,
  OKL_STRM_TYPE_v STY

WHERE
  TLN.GTT_ID = TMPT.ID AND
  TMPT.GTS_ID = Tst.ID AND
  Tst.ID = AES.GTS_ID AND
  TST.deal_type = p_deal_type AND
  AES.ID = PDT.AES_ID AND
  TLN.PRIMARY_STY_ID = STY.ID
  AND TLN.PRIMARY_YN = 'Y'
AND PDT.ID = l_pdt_id
AND    (TMPT.START_DATE <= l_contract_start_date)
AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND	   STY.STREAM_TYPE_PURPOSE =   p_primary_sty_purpose;
Line: 268

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id; */
Line: 276

    SELECT

           pdt.id  pdt_id,
           chr.start_date,
           khr.deal_type,
           nvl(pdt.reporting_pdt_id, -1) report_pdt_id
    FROM   okc_k_headers_v chr,
           okl_k_headers khr,
           okl_products_v pdt
    WHERE khr.id = chr.id
        AND chr.id = l_khr_id
        AND khr.pdt_id = pdt.id(+);
Line: 290

SELECT
  TLN.DEPENDENT_STY_ID,
  STY1.NAME DEPENDENT_STY_NAME
FROM
  OKL_ST_GEN_TMPT_LNS TLN,
  OKL_ST_GEN_TEMPLATES TMPT,
  OKL_ST_GEN_TMPT_SETS Tst,
  OKL_AE_TMPT_SETS AES,
  OKL_PRODUCTS_V PDT,
  OKL_STRM_TYPE_v STY
  ,  OKL_STRM_TYPE_v STY1
WHERE
  TLN.GTT_ID = TMPT.ID AND
  TMPT.GTS_ID = Tst.ID AND
  Tst.ID = AES.GTS_ID AND
  --TST.deal_type = p_deal_type AND
  AES.ID = PDT.AES_ID AND
  TLN.PRIMARY_STY_ID = STY.ID
 AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
  AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND    (TMPT.START_DATE <= l_contract_start_date)
AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND   STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
Line: 405

SELECT pdt_id, start_date
FROM     okl_k_headers_full_v
WHERE id = l_khr_id; */
Line: 413

    SELECT

           pdt.id  pdt_id,
           chr.start_date,
           khr.deal_type,
           nvl(pdt.reporting_pdt_id, -1) report_pdt_id
    FROM   okc_k_headers_v chr,
           okl_k_headers khr,
           okl_products_v pdt
    WHERE khr.id = chr.id
        AND chr.id = l_khr_id
        AND khr.pdt_id = pdt.id(+);
Line: 427

SELECT
  TLN.DEPENDENT_STY_ID,
  STY1.NAME DEPENDENT_STY_NAME
FROM
  OKL_ST_GEN_TMPT_LNS TLN,
  OKL_ST_GEN_TEMPLATES TMPT,
  OKL_ST_GEN_TMPT_SETS Tst,
  OKL_AE_TMPT_SETS AES,
  OKL_PRODUCTS_V PDT,
  OKL_STRM_TYPE_v STY
  ,  OKL_STRM_TYPE_v STY1
WHERE
  TLN.GTT_ID = TMPT.ID AND
  TMPT.GTS_ID = Tst.ID AND
  Tst.ID = AES.GTS_ID AND
  TST.deal_type = p_deal_type AND
  AES.ID = PDT.AES_ID AND
  TLN.PRIMARY_STY_ID = STY.ID
 AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
  AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND    (TMPT.START_DATE <= l_contract_start_date)
AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND   STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
Line: 548

SELECT  deal_type
FROM     okl_k_headers_h
WHERE id = l_khr_id;
Line: 553

SELECT LOOKUP_CODE FROM fnd_lookups
WHERE lookup_type = 'OKL_STREAM_TYPE_PURPOSE' AND
lookup_code = l_lookup_code;
Line: 561

 select kle.id,
    lse.lty_code,
           kle.oec,
          kle.residual_code,
           kle.capital_amount,
           kle.delivered_date,
           kle.date_funding_required,
           kle.residual_grnty_amount,
           kle.date_funding,
           kle.residual_value,
           kle.amount,
           kle.price_negotiated,
           kle.start_date,
           kle.end_date,
           kle.orig_system_id1,
           kle.fee_type,
           kle.initial_direct_cost,
           tl.item_description,
           tl.name
     from  okl_k_lines_full_v kle,
           okc_line_styles_b lse,
           okc_k_lines_tl tl,
           okc_statuses_b sts
     where KLE.LSE_ID = LSE.ID
          and lse.lty_code IN ('FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET', 'FREE_FORM1', 'LINK_FEE_ASSET')
   and tl.id = kle.id
          and tl.language = userenv('LANG')
          and kle.dnz_chr_id = p_chr_id
   and sts.code = kle.sts_code
   and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED','CANCELLED');
Line: 595

        select crl.id slh_id,
           crl.object1_id1, --stream type id
           crl.RULE_INFORMATION1,
           crl.RULE_INFORMATION2,
           crl.RULE_INFORMATION3,
           crl.RULE_INFORMATION5,
           crl.RULE_INFORMATION6,
           crl.RULE_INFORMATION10
    from   OKC_RULE_GROUPS_B crg,
           OKC_RULES_B crl
    where  crl.rgp_id = crg.id
           and crg.RGD_CODE = 'LALEVL'
           and crl.RULE_INFORMATION_CATEGORY = 'LASLH'
           and crg.dnz_chr_id = chrId
           and crg.cle_id = cleId
    order by crl.RULE_INFORMATION1;
Line: 615

    SELECT  STREAM_TYPE_PURPOSE from okl_strm_type_b
       where id = p_sty_id;
Line: 621

      SELECT NVL(TO_NUMBER(rul.rule_information1), 100) pass_through_percentage
      FROM   okc_rule_groups_b rgp,
             okc_rules_b rul
      WHERE  rgp.cle_id = kleid
        AND  rgp.rgd_code = 'LAPSTH'
        AND  rgp.id = rul.rgp_id
        AND  rul.rule_information_category = 'LAPTPR';
Line: 632

      SELECT TO_NUMBER(rul.rule_information1) periods,
             TO_NUMBER(rul.rule_information2) amount --,
      FROM   okc_rules_b rul,
             okc_rules_b rul2,
             okc_rule_groups_b rgp,
             okc_k_lines_b cle,
             okl_k_lines kle
      WHERE  rgp.dnz_chr_id = p_khr_id
        AND  rgp.cle_id = cle.id
 AND  kle.id = p_kle_id
        AND  cle.sts_code IN ('PASSED', 'COMPLETE')
 AND  kle.fee_type <> 'FINANCED'
 AND  kle.fee_type <> 'ABSORBED'
 AND  kle.fee_type <> 'ROLLOVER'
        AND  rgp.rgd_code = 'LAFEXP'
        AND  rgp.id = rul.rgp_id
        AND  rgp.id = rul2.rgp_id
        AND  rul.rule_information_category = 'LAFEXP'
        AND  rul2.rule_information_category = 'LAFREQ';
Line: 655

      SELECT  NVL(initial_direct_cost, 0)
      FROM    okl_k_lines
      WHERE   id = p_kle_id;
Line: 1263

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

SELECT
  TLN.DEPENDENT_STY_ID,
  STY1.NAME DEPENDENT_STY_NAME
FROM
  OKL_ST_GEN_TMPT_LNS TLN,
  OKL_ST_GEN_TEMPLATES TMPT,
  OKL_ST_GEN_TMPT_SETS Tst,
  OKL_AE_TMPT_SETS AES,
  OKL_PRODUCTS_V PDT,
  OKL_STRM_TYPE_v STY
  ,  OKL_STRM_TYPE_v STY1
WHERE
  TLN.GTT_ID = TMPT.ID AND
  TMPT.GTS_ID = Tst.ID AND
  Tst.ID = AES.GTS_ID AND
  TST.deal_type = p_deal_type AND
  AES.ID = PDT.AES_ID AND
  TLN.PRIMARY_STY_ID = STY.ID AND
   TLN.PRIMARY_STY_ID = p_primary_sty_id
 AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
  AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND    (TMPT.START_DATE <= l_contract_start_date)
AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND   STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
Line: 1384

        SELECT
          TLN.DEPENDENT_STY_ID,
          STY1.NAME DEPENDENT_STY_NAME
        FROM
          OKL_ST_GEN_TMPT_LNS TLN,
          OKL_ST_GEN_TEMPLATES TMPT,
          OKL_ST_GEN_TMPT_SETS Tst,
          OKL_AE_TMPT_SETS AES,
          OKL_PRODUCTS_V PDT,
          OKL_STRM_TYPE_v STY
          ,  OKL_STRM_TYPE_v STY1
        WHERE
          TLN.GTT_ID = TMPT.ID AND
          TMPT.GTS_ID = Tst.ID AND
          Tst.ID = AES.GTS_ID AND
          TST.deal_type = p_deal_type AND
          AES.ID = PDT.AES_ID AND
          TLN.PRIMARY_STY_ID = STY.ID
         AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
          AND TLN.PRIMARY_YN = 'N'
        AND PDT.ID = l_pdt_id
        AND    (TMPT.START_DATE <= l_contract_start_date)
        AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
        AND   STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
Line: 1494

        SELECT
          TLN.DEPENDENT_STY_ID,
          STY1.NAME DEPENDENT_STY_NAME
        FROM
          OKL_ST_GEN_TMPT_LNS TLN,
          OKL_ST_GEN_TEMPLATES TMPT,
          OKL_ST_GEN_TMPT_SETS Tst,
          OKL_AE_TMPT_SETS AES,
          OKL_PRODUCTS_V PDT,
          OKL_STRM_TYPE_v STY
          ,  OKL_STRM_TYPE_v STY1
        WHERE
          TLN.GTT_ID = TMPT.ID AND
          TMPT.GTS_ID = Tst.ID AND
          Tst.ID = AES.GTS_ID AND
          TST.deal_type = p_deal_type AND
          AES.ID = PDT.AES_ID AND
          TLN.PRIMARY_STY_ID = STY.ID AND
           TLN.PRIMARY_STY_ID = p_primary_sty_id
         AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
          AND TLN.PRIMARY_YN = 'N'
        AND PDT.ID = l_pdt_id
        AND    (TMPT.START_DATE <= l_contract_start_date)
        AND    (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
        AND   STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
Line: 1628

SELECT
  tst.isg_arrears_pay_dates_option
FROM
  okl_st_gen_tmpt_sets tst,
  okl_ae_tmpt_sets_all aes,
  okl_products_v pdt,
  okl_k_headers  khr
WHERE
    khr.id = p_khr_id
AND pdt.id = khr.pdt_id
AND aes.id = pdt.aes_id
AND tst.id = aes.gts_id
;