[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ID,SAV_SAE_ID,NAME
from okc_k_articles_v
where dnz_chr_id = p_chr_id
and chr_id = p_chr_id
and cat_type='STA';
SELECT 'E'
FROM okc_k_articles_b
WHERE SAV_SAE_ID in (
SELECT SAE_ID from OKC_STD_ART_INCMPTS_V
WHERE SAE_ID_FOR = p_sae_id
UNION
SELECT SAE_ID_FOR from OKC_STD_ART_INCMPTS_V
WHERE SAE_ID = p_sae_id
)
AND DNZ_CHR_ID = p_chr_id
AND CHR_ID = p_chr_id
AND ID <> l_id;
SELECT RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' ||
RTRIM(clev.name)) "LINE_NAME", currency_code,
clev.lse_id, --bug 2398639
clev.cle_id --bug 2398639
FROM OKC_LINE_STYLES_V lsev,
OKC_K_LINES_V clev
WHERE lsev.id = clev.lse_id
AND clev.dnz_chr_id = p_chr_id
AND clev.date_cancelled is NULL; --changes [llc]--
SELECT ctc.JTOT_OBJECT1_CODE, ctc.OBJECT1_ID1, ctc.OBJECT1_ID2,
fnd.MEANING
FROM FND_LOOKUPS fnd,
OKC_CONTACTS ctc
WHERE fnd.LOOKUP_CODE = ctc.cro_code
AND fnd.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND ctc.cpl_id = p_cpl_id;
SELECT cpl.ID, cpl.JTOT_OBJECT1_CODE, cpl.OBJECT1_ID1, cpl.OBJECT1_ID2,
fnd.MEANING, cpl.rle_code, cpl.chr_id, cpl.cle_id
FROM FND_LOOKUPS fnd,
OKC_K_PARTY_ROLES_B cpl
WHERE fnd.LOOKUP_CODE = cpl.rle_code
AND fnd.LOOKUP_TYPE = 'OKC_ROLE'
AND cpl.dnz_chr_id = p_chr_id;
SELECT count(distinct RLE_CODE)
FROM OKC_K_PARTY_ROLES_B cpl
WHERE cpl.dnz_chr_id = p_chr_id
AND cpl.cle_id is NULL;
SELECT chrv.*, sub.cls_code
FROM OKC_K_HEADERS_B chrv,
OKC_SUBCLASSES_B sub
WHERE chrv.id = p_chr_id
AND sub.code = chrv.scs_code;
SELECT cle.chr_id
FROM OKC_K_LINES_B cle
WHERE cle.id = p_id;
SELECT 'x'
FROM OKC_K_PARTY_ROLES_B
WHERE dnz_chr_id = p_chr_id
AND chr_id = p_chr_id
AND rle_code = l_cpl1_rec.rle_code
AND jtot_object1_code = l_cpl1_rec.jtot_object1_code
AND object1_id1 = l_cpl1_rec.object1_id1
AND object1_id2 = l_cpl1_rec.object1_id2;
SELECT 'Y'
FROM okc_rule_groups_b rgp
,okc_rules_b rul
WHERE rgp.dnz_chr_id = b_chr_id
AND rgp.cle_id IS NULL
AND rul.rgp_id = rgp.id
AND rul.rule_information_category = 'CAN';
SELECT 'x'
FROM OKC_COVER_TIMES cti
WHERE cti.rul_id = p_rul_rec.id;
SELECT 'x'
FROM OKC_REACT_INTERVALS ril
WHERE ril.rul_id = p_rul_rec.id;
SELECT decode(sign(nvl(rgr.min_cardinality, 0)), 1, 'N', 'Y')
FROM OKC_RG_DEF_RULES rgr
WHERE rgr.rdf_code = p_rul_rec.rule_information_category
AND rgr.rgd_code = p_rgd_code;
SELECT fnd.MEANING
FROM FND_LOOKUPS fnd
WHERE fnd.LOOKUP_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY
AND fnd.LOOKUP_TYPE = 'OKC_RULE_DEF';
SELECT MEANING
FROM okc_rule_defs_v
WHERE RULE_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY;
SELECT END_USER_COLUMN_NAME, FLEX_VALUE_SET_ID, REQUIRED_FLAG
FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu
-- WHERE dfcu.descriptive_flexfield_name = 'OKC Rule Developer DF' -- /striping/
WHERE dfcu.descriptive_flexfield_name = dff_name
AND dfcu.descriptive_flex_context_code = p_rule_cat
AND dfcu.application_column_name = p_attribute
-- AND dfcu.application_id =510; -- /striping/
sql_stmt := 'SELECT END_USER_COLUMN_NAME, FLEX_VALUE_SET_ID, REQUIRED_FLAG ' ||
' FROM FND_DESCR_FLEX_COL_USAGE_VL dfcu ' ||
' WHERE dfcu.application_id=510 and dfcu.descriptive_flexfield_name = ' ||
''''||G_DESCRIPTIVE_FLEXFIELD_NAME||'''' ||
' AND dfcu.descriptive_flex_context_code = :rule_cat ' ||
' AND dfcu.application_column_name = :attribute' ;
SELECT chr.*, sub.cls_code
FROM OKC_K_HEADERS_B chr,
OKC_SUBCLASSES_B sub
WHERE chr.id = p_chr_id
AND sub.code = chr.scs_code;
SELECT fnd.MEANING
FROM FND_LOOKUPS fnd
WHERE fnd.LOOKUP_CODE = 'CURRENCY'
AND fnd.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF';
SELECT 'x'
FROM OKC_RULE_GROUPS_B rgp, OKC_RULES_B rul
WHERE rgp.rgd_code = p_rgd_code
AND rgp.dnz_chr_id = p_chr_id
AND rul.dnz_chr_id = rgp.dnz_chr_id
AND rgp.cle_id is null
AND rul.rgp_id = rgp.id
AND rul.rule_information_category = 'CVN'
AND rul.rule_information1 is not null
AND rul.rule_information2 is not null
AND rul.object1_id1 is not null;
SELECT rgp.id, rgp.rgd_code, fnd.meaning rule_group_name,
rgp.chr_id, rgp.cle_id,
rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
fnd1.meaning rule_name
FROM FND_LOOKUPS fnd,
FND_LOOKUPS fnd1,
OKC_RG_DEF_RULES rgr,
OKC_RULE_GROUPS_B rgp
WHERE rgp.dnz_chr_id = p_chr_id
AND fnd.lookup_code = rgp.rgd_code
AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'
AND rgr.rgd_code = rgp.rgd_code
AND rgr.rdf_code = fnd1.lookup_code
AND fnd1.lookup_type = 'OKC_RULE_DEF'
ORDER BY rgp.id;
SELECT rgp.id, rgp.rgd_code, fnd.meaning rule_group_name,
rgp.chr_id, rgp.cle_id,
rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
fnd1.meaning rule_name
FROM FND_LOOKUPS fnd,
okc_rule_defs_v fnd1,
OKC_RG_DEF_RULES rgr,
OKC_RULE_GROUPS_B rgp
WHERE rgp.dnz_chr_id = p_chr_id
AND fnd.lookup_code = rgp.rgd_code
AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'
AND rgr.rgd_code = rgp.rgd_code
AND rgr.rdf_code = fnd1.rule_code
ORDER BY rgp.id;
SELECT rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
fnd.meaning
FROM OKC_RG_DEF_RULES rgr,
FND_LOOKUPS fnd
WHERE rgr.rgd_code = p_rgd_code
AND rgr.rdf_code = fnd.lookup_code
AND fnd.lookup_type = 'OKC_RULE_DEF';
SELECT count(*)
FROM OKC_RULES_B rul
WHERE rul.rule_information_category = p_rdf_code
AND rul.rgp_id = p_rgp_id;
SELECT rul.*
FROM OKC_RULES_B rul
WHERE rgp_id = l_rgp_rec.id;
SELECT cle.chr_id
FROM OKC_K_LINES_B cle
WHERE cle.id = p_id;
SELECT chr.template_yn,chr.application_id
FROM OKC_K_HEADERS_B chr
WHERE chr.id = p_chr_id;
SELECT rgp.id "RGP_ID", rrd.id "RRD_ID", rgp.rgd_code , sre.rle_code,
fndrgd.meaning "RGD_MEANING", fndrle.meaning "RLE_MEANING",
rgp.chr_id, rgp.cle_id
FROM FND_LOOKUPS fndrle,
FND_LOOKUPS fndrgd,
OKC_SUBCLASS_ROLES sre,
OKC_RG_ROLE_DEFS rrd,
OKC_SUBCLASS_RG_DEFS srd,
OKC_RULE_GROUPS_B rgp,
OKC_K_HEADERS_B chr
WHERE fndrle.LOOKUP_CODE = sre.rle_code
AND fndrle.LOOKUP_TYPE = 'OKC_ROLE'
AND fndrgd.LOOKUP_CODE = srd.rgd_code
AND fndrgd.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF'
AND sre.id = rrd.sre_id
AND NVL(rrd.optional_yn, 'N') = 'N'
AND rrd.srd_id = srd.id
AND srd.rgd_code = rgp.rgd_code
AND srd.scs_code = chr.scs_code
AND rgp.dnz_chr_id = chr.id
AND chr.id = p_chr_id;
SELECT rpr.cpl_id
FROM OKC_RG_PARTY_ROLES rpr
WHERE rpr.rgp_id = l_rrd_rec.rgp_id
AND rpr.rrd_id = l_rrd_rec.rrd_id;
SELECT kpr.rle_code, fl.meaning
FROM OKC_K_PARTY_ROLES_B kpr,
FND_LOOKUPS fl
WHERE kpr.id = p_id
AND fl.lookup_type = 'OKC_ROLE'
AND fl.lookup_code = kpr.rle_code;
g_msg_name := 'OKC_QA_K_RULE_ROLE_DELETED';
g_msg_name := 'OKC_QA_KL_RULE_ROLE_DELETED';
SELECT start_date, end_date
FROM OKC_K_HEADERS_B chrv
WHERE chrv.id = p_chr_id;
SELECT level, start_date, end_date, line_number,
id, chr_id, cle_id,lse_id
FROM OKC_K_LINES_B
WHERE date_cancelled is null --changes [llc]-- bug #4727744 -- to ignore cancelled lines
START WITH chr_id = p_chr_id
CONNECT BY PRIOR id = cle_id
AND date_cancelled is NULL; --changes [llc]-- to ignore cancelled sublines
SELECT kla.start_date, kla.end_date,
kla.id, kla.chr_id, kla.lse_id,
--
klb.start_date parent_start_date, klb.end_date parent_end_date
FROM okc_k_lines_b kla,
okc_k_lines_b klb
WHERE kla.dnz_chr_id = p_chr_id
AND kla.cle_id = klb.id (+)
AND kla.date_cancelled is NULL
AND klb.date_cancelled is NULL;
SELECT Rtrim(Rtrim(cle.line_number) || ', ' || lse.name ||
' ' || cle.name) "LINE_NAME"
FROM OKC_LINE_STYLES_TL lse,
OKC_K_LINES_V cle
WHERE cle.id = p_cle_id
and lse.id = cle.lse_id
and lse.language = userenv('LANG');
l_cle_tbl.delete;