eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_CREATE_ADJST_PVT SQL Statements

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

Line: 89


SELECT a.APPLY_DATE
      ,a.GL_DATE
      ,a.ADJUSTMENT_REASON_CODE
      ,a.COMMENTS
      ,b.ID
      ,b.PSL_ID
      ,b.AMOUNT
      ,b.CODE_COMBINATION_ID
FROM   okl_trx_ar_adjsts_v a, okl_txl_adjsts_lns_v b
WHERE  a.id = b.adj_id
AND    b.receivables_adjustment_id IS NULL;

Line: 105


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: 114


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

Line: 117


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: 263


        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: 266


            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_rec
                                 ,x_ajlv_rec
                                               );

Line: 276


        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: 416


SELECT a.APPLY_DATE
      ,a.GL_DATE
      ,a.ADJUSTMENT_REASON_CODE
      ,a.COMMENTS
      ,b.ID
      ,b.PSL_ID
      ,b.AMOUNT
      ,b.CODE_COMBINATION_ID
FROM   okl_trx_ar_adjsts_v a, okl_txl_adjsts_lns_v b
WHERE  a.id = b.adj_id
AND    b.receivables_adjustment_id IS NULL
AND    b.psl_id = cp_psl_id;

Line: 433


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: 445


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

Line: 454


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: 493


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: 517


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

Line: 528


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: 539


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

Line: 548


    SELECT org_id
    FROM   ar_payment_schedules_all
    WHERE  payment_schedule_id = p_psl_id;

Line: 563


   SELECT ACCOUNT_DERIVATION
   FROM OKL_SYS_ACCT_OPTS;

Line: 635


      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: 729


      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: 884


      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);

Line: 1038


          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: 1041


            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_rec
                                 ,x_ajlv_rec
                                               );

Line: 1051


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