APPS.OKI_UTL_PVT SQL Statements

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

Line: 62

  SELECT   *
  FROM     gl_periods glpr
  WHERE    glpr.adjustment_period_flag = 'N'
  AND      p_summary_build_date BETWEEN glpr.start_date AND glpr.end_date
  AND      glpr.period_set_name LIKE NVL(p_period_set_name, '%')
  AND      glpr.period_type LIKE NVL(p_period_type, '%')
  ;

Line: 75

    SELECT  NVL(SUM(cpl.base_price_negotiated), 0) value
          , COUNT(DISTINCT(shd.chr_id)) contract_count
    FROM   oki_sales_k_hdrs shd
         , oki_cov_prd_lines cpl
    WHERE  shd.chr_id = cpl.chr_id
    AND    cpl.sts_code = 'ACTIVE'
    AND    shd.date_signed   <= p_start_date
    AND    shd.date_approved <= p_start_date
    AND    shd.start_date    <= p_start_date
    AND    shd.end_date      >= p_start_date
    AND    (   shd.date_terminated IS NULL
            OR shd.date_terminated  > p_start_date )
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    ;

Line: 97

    SELECT  NVL(SUM(cpl.base_price_negotiated), 0) value
          , COUNT(DISTINCT cpl.chr_id) contract_count
          , shd.authoring_org_id authoring_org_id
    FROM   oki_sales_k_hdrs shd
         , oki_cov_prd_lines cpl
    WHERE  shd.chr_id = cpl.chr_id
    AND    cpl.sts_code = 'ACTIVE'
    AND    shd.date_signed   <= p_start_date
    AND    shd.date_approved <= p_start_date
    AND    shd.start_date    <= p_start_date
    AND    shd.end_date      >= p_start_date
    AND    (   shd.date_terminated IS NULL
            OR shd.date_terminated  > p_start_date )
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    GROUP BY shd.authoring_org_id
    ORDER BY value
    ;

Line: 122

    SELECT NVL(SUM(shd.base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.start_date    <= p_qtr_end_date
    AND    shd.is_new_yn     IS NULL
    AND    shd.date_signed   IS NULL
    AND    shd.date_canceled IS NULL
    AND    shd.contract_amount BETWEEN 0
                                   AND oki_utl_pub.g_contract_limit
  ;

Line: 140

    SELECT NVL(SUM(shd.base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.start_date    <= p_qtr_end_date
    AND    shd.is_new_yn     IS NULL
    AND    shd.date_signed   IS NULL
    AND    shd.date_canceled IS NULL
    AND    shd.contract_amount BETWEEN 0
                                   AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    GROUP BY shd.authoring_org_id
    ORDER BY value
    ;

Line: 160

   SELECT NVL(SUM(base_contract_amount), 0) value
        , COUNT(shd.chr_id) contract_count
   FROM   oki_sales_k_hdrs shd
   WHERE  shd.date_signed   <= p_qtr_start_date
   AND    shd.date_approved <= p_qtr_end_date
   AND    shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
   AND    shd.date_terminated IS NULL
   AND    shd.base_contract_amount BETWEEN 0
                                       AND oki_utl_pub.g_contract_limit
   ;

Line: 178

   SELECT NVL(SUM(base_contract_amount), 0) value
        , COUNT(shd.chr_id) contract_count
   FROM   oki_sales_k_hdrs shd
   WHERE  shd.date_signed   <= p_qtr_start_date
   AND    shd.date_approved <= p_qtr_end_date
   AND    shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
   AND    shd.date_terminated IS NULL
   AND    shd.base_contract_amount BETWEEN 0
                                       AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
   ;

Line: 198

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn       IS NULL
    AND    shd.date_signed     IS NOT NULL
    AND    shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
    AND    GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
    AND    shd.base_contract_amount BETWEEN 0
                                       AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    ;

Line: 216

    SELECT DISTINCT shd.authoring_org_id authoring_org_id
                  , NULL organization_name
    FROM   oki_sales_k_hdrs shd
    ;

Line: 226

    SELECT  bdl.bin_code_meaning bin_code_meaning
          , bdl.bin_code_seq bin_code_seq
    FROM oki_bin_disp_lkup bdl
    WHERE bdl.bin_id   = p_bin_id
    AND   bdl.bin_code = p_bin_code
    ;

Line: 244

    SELECT glpr.*
    FROM
         gl_periods glpr
       , gl_sets_of_books sob
       , hr_organization_information oin
    WHERE
         oki_utl_pub.g_summary_build_date BETWEEN glpr.start_date
                                              AND glpr.end_date
    AND  glpr.period_set_name         = sob.period_set_name
    AND  glpr.period_type             = sob.accounted_period_type
    AND  glpr.adjustment_period_flag  = 'N'
    AND  sob.set_of_books_id          = oin.org_information3
    AND  oin.org_information_context  = 'Operating Unit Information'
    AND  oin.organization_id          = fnd_profile.value('OKI_BASE_ORG_ID')
    ;