APPS.OKL_FA_AMOUNTS_PVT SQL Statements

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

Line: 39

Select khr.CURRENCY_CODE CONTRACT_CURRENCY_CODE,
       khr.CURRENCY_CONVERSION_TYPE,
       khr.CURRENCY_CONVERSION_RATE,
       khr.CURRENCY_CONVERSION_DATE,
       khr.AUTHORING_ORG_ID,
       aopt.SET_OF_BOOKS_ID,
       sob.CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
FROM   GL_LEDGERS_PUBLIC_V      sob,
       OKL_SYS_ACCT_OPTS    aopt,
       OKL_K_HEADERS_FULL_V khr,
       OKC_K_LINES_B        cle,
       OKC_LINE_STYLES_B    lse,
       OKC_K_ITEMS          cim
WHERE  sob.ledger_id   = aopt.set_of_books_id
and    aopt.org_id           = khr.authoring_org_id
and    khr.id                = cle.dnz_chr_id
and    cle.id                = cim.cle_id
and    cle.dnz_chr_id        = cim.dnz_chr_id
and    cle.lse_id            = lse.id
and    lse.lty_code          = 'FIXED_ASSET'
and    cim.object1_id1       = to_char(assetid)
and    cim.object1_id2       = '#'
and    cim.jtot_object1_code = 'OKX_ASSET';

Line: 68

Select cost,
       adjusted_cost,
       original_cost,
       salvage_value,
       recoverable_cost,
       adjusted_recoverable_cost
from   FA_BOOKS
where  asset_id       = assetid
and    book_type_code = bookcode
and    transaction_header_id_out is null
and    date_ineffective is null;

Line: 266

SELECT to_number(cim.object1_id1)
FROM   okc_k_items  cim,
       fa_additions fa,
       okc_k_lines_b  cle
where  fa.asset_id           = to_number(cim.object1_id1)
and    cim.object1_id2       = '#'
and    cim.jtot_object1_code = 'OKX_ASSET'
and    cim.cle_id            = cle.id
and    cim.dnz_chr_id        = cle.dnz_chr_id
and    cle.cle_id            = finastid;

Line: 280

SELECT fab.book_type_code
FROM   FA_BOOKS FAB,
       FA_BOOK_CONTROLS FBC
WHERE  fab.book_type_code = fbc.book_type_code
AND    fbc.book_class     = 'CORPORATE'
AND    fab.asset_id       = asstid
AND    fab.transaction_header_id_out is null
AND    fab.date_ineffective is null;

Line: 418

Select khr.CURRENCY_CODE CONTRACT_CURRENCY_CODE,
       khr.CURRENCY_CONVERSION_TYPE,
       khr.CURRENCY_CONVERSION_RATE,
       khr.CURRENCY_CONVERSION_DATE,
       khr.AUTHORING_ORG_ID,
       khr.DEAL_TYPE,
       aopt.SET_OF_BOOKS_ID,
       sob.CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
FROM   GL_LEDGERS_PUBLIC_V      sob,
       OKL_SYS_ACCT_OPTS    aopt,
       OKL_K_HEADERS_FULL_V khr,
       OKC_K_LINES_B        cle,
       OKC_LINE_STYLES_B    lse
WHERE  sob.ledger_id   = aopt.set_of_books_id
and    aopt.org_id           = khr.authoring_org_id
and    khr.id                = cle.dnz_chr_id
and    khr.id                = cle.chr_id
and    cle.lse_id            = lse.id
and    lse.lty_code          = 'FREE_FORM1'
and    cle.id                = finassetid;

Line: 442

Select kle.OEC,
       kle.RESIDUAL_VALUE
from   OKL_K_LINES KLE
where  kle.id = finassetid;