[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CONCATENATED_SEGMENTS
FROM FA_CATEGORIES_B_KFV
WHERE category_id = p_category_id;
SELECT 'Y' FROM OKL_K_HEADERS khr
WHERE khr.id = p_ctr_id
AND khr.multi_gaap_yn = 'Y';
SELECT code_combination_id,
ae_line_type,
crd_code
FROM OKL_AE_TMPT_LNES
WHERE avl_id IN (SELECT avl.id
FROM okl_ae_templates avl,okl_trx_types_v try,okl_strm_type_v sty
WHERE aes_id IN
(SELECT avl.aes_id FROM okl_products_v WHERE avl.name = p_product)
AND try.name = 'Accrual'
AND sty.name= p_stream_type
AND avl.sty_id = sty.id
AND avl.try_id = try.id
AND avl.memo_yn= p_memo_yn
AND avl.prior_year_yn is NULL
AND avl.factoring_synd_flag IS NULL);
/* SELECT code_combination_id,
ae_line_type,
crd_code
FROM OKL_AE_TMPT_LNES
WHERE avl_id IN (SELECT id
FROM okl_Ae_templates_uv
WHERE aes_id IN
(SELECT aes_id FROM okl_products_v WHERE name = p_product)
AND try_name = 'Accrual'
AND sty_name = p_stream_type
AND memo_yn = p_memo_yn
AND prior_year_yn is NULL
AND FACTORING_SYND_FLAG IS NULL);
SELECT khr.id khr_id,
chr.contract_number,
pdt.id pdt_id,
pdt.name pdt_name,
pdt.reporting_pdt_id,
khr.deal_type,
chr.currency_code
FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt
WHERE chr.id = khr.id
AND chr.scs_code = 'LEASE'
AND chr.sts_code IN ('BOOKED','EVERGREEN') -- Bug 3448049. removed approved and under revision statuses
AND khr.pdt_id = pdt.id
AND khr.multi_gaap_yn = 'Y'
ORDER BY pdt_name;
SELECT stytl.name stream_type,
decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
sum(txl.amount) total_amount
FROM okl_trx_contracts trx, okl_txl_cntrct_lns txl, okl_strm_type_tl stytl
WHERE trx.khr_id = p_khr_id
--Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
AND trx.tsu_code = 'PROCESSED'
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND trx.tcn_type='ACL'
AND trx.accrual_activity in ('ACCRUAL','NON-ACCRUAL','CATCH-UP')
AND trx.date_transaction_occurred BETWEEN p_date_from AND p_date_to
AND trx.id = txl.tcn_id
AND txl.sty_id = stytl.id
AND stytl.language = USERENV('LANG')
GROUP BY stytl.name, decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL');
SELECT fad.asset_category_id,
decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
SUM(fds.deprn_amount) deprn_amount
FROM
OKL_TRX_CONTRACTS trx,
OKC_K_ITEMS cli,
OKC_K_LINES_B cle,
OKC_LINE_STYLES_B cls,
FA_BOOKS fab,
FA_ADDITIONS_B fad,
FA_BOOK_CONTROLS fbc,
FA_CATEGORIES_B fcb,
FA_DEPRN_SUMMARY fds,
FA_DEPRN_PERIODS fdp,
FA_CALENDAR_PERIODS fcp
WHERE trx.khr_id = p_khr_id
--Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
AND trx.tsu_code = 'PROCESSED'
--rkuttiya added for 12.1.1 Multi GAAP Project
AND trx.representation_type = 'PRIMARY'
--
AND trx.tcn_type = 'ACL'
AND trx.accrual_activity IN ('ACCRUAL','CATCH-UP','NON-ACCRUAL')
AND trx.khr_id = cle.dnz_chr_id
AND cle.id = cli.cle_id
AND cli.dnz_chr_id = cle.dnz_chr_id
AND cle.lse_id = cls.id
AND cls.lty_code = 'FIXED_ASSET'
AND fad.asset_id = TO_NUMBER(cli.object1_id1)
AND fad.asset_category_id = fcb.category_id
AND fad.asset_id = fab.asset_id
AND fab.book_type_code = fbc.book_type_code
AND fab.transaction_header_id_out is null
AND NVL(fbc.date_ineffective,sysdate+1) > sysdate
AND fbc.book_class = 'CORPORATE'
AND fds.asset_id = fad.asset_id
AND fds.book_type_code = fab.book_type_code
AND fds.book_type_code = fdp.book_type_code
AND fds.period_counter = fdp.period_counter
AND fdp.period_name = fcp.period_name
AND fcp.start_date BETWEEN p_start_date AND p_end_date
AND fcp.end_date BETWEEN p_start_date AND p_end_date
AND trx.date_accrual BETWEEN p_start_date and p_end_date
GROUP BY fad.asset_category_id,decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL');
SELECT stytl.name stream_type,
sty.accrual_yn,
chr.currency_code,
ABS(SUM(ste.amount)) total_amount
FROM OKL_STRM_TYPE_TL stytl,
OKL_STRM_TYPE_B sty,
OKL_STREAMS stm,
OKL_STRM_ELEMENTS ste,
OKL_PROD_STRM_TYPES psty,
OKL_K_HEADERS khr,
OKC_K_HEADERS_B chr,
OKL_PRODUCTS pdt
WHERE stm.khr_id = p_khr_id
AND khr.id = chr.id
AND khr.id = stm.khr_id
AND stm.active_yn = 'N'
AND stm.purpose_code = 'REPORT'
AND stm.say_code='CURR'
AND stm.sty_id = stytl.id
AND stytl.id = sty.id
AND stytl.language = USERENV('LANG')
AND stytl.id = psty.sty_id
AND psty.pdt_id = pdt.reporting_pdt_id
AND pdt.id = khr.pdt_id
AND psty.accrual_yn = 'Y'
AND stm.id = ste.stm_id
AND ste.stream_element_date BETWEEN p_accrue_from_date AND p_accrue_till_date
GROUP BY stytl.name, sty.accrual_yn, chr.currency_code;
SELECT fad.asset_category_id,
SUM(fds.deprn_amount) deprn_amount
FROM
OKC_K_ITEMS cli,
OKC_K_LINES_B cle,
OKC_LINE_STYLES_B cls,
FA_BOOKS fab,
FA_ADDITIONS_B fad,
FA_BOOK_CONTROLS fbc,
FA_CATEGORIES_B fcb,
FA_DEPRN_SUMMARY fds,
FA_DEPRN_PERIODS fdp,
FA_CALENDAR_PERIODS fcp
WHERE cle.dnz_chr_id = p_khr_id
AND cle.id = cli.cle_id
AND cli.dnz_chr_id = cle.dnz_chr_id
AND cle.lse_id = cls.id
AND cls.lty_code = 'FIXED_ASSET'
AND fad.asset_id = TO_NUMBER(cli.object1_id1)
AND fad.asset_category_id = fcb.category_id
AND fad.asset_id = fab.asset_id
AND fab.book_type_code = p_book_type_code
AND fab.book_type_code = fbc.book_type_code
AND fab.transaction_header_id_out is null
AND NVL(fbc.date_ineffective,sysdate+1) > sysdate
AND fbc.book_class = 'TAX'
AND fds.asset_id = fad.asset_id
AND fds.book_type_code = fab.book_type_code
AND fds.book_type_code = fdp.book_type_code
AND fds.period_counter = fdp.period_counter
AND fdp.period_name = fcp.period_name
AND fcp.start_date BETWEEN p_start_date AND p_end_date
AND fcp.end_date BETWEEN p_start_date AND p_end_date
GROUP BY fad.asset_category_id;
SELECT pdt.name product_name,
chr.currency_code,
stytl.name stream_type,
decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
SUM(txl.amount) total_amount
FROM OKL_STRM_TYPE_TL stytl,
OKL_K_HEADERS khr,
OKC_K_HEADERS_B chr,
OKL_PRODUCTS pdt,
OKL_TRX_CONTRACTS trx,
OKL_TXL_CNTRCT_LNS txl
WHERE chr.id = khr.id
AND pdt.id = khr.pdt_id
AND khr.multi_gaap_yn = 'Y'
AND khr.id = trx.khr_id
--Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
AND trx.tsu_code = 'PROCESSED'
--rkuttiya added for 12.1.1 Multi GAAP
AND representation_type = 'PRIMARY'
--
AND trx.tcn_type='ACL'
AND trx.accrual_activity in ('ACCRUAL','NON-ACCRUAL','CATCH-UP')
AND trx.date_transaction_occurred BETWEEN p_from_date AND p_to_date
AND trx.id = txl.tcn_id
AND txl.sty_id = stytl.id
AND stytl.language = USERENV('LANG')
GROUP BY pdt.name, chr.currency_code, stytl.name,decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL');
SELECT name
FROM hr_operating_units
WHERE organization_id = p_org_id;
SELECT generate_accrual_override_yn
FROM okl_k_headers
WHERE id = p_khr_id;
select secondary_rep_method
from okl_sys_acct_opts;