APPS.OKL_CREATE_ADJST_PVT SQL Statements

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

Line: 71

SELECT a.APPLY_DATE
      ,a.GL_DATE
      ,a.ADJUSTMENT_REASON_CODE
      ,a.COMMENTS
      ,b.ID
      ,b.PSL_ID
      ,b.AMOUNT
      ,b.CODE_COMBINATION_ID
      ,ln.customer_trx_id
      ,ln.customer_trx_line_id
FROM   okl_trx_ar_adjsts_v a,
       okl_txl_adjsts_lns_v b,
       ra_customer_trx_lines_all ln,
       ar_payment_schedules_all ps,
       okc_k_headers_b khr,
       okc_k_lines_v kle,
       okl_strm_type_v sty
WHERE  a.id = b.adj_id
AND    b.receivables_adjustment_id IS NULL
AND    b.psl_id = ps.payment_schedule_id
AND    ln.customer_trx_id = ps.customer_trx_id
AND    khr.contract_number = ln.interface_line_attribute6
AND    khr.id = kle.chr_id
AND    kle.name = ln.interface_line_attribute7
AND    sty.name = ln.interface_line_attribute9
AND    sty.id = b.sty_id
AND    khr.id = b.khr_id
AND    kle.id = b.kle_id
AND    ps.payment_schedule_id = NVL(p_psl_id, ps.payment_schedule_id)
ORDER BY ln.customer_trx_id, b.PSL_ID;

Line: 103

SELECT 'Y'
FROM   AR_PAYMENT_SCHEDULES_ALL APS,
       OKL_CNSLD_AR_STRMS_B CAS
WHERE  APS.CUSTOMER_TRX_ID = CAS.RECEIVABLES_INVOICE_ID
  AND  APS.PAYMENT_SCHEDULE_ID = cp_psl_id;

Line: 130

    l_adj_lines_tbl.delete;

Line: 131

    l_adj_hdr_tbl.delete;

Line: 195

          l_adj_lines_tbl.delete;

Line: 227

    l_adj_lines_tbl.delete;

Line: 342

SELECT RECEIVABLES_TRX_ID, NAME
FROM   ar_receivables_trx_all
WHERE  set_of_books_id = cp_set_of_books_id
AND    name = 'OKL Adjustment';

Line: 351

/*SELECT DISTINCT(contract_number)
FROM   okl_bpd_leasing_payment_trx_v
WHERE  payment_schedule_id = cp_psl_id; */ -- Bug 6358836

Line: 354

select distinct ractrl.interface_line_attribute6
from   ra_customer_trx_lines_all ractrl,
       ar_payment_schedules_all aps
where  aps.customer_trx_id = ractrl.customer_trx_id
and    ractrl.line_type = 'LINE'
and    aps.payment_schedule_id = cp_psl_id;

Line: 461

            l_llca_adj_trx_lines_tbl.delete;

Line: 590

                OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLROCAB.pls call OKL_TXL_ADJSTS_LNS_PUB.UPDATE_TXL_ADJSTS_LNS ');

Line: 593

            OKL_TXL_ADJSTS_LNS_PUB.UPDATE_TXL_ADJSTS_LNS(l_api_version
                                ,l_init_msg_list
                                ,l_return_status
                                ,l_msg_count
                                ,l_msg_data
                                ,l_ajlv_tbl
                                ,x_ajlv_tbl);

Line: 602

                OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLROCAB.pls call OKL_TXL_ADJSTS_LNS_PUB.UPDATE_TXL_ADJSTS_LNS ');

Line: 735

SELECT RECEIVABLES_TRX_ID, NAME
FROM   ar_receivables_trx_all
WHERE  set_of_books_id = cp_set_of_books_id
AND    name = 'OKL Adjustment';

Line: 747

SELECT DISTINCT(contract_number)
FROM   okl_bpd_leasing_payment_trx_v
WHERE  payment_schedule_id = cp_psl_id;

Line: 756

SELECT OBLP.amount_due_remaining        AMOUNT_DUE_REMAINING,
        OBLP.stream_type_id             STREAM_TYPE_ID,
        OBLP.contract_line_id             CONTRACT_LINE_ID,
        OBLP.stream_name                STREAM_NAME,
        OBLP.contract_id                CONTRACT_ID,
        OBLP.contract_number            CONTRACT_NUMBER,
        OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
        OBLP.currency_code              CURRENCY_CODE,
        OTIL.id                         TIL_ID,
        -999                            TLD_ID
FROM   OKL_BPD_LEASING_PAYMENT_TRX_V  OBLP,
        OKL_TXL_AR_INV_LNS_B          OTIL
WHERE  OBLP.payment_schedule_id     = cp_psl_id
AND    OBLP.receivables_invoice_id  = OTIL.receivables_invoice_id
AND    oblp.stream_type_id          = otil.sty_id   --added by dkagrawa for performance
AND    OBLP.amount_due_remaining > 0
UNION
SELECT OBLP.amount_due_remaining        AMOUNT_DUE_REMAINING,
        OBLP.stream_type_id             STREAM_TYPE_ID,
OBLP.contract_line_id             CONTRACT_LINE_ID,
        OBLP.stream_name                STREAM_NAME,
        OBLP.contract_id                CONTRACT_ID,
        OBLP.contract_number            CONTRACT_NUMBER,
        OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
        OBLP.currency_code              CURRENCY_CODE,
        OTAI.til_id_details             TIL_ID,
        OTAI.id                         TLD_ID
FROM   OKL_BPD_LEASING_PAYMENT_TRX_V  OBLP,
        OKL_TXD_AR_LN_DTLS_B          OTAI
WHERE  OBLP.payment_schedule_id     = cp_psl_id
AND    OBLP.receivables_invoice_id  = OTAI.receivables_invoice_id
AND    oblp.stream_type_id          = otai.sty_id  --added by dkagrawa for performance
AND    OBLP.amount_due_remaining > 0;

Line: 795

SELECT    RACTRL.AMOUNT_DUE_REMAINING       AMOUNT_DUE_REMAINING,
          RACTRL.STY_ID                     STREAM_TYPE_ID,
          RACTRL.KLE_ID                     CONTRACT_LINE_ID,
          RACTRL.KHR_ID                     CONTRACT_ID,
          RACTRL.CONTRACT_NUMBER            CONTRACT_NUMBER,
          RACTRL.CUSTOMER_TRX_ID            AR_INVOICE_NUMBER,
          RACTRL.STREAM_TYPE                STREAM_NAME,
          OKL_AM_UTIL_PVT.get_chr_currency(RACTRL.KHR_ID) CURRENCY_CODE,
          RACTRL.til_id_details             TIL_ID,
          RACTRL.TLD_ID                     TLD_ID
   FROM   OKL_BPD_TLD_AR_LINES_V     RACTRL,
          AR_PAYMENT_SCHEDULES_ALL   APS
   WHERE  APS.PAYMENT_SCHEDULE_ID = cp_psl_id
   AND    RACTRL.CUSTOMER_TRX_ID  = APS.CUSTOMER_TRX_ID
   AND    RACTRL.amount_due_remaining > 0;

Line: 814

SELECT    SUM(RACTRL.AMOUNT_DUE_REMAINING)       AMOUNT_DUE_REMAINING
   FROM   OKL_BPD_TLD_AR_LINES_V     RACTRL,
          AR_PAYMENT_SCHEDULES_ALL   APS
   WHERE  APS.PAYMENT_SCHEDULE_ID = cp_psl_id
   AND    RACTRL.CUSTOMER_TRX_ID  = APS.CUSTOMER_TRX_ID
   AND    RACTRL.amount_due_remaining > 0;

Line: 830

SELECT   KHR.pdt_id
FROM     OKL_K_HEADERS_V KHR
WHERE    KHR.id = cp_khr_id;

Line: 841

SELECT DST.code_combination_id
FROM   OKL_TRNS_ACC_DSTRS DST
WHERE  DST.source_id = cp_source_id
AND    DST.source_table = cp_source_table
AND    DST.cr_dr_flag = 'D'
AND    DST.percentage = 100;

Line: 852

 SELECT id
 FROM okl_trx_types_tl t
 WHERE   UPPER (t.name)= UPPER (cp_try_name);

Line: 861

    SELECT org_id
    FROM   ar_payment_schedules_all
    WHERE  payment_schedule_id = p_psl_id;

Line: 876

   SELECT ACCOUNT_DERIVATION
   FROM OKL_SYS_ACCT_OPTS;

Line: 948

      okl_trx_ar_adjsts_pub.insert_trx_ar_adjsts(
             p_api_version              => l_api_version
            ,p_init_msg_list            => l_init_msg_list
            ,x_return_status            => l_return_status
            ,x_msg_count                => l_msg_count
            ,x_msg_data                 => l_msg_data
            ,p_adjv_rec                 => l_adjv_rec
            ,x_adjv_rec                 => x_adjv_rec);

Line: 1048

      okl_txl_adjsts_lns_pub.insert_txl_adjsts_lns(
             p_api_version              => l_api_version
            ,p_init_msg_list            => l_init_msg_list
            ,x_return_status            => l_return_status
            ,x_msg_count                => l_msg_count
            ,x_msg_data                 => l_msg_data
            ,p_ajlv_rec                 => l_ajlv_rec
            ,x_ajlv_rec                 => x_ajlv_rec);

Line: 1203

      OKL_TXL_ADJSTS_LNS_PUB.update_txl_adjsts_lns(
                p_api_version      => l_api_version,
                p_init_msg_list    => l_init_msg_list,
                x_return_status    => l_return_status,
                x_msg_count        => l_msg_count,
                x_msg_data         => l_msg_data,
                p_ajlv_rec           => l_ajlv_rec,
                x_ajlv_rec           => x_ajlv_rec);