The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT line_number
FROM OKC_K_LINES_BH
WHERE major_version = vVersion
CONNECT BY PRIOR cle_id=id
START WITH id= vk_line_id AND major_version = vVersion;
SELECT line_number
FROM OKC_K_LINES_B
CONNECT BY PRIOR cle_id=id
START WITH id= vk_line_id;
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE ='OKC_SUBJECT'
AND LOOKUP_CODE = p_sbt_code;
SELECT Nvl(display_name,article_title) NAME ,ARTICLE_TYPE
FROM OKC_ARTICLES_V
WHERE article_id = p_id;
PROCEDURE insert_comp_result(vHeader_id IN NUMBER,vVersion1 IN NUMBER, vVersion2 IN NUMBER)
IS
CREATED_BY NUMBER;
LAST_UPDATE_DATE DATE;
LAST_UPDATE_BY NUMBER;
LAST_UPDATE_LOGIN NUMBER;
SELECT o.attribute_name
FROM oke_object_attributes_vl o
WHERE o.attribute_code = l_prompt
AND o.database_object_name=L_Attribute_Object_Name;
LAST_UPDATE_DATE :=SYSDATE;
LAST_UPDATE_BY :=FND_GLOBAL.USER_ID;
LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
INSERT INTO OKE_VERSION_COMPARE_RESULTS
(k_header_id,
version1,
version2,
object_type,
object_id,
object_name,
sequence,
prompt,
v1data,
v2data,
current_flag,
creation_date,
created_by,
last_update_date,
last_update_by,
last_update_login)
VALUES
(vHeader_id,
vVersion1,
vVersion2,
l_object_type,
null,
l_object_name,
l_no_sequence,
L_PROMPT_MULTI,
l_data1,
l_data2,
l_current_flag,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_BY,
LAST_UPDATE_LOGIN);
END insert_comp_result;
SELECT MAX(MAJOR_VERSION)
FROM OKE_K_HEADERS_H
WHERE K_HEADER_ID=p_header_id;
SELECT MAX(version1)
FROM oke_version_compare_results
WHERE k_header_id=p_header_id;
DELETE FROM oke_version_compare_results;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
SELECT k_type,
buy_or_sell,
boa_number,
program_number,
product_line,
status,
project_name,
line_value_total,
undef_line_value_total,
k_value,
k_alias,
currency_code,
priority_rating,
major_version,
award_date,
start_date,
end_date,
prime_k_number,
prime_k_alias,
authoring_org,
--item_master_org,
owning_organization,
short_description,
description,
authorize_date,
date_issued,
date_received,
award_cancel_date,
date_negotiated,
date_approved,
sic_code,
date_sign_by_customer,
date_sign_by_contractor,
faa_approve_date,
customer_po_number,
no_competition_authorize,
export_flag,
classified_flag,
penalty_clause_flag,
reporting_flag,
sb_plan_req_flag,
sb_report_flag,
cqa_flag,
cfe_flag,
prop_delivery_location,
prop_due_date_time,
prop_expire_date,
copies_required,
--billing_methods,
--billing_methods_button,
country_of_origin_code,
vat_code,
cost_of_sale_rate,
nte_amount,
date_definitized,
tech_data_wh_rate,
financial_ctrl_verified_flag,
nte_warning_flag,
cas_flag,
dcaa_audit_req_flag,
interim_rpt_req_flag,
cost_of_money,
oh_rates_final_flag,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
alternate_liquidation_rate,
cost_share_flag,
definitized_flag,
bill_without_def_flag,
comments
INTO r_header_1
FROM OKE_K_HEADERS_SECURE_V
WHERE K_HEADER_ID=vHeader_id;
SELECT k_type,
buy_or_sell,
boa_number,
program_number,
product_line,
status,
project_name,
line_value_total,
undef_line_value_total,
k_value,
k_alias,
currency_code,
priority_rating,
major_version,
award_date,
start_date,
end_date,
prime_k_number,
prime_k_alias,
authoring_org,
--item_master_org,
owning_organization,
short_description,
description,
authorize_date,
date_issued,
date_received,
award_cancel_date,
date_negotiated,
date_approved,
sic_code,
date_sign_by_customer,
date_sign_by_contractor,
faa_approve_date,
customer_po_number,
no_competition_authorize,
export_flag,
classified_flag,
penalty_clause_flag,
reporting_flag,
sb_plan_req_flag,
sb_report_flag,
cqa_flag,
cfe_flag,
prop_delivery_location,
prop_due_date_time,
prop_expire_date,
copies_required,
--billing_methods,
--billing_methods_button,
country_of_origin_code,
vat_code,
cost_of_sale_rate,
nte_amount,
date_definitized,
tech_data_wh_rate,
financial_ctrl_verified_flag,
nte_warning_flag,
cas_flag,
dcaa_audit_req_flag,
interim_rpt_req_flag,
cost_of_money,
oh_rates_final_flag,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
alternate_liquidation_rate,
cost_share_flag,
definitized_flag,
bill_without_def_flag,
comments
INTO r_header_1
FROM OKE_K_HEADERS_SECURE_HV
WHERE K_HEADER_ID=vHeader_id
AND MAJOR_VERSION=vVersion1;
SELECT k_type,
buy_or_sell,
boa_number,
program_number,
product_line,
status,
project_name,
line_value_total,
undef_line_value_total,
k_value,
k_alias,
currency_code,
priority_rating,
major_version,
award_date,
start_date,
end_date,
prime_k_number,
prime_k_alias,
authoring_org,
-- item_master_org,
owning_organization,
short_description,
description,
authorize_date,
date_issued,
date_received,
award_cancel_date,
date_negotiated,
date_approved,
sic_code,
date_sign_by_customer,
date_sign_by_contractor,
faa_approve_date,
customer_po_number,
no_competition_authorize,
export_flag,
classified_flag,
penalty_clause_flag,
reporting_flag,
sb_plan_req_flag,
sb_report_flag,
cqa_flag,
cfe_flag,
prop_delivery_location,
prop_due_date_time,
prop_expire_date,
copies_required,
--billing_methods,
--billing_methods_button,
country_of_origin_code,
vat_code,
cost_of_sale_rate,
nte_amount,
date_definitized,
tech_data_wh_rate,
financial_ctrl_verified_flag,
nte_warning_flag,
cas_flag,
dcaa_audit_req_flag,
interim_rpt_req_flag,
cost_of_money,
oh_rates_final_flag,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
alternate_liquidation_rate,
cost_share_flag,
definitized_flag,
bill_without_def_flag,
comments
INTO r_header_2
FROM OKE_K_HEADERS_SECURE_HV
WHERE K_HEADER_ID=vHeader_id
AND MAJOR_VERSION=vVersion2;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND MAJOR_VERSION=vVersion1
AND CLE_ID IS NULL
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID IS NULL
AND MAJOR_VERSION=vVersion2)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_B a
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID IS NULL
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID IS NULL
AND MAJOR_VERSION=vVersion2)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND MAJOR_VERSION=vVersion2
AND CLE_ID IS NULL
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID IS NULL
AND MAJOR_VERSION=vVersion1)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND MAJOR_VERSION=vVersion2
AND CLE_ID IS NULL
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_B b
WHERE b.ID=a.ID
AND CLE_ID IS NULL)
ORDER BY LINE_NUMBER;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT a.ID K_LINE_ID
FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B
WHERE a.DNZ_CHR_ID=vHeader_id
AND a.MAJOR_VERSION=vVersion1
AND a.CLE_ID IS NULL
AND a.ID = b.ID
AND b.CLE_ID IS NULL
AND b.MAJOR_VERSION=vVersion2
ORDER BY a.LINE_NUMBER
;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT a.ID K_LINE_ID
FROM OKC_K_LINES_B A, OKC_K_LINES_BH B
WHERE a.DNZ_CHR_ID=vHeader_id
AND a.CLE_ID IS NULL
AND a.ID = b.ID
AND b.CLE_ID IS NULL
AND MAJOR_VERSION=vVersion2
ORDER BY a.LINE_NUMBER
;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_line_1
FROM OKE_K_LINES_SECURE_V
WHERE K_LINE_ID=c_top_node;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_line_1
from oke_k_lineS_SECURE_hv
where k_line_id=nCurrent_line_id
and major_version=vVersion1;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_line_2
FROM OKE_K_LINES_SECURE_HV
WHERE K_LINE_ID=nCurrent_line_id
AND MAJOR_VERSION= vVersion2;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT count(*)
INTO nDeliverables
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=nCurrent_line_id
and major_version=vVersion1;
SELECT count(*)
INTO nSublines
FROM okc_k_lines_bh
WHERE CLE_ID=nCurrent_line_id
AND MAJOR_VERSION= vVersion1;
SELECT count(*)
INTO nDeliverables
from oke_k_deliverables_b
where k_header_id=vHeader_id
and k_line_id=nCurrent_line_id;
SELECT count(*)
INTO nSublines
FROM okc_k_lines_b
WHERE CLE_ID=nCurrent_line_id;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion1
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion2)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_B a
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=vParentLineId
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion2)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion2
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_BH b
WHERE b.ID=a.ID
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion1)
ORDER BY LINE_NUMBER;
SELECT ID K_LINE_ID
FROM OKC_K_LINES_BH a
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion2
AND NOT EXISTS
( SELECT 'x'
FROM OKC_K_LINES_B b
WHERE b.ID=a.ID
AND CLE_ID=vParentLineId)
ORDER BY LINE_NUMBER;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT a.ID K_LINE_ID
FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B
WHERE a.DNZ_CHR_ID=vHeader_id
AND a.MAJOR_VERSION=vVersion1
AND a.CLE_ID=vParentLineId
AND a.ID = b.ID
AND b.CLE_ID=vParentLineId
AND b.MAJOR_VERSION=vVersion2
ORDER BY a.LINE_NUMBER
;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT a.ID K_LINE_ID
FROM OKC_K_LINES_B A, OKC_K_LINES_BH B
WHERE a.DNZ_CHR_ID=vHeader_id
AND a.CLE_ID=vParentLineId
AND a.ID = b.ID
AND b.CLE_ID=vParentLineId
AND MAJOR_VERSION=vVersion2
ORDER BY a.LINE_NUMBER
;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_current_line_1
FROM OKE_K_LINES_SECURE_HV
WHERE K_LINE_ID=c_sub_node
AND MAJOR_VERSION= vVersion1;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_current_line_1
FROM OKE_K_LINES_SECURE_V
WHERE K_LINE_ID=c_sub_node;
SELECT
major_version,
line_number,
status,
line_style,
project_number,
task_number,
start_date,
end_date,
delivery_date,
proposal_due_date,
item_number,
--item_description,
line_description,
customer_item_number,
nsn_number,
nsp_flag,
line_quantity,
uom_code,
unit_price,
undef_unit_price,
line_value,
undef_line_value,
line_value_total,
undef_line_value_total,
--line_value_copy,
billable_flag,
shippable_flag,
subcontracted_flag,
drop_shipped_flag,
completed_flag,
comments,
target_date_definitize,
discount_for_payment,
cost_of_sale_rate,
financial_ctrl_flag,
definitized_flag,
bill_undefinitized_flag,
dcaa_audit_req_flag,
cost_of_money,
interim_rpt_req_flag,
nte_warning_flag,
c_ssr_flag,
c_scs_flag,
prepayment_amount,
prepayment_percentage,
progress_payment_flag,
progress_payment_rate,
progress_payment_liq_rate,
line_liquidation_rate,
boe_description,
billing_method,
total_estimated_cost,
customer_percent_in_order,
ceiling_cost,
level_of_effort_hours,
award_fee,
base_fee,
minimum_fee,
maximum_fee,
award_fee_pool_amount,
fixed_fee,
initial_fee,
final_fee,
fee_ajt_formula,
target_cost,
target_fee,
target_price,
ceiling_price,
cost_overrun_share_ratio,
cost_underrun_share_ratio,
final_pft_ajt_formula,
fixed_quantity,
minimum_quantity,
maximum_quantity,
estimated_total_quantity,
number_of_options,
initial_price,
revised_price,
material_cost_index,
labor_cost_index,
date_of_price_redetermin,
country_of_origin_code,
export_flag,
export_license_num,
export_license_res,
cop_required_flag,
inspection_req_flag,
subj_a133_flag,
cfe_flag,
customer_approval_req_flag,
data_item_name,
data_item_subtitle,
cdrl_category,
requiring_office,
date_of_first_submission,
frequency,
copies_required
INTO r_current_line_2
FROM OKE_K_LINES_SECURE_HV
WHERE K_LINE_ID=c_sub_node
AND MAJOR_VERSION= vVersion2;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT count(*)
INTO nDeliverables
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=nCurrent_line_id
AND MAJOR_VERSION=vVersion1;
SELECT count(*)
INTO l_numOfSublines
FROM OKC_K_LINES_BH
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=nCurrent_line_id
AND MAJOR_VERSION=vVersion1;
SELECT count(*)
INTO nDeliverables
from oke_k_deliverables_b
where k_header_id=vHeader_id
and k_line_id=nCurrent_line_id;
SELECT count(*)
INTO l_numOfSublines
FROM OKC_K_LINES_B
WHERE DNZ_CHR_ID=vHeader_id
AND CLE_ID=nCurrent_line_id;
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_hv
where k_header_id=vHeader_id
and k_line_id is null
and major_version=vVersion_1;
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_v
where k_header_id=vHeader_id
and k_line_id is null;
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_hv
where k_header_id=vHeader_id
and k_line_id is null
and major_version=vVersion_2;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_hv
where k_header_id=vHeader_id
and k_line_id = vLine_id
and major_version=vVersion_1;
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_v
where k_header_id=vHeader_id
and k_line_id = vLine_id;
SELECT
major_version,
term_code,
term_value_pk1,
term_value_pk2,
term_name,
term_value
from oke_k_all_terms_hv
where k_header_id=vHeader_id
and k_line_id = vLine_id
and major_version=vVersion_2;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_hv
WHERE chr_id=vHeader_id
AND dnz_chr_id=vHeader_id
AND major_version=vVersion_1;
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_hv
WHERE chr_id=vHeader_id
AND dnz_chr_id=vHeader_id
AND major_version=vVersion_2;
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_v
WHERE chr_id=vHeader_id
AND dnz_chr_id=vHeader_id;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_hv
WHERE dnz_chr_id=vHeader_id
AND cle_id = vLine_id
AND major_version=vVersion_1;
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_hv
WHERE dnz_chr_id=vHeader_id
AND cle_id = vLine_id
AND major_version=vVersion_2;
SELECT
role,
cognomen,
alias,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_v
WHERE dnz_chr_id=vHeader_id
AND cle_id = vLine_id;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
SELECT deliverable_id
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
and major_version=vVersion2
ORDER BY deliverable_num;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
SELECT name
FROM OKE_SYSTEM_ITEMS_V
WHERE id1=v_item_id;
SELECT buy_or_sell
FROM OKE_K_HEADERS_V
WHERE k_header_id = v_header_id;
select name from hr_organization_units
where organization_id = p_id;
select name from okx_vendors_v
where id1 = p_id;
select name from okx_customer_accounts_v
where id1 = p_id;
select name from okx_vendors_v
where id1 = p_id;
select name from okx_organization_defs_v
where id1 = p_id;
select name from okx_customer_accounts_v
where id1 = p_id;
SELECT name
from OKX_LOCATIONS_V
where id1 = v_ship_to_location_id;
SELECT name
from OKE_CUST_SITE_USES_V
where id1 = v_ship_to_location_id
and site_use_code = 'SHIP_TO';
SELECT name
from okx_locations_v
where id1 = v_ship_from_location_id;
SELECT name
from OKE_CUST_SITE_USES_V
where id1 = v_ship_from_location_id
and site_use_code = 'SHIP_TO';
SELECT name
from OKE_VENDOR_SITES_V
where id1 = v_ship_from_location_id;
SELECT name
FROM pa_organizations_expend_v
WHERE organization_id=v_org_id;
SELECT deliverable_id
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
and major_version=vVersion1
ORDER BY deliverable_num;
SELECT deliverable_id
from oke_k_deliverables_b
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
ORDER BY deliverable_num;
SELECT deliverable_num
INTO current_deliverable_num
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
and major_version=vVersion1
and deliverable_id=current_deliverable_1;
SELECT deliverable_num
INTO current_deliverable_num
from oke_k_deliverables_b
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
and deliverable_id=current_deliverable_1;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT
deliverable_num,
item_id,
description,
project_number,
project_name,
task_number,
delivery_date,
status_code,
parent_deliverable_id,
direction,
ship_to_org_id,
ship_to_location_id,
ship_from_org_id,
ship_from_location_id,
start_date,
end_date,
need_by_date,
priority_code,
currency_code,
unit_price,
uom_code,
quantity,
country_of_origin_code,
subcontracted_flag,
dependency_flag,
billable_flag,
billing_event_id,
drop_shipped_flag,
completed_flag,
available_for_ship_flag,
create_demand,
ready_to_bill,
ready_to_procure,
mps_transaction_id,
shipping_request_id,
unit_number,
ndb_schedule_designator,
shippable_flag,
cfe_req_flag,
inspection_req_flag,
interim_rpt_req_flag,
lot_applies_flag,
customer_approval_req_flag,
date_of_first_submission,
frequency,
acq_doc_number,
submission_flag,
data_item_subtitle,
total_num_of_copies,
cdrl_category,
data_item_name,
export_flag,
export_license_num,
export_license_res,
comments,
sfwt_flag,
status,
volume,
volume_uom_code,
weight,
weight_uom_code,
expenditure_type,
expenditure_organization_id,
expenditure_item_date,
destination_type_code,
rate_type,
rate_date,
exchange_rate,
expected_shipment_date,
initiate_shipment_date,
promised_shipment_date
INTO r_deliverable_1
FROM oke_k_deliverables_vlh
WHERE deliverable_id=current_deliverable_1
AND major_version=vVersion1;
SELECT
deliverable_num,
item_id,
description,
project_number,
project_name,
task_number,
delivery_date,
status_code,
parent_deliverable_id,
direction,
ship_to_org_id,
ship_to_location_id,
ship_from_org_id,
ship_from_location_id,
start_date,
end_date,
need_by_date,
priority_code,
currency_code,
unit_price,
uom_code,
quantity,
country_of_origin_code,
subcontracted_flag,
dependency_flag,
billable_flag,
billing_event_id,
drop_shipped_flag,
completed_flag,
available_for_ship_flag,
create_demand,
ready_to_bill,
ready_to_procure,
mps_transaction_id,
shipping_request_id,
unit_number,
ndb_schedule_designator,
shippable_flag,
cfe_req_flag,
inspection_req_flag,
interim_rpt_req_flag,
lot_applies_flag,
customer_approval_req_flag,
date_of_first_submission,
frequency,
acq_doc_number,
submission_flag,
data_item_subtitle,
total_num_of_copies,
cdrl_category,
data_item_name,
export_flag,
export_license_num,
export_license_res,
comments,
sfwt_flag,
status,
volume,
volume_uom_code,
weight,
weight_uom_code,
expenditure_type,
expenditure_organization_id,
expenditure_item_date,
destination_type_code,
rate_type,
rate_date,
exchange_rate,
expected_shipment_date,
initiate_shipment_date,
promised_shipment_date
INTO r_deliverable_1
FROM oke_k_deliverables_vl
WHERE deliverable_id=current_deliverable_1
AND major_version=vVersion1;
SELECT
deliverable_num,
item_id,
description,
project_number,
project_name,
task_number,
delivery_date,
status_code,
parent_deliverable_id,
direction,
ship_to_org_id,
ship_to_location_id,
ship_from_org_id,
ship_from_location_id,
start_date,
end_date,
need_by_date,
priority_code,
currency_code,
unit_price,
uom_code,
quantity,
country_of_origin_code,
subcontracted_flag,
dependency_flag,
billable_flag,
billing_event_id,
drop_shipped_flag,
completed_flag,
available_for_ship_flag,
create_demand,
ready_to_bill,
ready_to_procure,
mps_transaction_id,
shipping_request_id,
unit_number,
ndb_schedule_designator,
shippable_flag,
cfe_req_flag,
inspection_req_flag,
interim_rpt_req_flag,
lot_applies_flag,
customer_approval_req_flag,
date_of_first_submission,
frequency,
acq_doc_number,
submission_flag,
data_item_subtitle,
total_num_of_copies,
cdrl_category,
data_item_name,
export_flag,
export_license_num,
export_license_res,
comments,
sfwt_flag,
status,
volume,
volume_uom_code,
weight,
weight_uom_code,
expenditure_type,
expenditure_organization_id,
expenditure_item_date,
destination_type_code,
rate_type,
rate_date,
exchange_rate,
expected_shipment_date,
initiate_shipment_date,
promised_shipment_date
INTO r_deliverable_2
FROM oke_k_deliverables_vlh
WHERE deliverable_id=current_deliverable_1
AND major_version=vVersion2;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT deliverable_num
INTO current_deliverable_num
from oke_k_deliverables_bh
where k_header_id=vHeader_id
and k_line_id=vCurrentLineId
and major_version=vVersion2
and deliverable_id=c_deliverable_2.deliverable_id;
insert_comp_result(vHeader_id,vVersion1,vVersion2);
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
--SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_hv h
WHERE dnz_chr_id=vHeader_id
AND cle_id is null
AND major_version=vVersion_1;
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
-- SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_hv h
WHERE dnz_chr_id=vHeader_id
AND cle_id is null
AND major_version=vVersion_2;
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
-- SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_b WHERE id=k.id) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_v k
WHERE dnz_chr_id=vHeader_id
AND cle_id is null;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
-- SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_hv h
WHERE dnz_chr_id=vHeader_id
AND cle_id =vLine_id
AND major_version=vVersion_1;
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
-- SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_hv h
WHERE dnz_chr_id=vHeader_id
AND cle_id = vLine_id
AND major_version=vVersion_2;
SELECT
CHR_ID,
CLE_ID,
CAT_ID,
CAT_TYPE,
SFWT_FLAG,
-- SAV_SAE_ID,
(SELECT sav_sae_id FROM okc_k_articles_b WHERE id=k.id) SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
COMMENTS,
NAME,
TEXT
FROM okc_k_articles_v k
WHERE dnz_chr_id=vHeader_id
AND cle_id =vLine_id;
SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
AND lookup_code = l_Object
AND view_application_id=777;
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
insert_comp_result(vHeader_id,vVersion_1,vVersion_2);