[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(SUM(to_number(rules.rule_information2)),0) total_share
FROM okc_rules_b rules
,okc_rule_groups_b rule_group
WHERE rule_group.id = rules.rgp_id
AND rules.rule_information_category = 'VGLRSP'
AND rule_group.rgd_code = 'VGLRS'
AND rule_group.dnz_chr_id = cp_chr_id;
SELECT rules.rule_information2 share_percent
FROM okc_rules_b rules
,okc_rule_groups_b rule_group
WHERE rule_group.id = rules.rgp_id
AND rules.rule_information_category = 'VGLRSP'
AND rule_group.rgd_code = 'VGLRS'
AND rule_group.dnz_chr_id = cp_chr_id;
SELECT start_date,
end_date
,chr_id
,crs_id
,assoc_object_id
,assoc_object_version
,assoc_object_type_code
FROM OKL_VP_ASSOCIATIONS
WHERE id = cp_id;
SELECT 'X'
FROM okl_vp_associations
WHERE crs_id = cp_crs_id
AND chr_id IS NULL
AND id <> cp_id
AND assoc_object_id = cp_object_id
AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
AND (
(trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
(trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
);
SELECT 'X'
FROM okl_vp_associations
WHERE chr_id = cp_chr_id
AND crs_id IS NULL
AND id <> cp_id
AND assoc_object_id = cp_object_id
AND (assoc_object_version = cp_object_version OR assoc_object_version IS NULL)
AND (
(trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
(trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
);
SELECT MEANING
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = p_lookup_type
AND FND.LOOKUP_CODE = p_lookup_code;
SELECT start_date,
end_date,
contract_number,
inv_organization_id,
sts_code
FROM OKC_K_HEADERS_B
WHERE id = cp_chr_id;
SELECT temp.name, --temp.reference_number,
vers.version_status
FROM OKL_LEASEAPP_TMPLS temp,
okl_leaseapp_templ_versions_v vers
WHERE temp.id = cp_id
AND vers.leaseapp_template_id = temp.id
-- Manu 02-Sep-2005 version changed to version_number
AND vers.version_number = cp_version ;
SELECT vp_assoc.id,
vp_assoc.start_date,
vp_assoc.end_date,
vp_assoc.assoc_object_type_code,
vp_assoc.assoc_object_id,
vp_assoc.assoc_object_version
FROM okl_vp_associations vp_assoc
,okc_k_headers_b chr
,okc_statuses_b sts
WHERE vp_assoc.chr_id = cp_chr_id
AND vp_assoc.chr_id = chr.id
AND sts.code = chr.sts_code
AND sts.ste_Code = 'ENTERED'
UNION
-- for association type of change request
SELECT vpa.id,
vpa.start_date,
vpa.end_date,
vpa.assoc_object_type_code,
vpa.assoc_object_id,
vpa.assoc_object_version
FROM okl_vp_associations vpa,
okl_vp_change_requests creq
WHERE creq.chr_id = cp_chr_id
AND vpa.crs_id = creq.id
AND creq.status_code in ('PASSED','NEW','INCOMPLETE');
SELECT vpa.id,
vpa.start_date,
vpa.end_date,
vpa.assoc_object_type_code,
vpa.assoc_object_id,
vpa.assoc_object_version
FROM okl_vp_associations vpa,
okl_vp_change_requests creq
WHERE vpa.crs_id = (select crs_id from okl_k_headers where id = cp_chr_id)
AND vpa.crs_id = creq.id
AND creq.status_code in ('PASSED','NEW','INCOMPLETE')
*/
-- Cursor to fetch the items name, associated to an agreement.
CURSOR get_item_name(p_org_id IN NUMBER, p_item_id IN NUMBER) IS
SELECT description
FROM MTL_SYSTEM_ITEMS_VL
WHERE organization_id = p_org_id
AND inventory_item_id = p_item_id;
SELECT CATEGORY_CONCAT_SEGS
FROM MTL_CATEGORIES_V
WHERE CATEGORY_ID = p_item_catg_id;
SELECT end_of_term_name
FROM OKL_FE_EO_TERMS_V
WHERE end_of_term_id = p_eot_id;
SELECT name
FROM OKL_PRODUCTS
WHERE id = p_prod_id;
SELECT chrb.contract_number,
chrb.sts_code,
chrb.start_date,
chrb.end_date
FROM OKC_GOVERNANCES govb,
OKC_K_HEADERS_B chrb
WHERE govb.chr_id = cp_chr_id
AND govb.chr_id_referred = chrb.id;
SELECT cust_credit_classification,
credit_review_purpose,
industry_code,
name,
industry_class
FROM OKL_LEASEAPP_TMPLS
WHERE id = cp_assoc_id;
SELECT lat.name
FROM OKL_LEASEAPP_TMPLS lat,
okl_vp_associations_v vpa,
okc_k_headers_b chr,
okc_statuses_b sts
WHERE lat.id = vpa.assoc_object_id
AND chr.id = vpa.chr_id
AND chr.sts_code = sts.code
AND sts.ste_code = 'ENTERED'
AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
AND vpa.chr_id = cp_chr_id
AND lat.cust_credit_classification = cp_credit_class
AND lat.credit_review_purpose = cp_credit_review
AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
AND vpa.id <> cp_id
AND vpa.assoc_object_id <> cp_object_id
AND (
(trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
(trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
)
UNION
SELECT lat.name
FROM OKL_LEASEAPP_TMPLS lat,
okl_vp_associations_v vpa,
okl_vp_change_requests chreq
WHERE lat.id = vpa.assoc_object_id
AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
AND chreq.chr_id = cp_chr_id
AND vpa.crs_id = chreq.id
AND lat.cust_credit_classification = cp_credit_class
AND lat.credit_review_purpose = cp_credit_review
AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
AND vpa.id <> cp_id
AND vpa.assoc_object_id <> cp_object_id
AND (
(trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
(trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
)
AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
UNION
SELECT lat.name
FROM OKL_LEASEAPP_TMPLS lat,
okl_vp_associations_v vpa,
okl_vp_change_requests chreq,
okl_k_headers okl
WHERE lat.id = vpa.assoc_object_id
AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
AND okl.id = cp_chr_id
AND vpa.crs_id = okl.crs_id
AND lat.cust_credit_classification = cp_credit_class
AND lat.credit_review_purpose = cp_credit_review
AND NVL(lat.industry_code, OKL_API.G_MISS_CHAR) = NVL(cp_sic_code,OKL_API.G_MISS_CHAR)
AND NVL(lat.industry_class,OKL_API.G_MISS_CHAR) = NVL(cp_industry_class, OKL_API.G_MISS_CHAR)
AND vpa.id <> cp_id
AND vpa.assoc_object_id <> cp_object_id
AND (
(trunc(cp_start_date) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date))) OR
(trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
)
AND chreq.id = vpa.crs_id
AND chreq.status_code in ('PASSED','NEW','INCOMPLETE');
SELECT crit.effective_from_date
,crit.effective_to_date
,crit.match_criteria_code
,cdef.crit_cat_name
FROM okl_fe_criteria crit
,okl_fe_criteria_set cset
,okl_fe_Crit_cat_def_v cdef
WHERE crit.criteria_set_id = cset.criteria_set_id
AND cdef.crit_cat_def_id = crit.crit_cat_def_id
AND source_id = cp_chr_id
AND source_object_code = 'VENDOR_PROGRAM';