[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT effective_from_date
,effective_to_date
,subsidy_pool_name
FROM okl_subsidy_pools_b
WHERE id = cp_subsidy_pool_id;
SELECT trx_reason_code
,subsidy_pool_amount
,conversion_rate
FROM okl_trx_subsidy_pools
WHERE trx_type_code = 'REDUCTION'
AND source_type_code = G_TRX_SOURCE_TYPE_CODE
AND source_object_id = cp_source_object_id
AND subsidy_pool_id = cp_subsidy_pool_id
AND subsidy_pool_currency_code = cp_pool_currency_code
AND vendor_id = cp_vendor_id
AND subsidy_id = cp_subsidy_id
AND dnz_asset_number = cp_asset_number
AND trx_amount = cp_trx_amount
AND trx_currency_code = cp_trx_currency_code;
SELECT kle.subsidy_id
,clet.name
,clet.item_description
,kle.amount
,kle.subsidy_override_amount
,cplb.object1_id1 vendor_id
,cplb.id cpl_id
,kle.sty_id sty_id
,cleb.cle_id asset_id
,cleb.currency_code
FROM okl_k_lines kle
,okc_k_lines_tl clet
,okc_k_lines_b cleb
,okc_statuses_b stsb
,okc_line_styles_b lseb
,okc_k_party_roles_b cplb
WHERE kle.id = cleb.id
AND clet.id = cleb.id
AND clet.language = userenv('LANG')
AND cleb.dnz_chr_id = cp_chr_id
AND stsb.code = cleb.sts_code
AND stsb.ste_code not in ('CANCELLED')
AND lseb.id = cleb.lse_id
AND lseb.lty_code = 'SUBSIDY'
AND cplb.cle_id = cleb.id
AND cplb.rle_code = 'OKL_VENDOR'
AND cplb.dnz_chr_id = cp_chr_id;
SELECT clev_asst.name asset_number
FROM okc_k_lines_v clev_asst
WHERE clev_asst.id = cp_asset_id;
lv_six_tbl.DELETE; lx_six_tbl.DELETE;
SELECT clev_asst.name asset_number
,clev_asst.start_date asset_start_date
,clev_asst.currency_code
FROM okc_k_lines_v clev_asst
WHERE clev_asst.id = p_asset_id;
SELECT orig_system_id1
,orig_system_source_code
,scs_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT vendor_id
FROM okl_asset_subsidy_uv
WHERE asset_cle_id = p_asset_id;
SELECT clet_sub.name subsidy_name,
clet_asst.name asset_number,
subb.id subsidy_id
FROM okl_subsidies_b subb,
okl_k_lines kle_sub,
okc_k_lines_tl clet_sub,
okc_k_lines_b cleb_sub,
okc_line_styles_b lseb_sub,
okc_k_lines_tl clet_asst,
okc_k_lines_b cleb_asst,
okc_line_styles_b lseb_asst
WHERE subb.id = kle_sub.subsidy_id
AND kle_sub.id = cleb_sub.id
AND clet_sub.id = cleb_sub.id
AND clet_sub.language = userenv('LANG')
AND cleb_sub.cle_id = cleb_asst.id
AND cleb_sub.dnz_chr_id = cleb_asst.dnz_chr_id
AND cleb_sub.sts_code <> 'ABANDONED'
AND lseb_sub.id = cleb_sub.lse_id
AND lseb_sub.lty_code = 'SUBSIDY'
AND clet_asst.id = cleb_asst.id
AND clet_asst.language = userenv('LANG')
AND cleb_asst.chr_id = cp_chr_id
AND cleb_asst.dnz_chr_id = cp_chr_id
AND lseb_asst.id = cleb_asst.lse_id
AND lseb_asst.lty_code = 'FREE_FORM1'
AND cleb_asst.sts_code <> 'ABANDONED';
SELECT source_type_code
,source_object_id
,subsidy_pool_id
,dnz_asset_number
,vendor_id
,source_trx_date
,trx_date
,subsidy_id
,trx_reason_code
,trx_currency_code
,trx_amount
,subsidy_pool_currency_code
,subsidy_pool_amount
,conversion_rate
FROM okl_trx_subsidy_pools
WHERE source_object_id = cp_chr_id
AND dnz_asset_number = cp_asset_number
AND subsidy_id = cp_subsidy_id
AND subsidy_pool_id = cp_subsidy_pool_id
AND source_type_code = G_TRX_SOURCE_TYPE_CODE
AND trx_type_code = G_REDUCTION_TYPE_CODE;
idx := 0; lv_sixv_tbl.DELETE; lx_sixv_tbl.DELETE;
SELECT kle.SUBSIDY_ID
,clet.NAME
,clet.ITEM_DESCRIPTION
,kle.AMOUNT
,kle.SUBSIDY_OVERRIDE_AMOUNT
,cleb.orig_system_id1
,cplb.object1_id1 vendor_id
,cplb.id cpl_id
,kle.sty_id sty_id
,cleb.cle_id asset_id
,cleb.currency_code
FROM okl_k_lines kle
,okc_k_lines_tl clet
,okc_k_lines_b cleb
,okc_statuses_b stsb
,okc_line_styles_b lseb
,okc_k_party_roles_b cplb
WHERE kle.id = cleb.id
AND clet.id = cleb.id
AND clet.language = userenv('LANG')
AND cleb.dnz_chr_id = p_chr_id
AND cleb.orig_system_id1 is not null
AND stsb.code = cleb.sts_code
AND stsb.ste_code not in ('CANCELLED')
AND lseb.id = cleb.lse_id
AND lseb.lty_code = 'SUBSIDY'
AND cplb.cle_id = cleb.id
AND cplb.rle_code = 'OKL_VENDOR'
AND cplb.dnz_chr_id = p_chr_id;
SELECT kle.SUBSIDY_ID
,clet.NAME
,clet.ITEM_DESCRIPTION
,kle.AMOUNT
,kle.SUBSIDY_OVERRIDE_AMOUNT
,cplb.object1_id1 vendor_id
,cplb.id cpl_id
,kle.sty_id sty_id
,cleb.cle_id asset_id
,cleb.currency_code
FROM okl_k_lines kle
,okc_k_lines_tl clet
,okc_k_lines_b cleb
,okc_statuses_b stsb
,okc_line_styles_b lseb
,okc_k_party_roles_b cplb
WHERE kle.id = cleb.id
AND clet.id = cleb.id
AND clet.language = userenv('LANG')
AND cleb.id = p_cle_id
AND cleb.dnz_chr_id = p_chr_id
AND stsb.code = cleb.sts_code
AND stsb.ste_code not in ('CANCELLED')
AND lseb.id = cleb.lse_id
AND lseb.lty_code = 'SUBSIDY'
AND cplb.cle_id = cleb.id
AND cplb.rle_code = 'OKL_VENDOR'
AND cplb.dnz_chr_id = p_chr_id;
SELECT cleb.id subsidy_id
,cplb.id cpl_id
,cplb.object1_id1 vendor_id
,kle.AMOUNT
,kle.SUBSIDY_OVERRIDE_AMOUNT
,cleb.cle_id asset_id
,cleb.currency_code
,kle.subsidy_id subsidy
FROM okc_k_lines_b cleb
,okc_line_styles_b lseb
,okc_k_party_roles_b cplb
,okl_k_lines kle
WHERE cleb.dnz_chr_id = p_orig_chr_id
AND lseb.id = cleb.lse_id
AND lseb.lty_code = 'SUBSIDY'
AND cplb.cle_id = cleb.id
AND cplb.dnz_chr_id = p_orig_chr_id
AND cplb.rle_code = 'OKL_VENDOR'
AND kle.id = cleb.id
--line was deleted from rebook copy :
AND NOT EXISTS (SELECT '1'
FROM okc_k_lines_b cleb2
WHERE cleb2.orig_system_id1 = cleb.id
AND cleb2.dnz_chr_id = p_rbk_chr_id)
--line is not a new line created during this rebook
AND NOT EXISTS (SELECT '1'
FROM okc_k_lines_b cleb3
WHERE cleb3.id = cleb.orig_system_id1
AND cleb3.dnz_chr_id = p_rbk_chr_id);
SELECT kle.subsidy_id subsidy_id
,cleb.id subsidy_cle_id
,clet.name name
,kle.amount amount
,kle.subsidy_override_amount subsidy_override_amount
,cleb.dnz_chr_id dnz_chr_id
,cleb.cle_id asset_cle_id
,cplb.id cpl_id
,cplb.object1_id1 vendor_id
,cleb.lse_id lse_id
,cleb.start_date start_date
,cleb.end_date end_date
,cleb.currency_code currency_code
,cleb.sts_code sts_code
,kle.sty_id sty_id
,asst_cleb.orig_system_id1 orig_asst_cle_id
FROM okc_k_lines_b asst_cleb
,okc_statuses_b asst_sts
,okc_k_party_roles_b cplb
,okc_k_lines_tl clet
,okl_k_lines kle
,okc_line_styles_b lseb
,okc_k_lines_b cleb
WHERE asst_cleb.id = cleb.cle_id
AND asst_cleb.dnz_chr_id = cleb.dnz_chr_id
AND asst_sts.code = asst_cleb.sts_code
AND asst_sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
AND cplb.jtot_object1_code = 'OKX_VENDOR'
AND cplb.dnz_chr_id = cleb.dnz_chr_id
AND cplb.cle_id = cleb.id
AND cplb.rle_code = 'OKL_VENDOR'
AND clet.id = cleb.id
AND clet.language = userenv('LANG')
AND kle.id = cleb.id
AND lseb.id = cleb.lse_id
AND lseb.lty_code = 'SUBSIDY'
AND cleb.dnz_chr_id = p_chr_id
AND cleb.orig_system_id1 is null
AND asst_cleb.orig_system_id1 is not null
AND cleb.sts_code <> 'ABANDONED';
SELECT name asset_number
FROM okc_k_lines_v
WHERE id = cp_asset_id;
SELECT orig_system_id1
FROM okc_k_lines_b
WHERE id = cp_asset_id;
SELECT ktrx.date_transaction_occurred
FROM okc_k_headers_b chr
,okl_trx_contracts ktrx
WHERE ktrx.khr_id_new = chr.id
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
--rkuttiya added for 12.1.1 Multi GAAP
AND ktrx.representation_type = 'PRIMARY'
--
AND CHR.id = p_rbk_chr_id
AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK';
lv_six_tbl.DELETE; lx_six_tbl.DELETE;
'synch ADD for deleted subsidy lv_six_tbl('||idx||').source_object_id'||lv_six_tbl(idx).source_object_id||
' subsidy_pool_id '||lx_subsidy_pool_id||' vendor_id '||lv_six_tbl(idx).vendor_id||
' subsidy_id '||lv_six_tbl(idx).subsidy_id||' trx_amount '||lv_six_tbl(idx).trx_amount||
' dnz_asset_number '||lv_six_tbl(idx).dnz_asset_number
);
SELECT orig_system_id1
FROM okc_k_headers_b
WHERE id = cp_chr_id
AND orig_system_source_code = 'OKL_SPLIT';
SELECT khr.id, khr.contract_number, khr.start_date, trx.date_transaction_occurred
FROM okc_k_headers_b khr
,okl_trx_contracts trx
WHERE trx.khr_id = khr.id
AND trx.tsu_code = 'PROCESSED'
AND trx.tcn_type = 'SPLC'
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND khr.id = cp_chr_id;