[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.id = p_id;
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
select rgp.id
from okc_rule_groups_b rgp
where rgp.rgd_code = p_rgd_code
and rgp.chr_id = p_khr_id;
select rul.id
from okc_rules_b rul
where rul.rgp_id = p_rgp_id
and rul.dnz_chr_id = p_khr_id
and rul.rule_information_category = p_rdf_code;
select cle.id
from okc_k_lines_b cle,
okc_statuses_b sts
where cle.dnz_chr_id = p_khr_id
and cle.lse_id = p_lse_id
and cle.sts_code = sts.code
and sts.code not in ('ACTIVE','HOLD','EXPIRED','TERMINATED','CANCELED')
and nvl(cle.end_date,sysdate+1) > sysdate;
select rgp.id
from okc_rule_groups_b rgp
where rgp.rgd_code = p_rgd_code
and rgp.dnz_chr_id = p_khr_id
and rgp.cle_id = p_kle_id;
select rul.id
from okc_rules_b rul
where rul.rgp_id = p_rgp_id
and rul.dnz_chr_id = p_khr_id
and rul.rule_information_category = p_rdf_code;
SELECT chr.scs_code,
chr.authoring_org_id,
chr.buy_or_sell,
chr.inv_organization_id,
chr.start_date,
chr.end_date,
chr.sts_code,
khr.pdt_id
FROM OKL_K_HEADERS khr,
OKC_K_HEADERS_B chr
WHERE khr.id = chr.id
AND chr.id = p_khr_id;
SELECT ID,
POV_ID, --required
KHR_ID -- fk to okc_k_headers_b.id
FROM OKL_SLCTD_OPTNS
WHERE KHR_ID = p_khr_id
and POV_ID = p_pov_id;
SELECT pov.OVE_ID, --required fk to okl_opt_values (okl_opv_rules_v.ove_id)
pov.ID,
pov.PON_ID,
pon.opt_id --product option id fk okl_pdt_opts
FROM OKL_PDT_OPT_VALS pov,
OKL_PDT_OPTS pon
WHERE pov.ID = p_pov_id --(p_pov id will be pov id fetched in last csr)
AND nvl(pov.FROM_DATE,sysdate) <= sysdate
AND nvl(pov.TO_DATE,sysdate+1) > sysdate
AND pon.id = pov.pon_id
AND nvl(pon.FROM_DATE,sysdate) <= sysdate
AND nvl(pon.TO_DATE,sysdate+1) > sysdate;
SELECT ovd.OVE_ID, -- fk to okl_opt_values (okl_opv_rules_v.ove_id)
ovd.ID,
ovd.ORL_ID, --required fk to okl_opt_ruls
ovd.CONTEXT_INTENT, --should be same as khr intent
ovd.COPY_OR_ENTER_FLAG, --if it 'CPY' copy to k and do not allow modfn, else sllow mdfn
ovd.CONTEXT_INV_ORG, --should be same as khr inv org
ovd.CONTEXT_ORG, --should be same as contract org_id
ovd.CONTEXT_ASSET_BOOK, --what chk on this??
ovd.INDIVIDUAL_INSTRUCTIONS
FROM OKL_OPV_RULES ovd,
OKL_OPT_VALUES ove
WHERE ovd.ove_id = ove.id
AND nvl(ove.FROM_DATE,sysdate) <= sysdate
AND nvl(ove.TO_DATE,sysdate+1) > sysdate
AND ove.ID = p_ove_id; --(p_ove id will be ove id fetched in last csr)
SELECT RUL_ID, --required fk to okc_rules_v.id
OVD_ID --fk to okl_opv_rules.id
FROM OKL_OVD_RUL_TMLS
WHERE OVD_ID = p_ovd_id; --(p_ovd_id will be id fetched in the last cursor)
SELECT orl.SRD_ID_FOR,
orl.LRG_SRD_ID,
orl.LRG_LSE_ID,
orl.RGR_RGD_CODE,
orl.RGR_RDF_CODE
FROM OKL_OPT_RULES orl,
OKC_SUBCLASS_RG_DEFS srd
WHERE srd.id = orl.SRD_ID_FOR
AND srd.rgd_code = orl.rgr_rgd_code
AND srd.scs_code = p_scs_code
AND nvl(srd.start_date,sysdate) <= sysdate
AND nvl(srd.end_date,sysdate+1) > sysdate
AND orl.rgr_rdf_code = p_rdf_code
AND orl.lrg_srd_id is null
AND orl.lrg_lse_id is null
AND orl.opt_id = p_opt_id; --(p_orl_id is ovd.ORL_ID fetched in l_opv_ruls_csr)
SELECT orl.SRD_ID_FOR,
orl.LRG_SRD_ID,
orl.LRG_LSE_ID,
orl.RGR_RGD_CODE,
orl.RGR_RDF_CODE
FROM OKL_OPT_RULES orl,
OKC_SUBCLASS_RG_DEFS srd,
OKC_LSE_RULE_GROUPS lrg
WHERE srd.id = lrg.SRD_ID
AND srd.rgd_code = orl.rgr_rgd_code
AND srd.scs_code = p_scs_code
AND nvl(srd.start_date,sysdate) <= sysdate
AND nvl(srd.end_date,sysdate+1) > sysdate
AND lrg.lse_id = orl.lrg_lse_id
AND lrg.srd_id = orl.lrg_srd_id
AND orl.rgr_rdf_code = p_rdf_code
AND orl.srd_id_for is null
AND orl.opt_id = p_opt_id; --(p_orl_id is ovd.ORL_ID fetched in l_opv_ruls_csr)