[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select id,
cle_id,
chr_id,
cle_id_for,
dnz_chr_id,
object1_id1,
object1_id2,
jtot_object1_code,
uom_code,
exception_yn,
number_of_items,
priced_item_yn
from okc_k_items_v
where id = p_cim_id;
select line_number into l_line_number
from oke_k_lines_v
where k_line_id=p_from_cle_id;
select code
from okc_statuses_v
where ste_code = 'ENTERED'
and default_yn = 'Y'
and sysdate between start_date and nvl(end_date,sysdate);
select dnz_chr_id,price_level_ind
from okc_k_lines_b
where id = p_to_cle_id;
select id
from okc_k_items
where cle_id = p_from_cle_id;
select *
from oke_k_user_attributes
where k_header_id = p_k_header_id
and k_line_id is null;
oke_k_user_attributes_pkg.insert_row
(x_rowid => l_row_id ,
x_k_user_attribute_id => l_k_user_attribute_id ,
x_record_version_number => l_record_version_number ,
x_creation_date => sysdate ,
x_created_by => fnd_global.user_id ,
x_last_update_date => sysdate ,
x_last_updated_by => fnd_global.user_id ,
x_last_update_login => fnd_global.login_id ,
x_k_header_id => p_k_header_id_new ,
x_k_line_id => l_user_att_rec.k_line_id ,
x_user_attribute_context => l_user_att_rec.user_attribute_context ,
x_user_attribute01 => l_user_att_rec.user_attribute01 ,
x_user_attribute02 => l_user_att_rec.user_attribute02 ,
x_user_attribute03 => l_user_att_rec.user_attribute03 ,
x_user_attribute04 => l_user_att_rec.user_attribute04 ,
x_user_attribute05 => l_user_att_rec.user_attribute05 ,
x_user_attribute06 => l_user_att_rec.user_attribute06 ,
x_user_attribute07 => l_user_att_rec.user_attribute07 ,
x_user_attribute08 => l_user_att_rec.user_attribute08 ,
x_user_attribute09 => l_user_att_rec.user_attribute09 ,
x_user_attribute10 => l_user_att_rec.user_attribute10 ,
x_user_attribute11 => l_user_att_rec.user_attribute11 ,
x_user_attribute12 => l_user_att_rec.user_attribute12 ,
x_user_attribute13 => l_user_att_rec.user_attribute13 ,
x_user_attribute14 => l_user_att_rec.user_attribute14 ,
x_user_attribute15 => l_user_att_rec.user_attribute15 ,
x_user_attribute16 => l_user_att_rec.user_attribute16 ,
x_user_attribute17 => l_user_att_rec.user_attribute17 ,
x_user_attribute18 => l_user_att_rec.user_attribute18 ,
x_user_attribute19 => l_user_att_rec.user_attribute19 ,
x_user_attribute20 => l_user_att_rec.user_attribute20 ,
x_user_attribute21 => l_user_att_rec.user_attribute21 ,
x_user_attribute22 => l_user_att_rec.user_attribute22 ,
x_user_attribute23 => l_user_att_rec.user_attribute23 ,
x_user_attribute24 => l_user_att_rec.user_attribute24 ,
x_user_attribute25 => l_user_att_rec.user_attribute25 ,
x_user_attribute26 => l_user_att_rec.user_attribute26 ,
x_user_attribute27 => l_user_att_rec.user_attribute27 ,
x_user_attribute28 => l_user_att_rec.user_attribute28 ,
x_user_attribute29 => l_user_att_rec.user_attribute29 ,
x_user_attribute30 => l_user_att_rec.user_attribute30
);
select *
from oke_k_user_attributes
where k_header_id = p_k_header_id
and k_line_id = p_k_line_id;
oke_k_user_attributes_pkg.insert_row
(x_rowid => l_row_id ,
x_k_user_attribute_id => l_k_user_attribute_id ,
x_record_version_number => l_record_version_number ,
x_creation_date => sysdate ,
x_created_by => fnd_global.user_id ,
x_last_update_date => sysdate ,
x_last_updated_by => fnd_global.user_id ,
x_last_update_login => fnd_global.login_id ,
x_k_header_id => p_k_header_id_new ,
x_k_line_id => p_k_line_id_new ,
x_user_attribute_context => l_user_att_rec.user_attribute_context ,
x_user_attribute01 => l_user_att_rec.user_attribute01 ,
x_user_attribute02 => l_user_att_rec.user_attribute02 ,
x_user_attribute03 => l_user_att_rec.user_attribute03 ,
x_user_attribute04 => l_user_att_rec.user_attribute04 ,
x_user_attribute05 => l_user_att_rec.user_attribute05 ,
x_user_attribute06 => l_user_att_rec.user_attribute06 ,
x_user_attribute07 => l_user_att_rec.user_attribute07 ,
x_user_attribute08 => l_user_att_rec.user_attribute08 ,
x_user_attribute09 => l_user_att_rec.user_attribute09 ,
x_user_attribute10 => l_user_att_rec.user_attribute10 ,
x_user_attribute11 => l_user_att_rec.user_attribute11 ,
x_user_attribute12 => l_user_att_rec.user_attribute12 ,
x_user_attribute13 => l_user_att_rec.user_attribute13 ,
x_user_attribute14 => l_user_att_rec.user_attribute14 ,
x_user_attribute15 => l_user_att_rec.user_attribute15 ,
x_user_attribute16 => l_user_att_rec.user_attribute16 ,
x_user_attribute17 => l_user_att_rec.user_attribute17 ,
x_user_attribute18 => l_user_att_rec.user_attribute18 ,
x_user_attribute19 => l_user_att_rec.user_attribute19 ,
x_user_attribute20 => l_user_att_rec.user_attribute20 ,
x_user_attribute21 => l_user_att_rec.user_attribute21 ,
x_user_attribute22 => l_user_att_rec.user_attribute22 ,
x_user_attribute23 => l_user_att_rec.user_attribute23 ,
x_user_attribute24 => l_user_att_rec.user_attribute24 ,
x_user_attribute25 => l_user_att_rec.user_attribute25 ,
x_user_attribute26 => l_user_att_rec.user_attribute26 ,
x_user_attribute27 => l_user_att_rec.user_attribute27 ,
x_user_attribute28 => l_user_att_rec.user_attribute28 ,
x_user_attribute29 => l_user_att_rec.user_attribute29 ,
x_user_attribute30 => l_user_att_rec.user_attribute30
);
select
k_header_id,
program_id,
project_id,
boa_id,
k_type_code,
priority_code,
prime_k_alias,
prime_k_number,
authorize_date,
authorizing_reason,
award_cancel_date,
award_date,
date_definitized,
date_issued,
date_negotiated,
date_received,
date_sign_by_contractor,
date_sign_by_customer,
faa_approve_date,
faa_reject_date,
booked_flag,
open_flag,
cfe_flag,
vat_code,
country_of_origin_code,
export_flag,
human_subject_flag,
cqa_flag,
interim_rpt_req_flag,
no_competition_authorize,
penalty_clause_flag,
product_line_code,
reporting_flag,
sb_plan_req_flag,
sb_report_flag,
nte_amount,
nte_warning_flag,
bill_without_def_flag,
cas_flag,
classified_flag,
client_approve_req_flag,
cost_of_money,
dcaa_audit_req_flag,
cost_share_flag,
oh_rates_final_flag,
prop_delivery_location,
prop_due_date_time,
prop_expire_date,
copies_required,
sic_code,
tech_data_wh_rate,
progress_payment_flag,
progress_payment_liq_rate,
progress_payment_rate,
alternate_liquidation_rate,
prop_due_time,
definitized_flag,
financial_ctrl_verified_flag,
cost_of_sale_rate,
created_by,
creation_date,
last_updated_by,
last_update_login,
last_update_date,
-- line_value_total,
-- undef_line_value_total,
-- end_date,
owning_organization_id,
default_task_id
from oke_k_headers
where k_header_id = p_k_header_id;
x_chr_rec.last_updated_by,
x_chr_rec.last_update_login,
x_chr_rec.last_update_date,
-- x_chr_rec.line_value_total,
-- x_chr_rec.undef_line_value_total,
-- x_chr_rec.end_date,
x_chr_rec.owning_organization_id,
x_chr_rec.default_task_id;
select
id,
object_version_number,
sfwt_flag,
chr_id_response,
chr_id_award,
-- chr_id_renewed,
inv_organization_id,
sts_code,
qcl_id,
scs_code,
contract_number,
currency_code,
contract_number_modifier,
archived_yn,
deleted_yn,
cust_po_number_req_yn,
pre_pay_req_yn,
cust_po_number,
short_description,
comments,
description,
dpas_rating,
cognomen,
template_yn,
template_used,
date_approved,
datetime_cancelled,
auto_renew_days,
date_issued,
datetime_responded,
non_response_reason,
non_response_explain,
rfp_type,
chr_type,
keep_on_mail_list,
set_aside_reason,
set_aside_percent,
response_copies_req,
date_close_projected,
datetime_proposed,
date_signed,
date_terminated,
date_renewed,
trn_code,
start_date,
end_date,
authoring_org_id,
buy_or_sell,
issue_or_receive,
estimated_amount,
-- chr_id_renewed_to,
estimated_amount_renewed,
currency_code_renewed,
upg_orig_system_ref,
upg_orig_system_ref_id,
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
from okc_k_headers_v
where okc_k_headers_v.id = p_k_header_id;
x_chrv_rec.deleted_yn,
x_chrv_rec.cust_po_number_req_yn,
x_chrv_rec.pre_pay_req_yn,
x_chrv_rec.cust_po_number,
x_chrv_rec.short_description,
x_chrv_rec.comments,
x_chrv_rec.description,
x_chrv_rec.dpas_rating,
x_chrv_rec.cognomen,
x_chrv_rec.template_yn,
x_chrv_rec.template_used,
x_chrv_rec.date_approved,
x_chrv_rec.datetime_cancelled,
x_chrv_rec.auto_renew_days,
x_chrv_rec.date_issued,
x_chrv_rec.datetime_responded,
x_chrv_rec.non_response_reason,
x_chrv_rec.non_response_explain,
x_chrv_rec.rfp_type,
x_chrv_rec.chr_type,
x_chrv_rec.keep_on_mail_list,
x_chrv_rec.set_aside_reason,
x_chrv_rec.set_aside_percent,
x_chrv_rec.response_copies_req,
x_chrv_rec.date_close_projected,
x_chrv_rec.datetime_proposed,
x_chrv_rec.date_signed,
x_chrv_rec.date_terminated,
x_chrv_rec.date_renewed,
x_chrv_rec.trn_code,
x_chrv_rec.start_date,
x_chrv_rec.end_date,
x_chrv_rec.authoring_org_id,
x_chrv_rec.buy_or_sell,
x_chrv_rec.issue_or_receive,
x_chrv_rec.estimated_amount,
-- x_chrv_rec.chr_id_renewed_to,
x_chrv_rec.estimated_amount_renewed,
x_chrv_rec.currency_code_renewed,
x_chrv_rec.upg_orig_system_ref,
x_chrv_rec.upg_orig_system_ref_id,
x_chrv_rec.attribute_category,
x_chrv_rec.attribute1,
x_chrv_rec.attribute2,
x_chrv_rec.attribute3,
x_chrv_rec.attribute4,
x_chrv_rec.attribute5,
x_chrv_rec.attribute6,
x_chrv_rec.attribute7,
x_chrv_rec.attribute8,
x_chrv_rec.attribute9,
x_chrv_rec.attribute10,
x_chrv_rec.attribute11,
x_chrv_rec.attribute12,
x_chrv_rec.attribute13,
x_chrv_rec.attribute14,
x_chrv_rec.attribute15,
x_chrv_rec.created_by,
x_chrv_rec.creation_date,
x_chrv_rec.last_updated_by,
x_chrv_rec.last_update_date,
x_chrv_rec.last_update_login;
select id,jtot_object1_code
from okc_k_party_roles_b
where okc_k_party_roles_b.dnz_chr_id = f_k_header_id
and okc_k_party_roles_b.chr_id is not null
and okc_k_party_roles_b.cle_id is null;
select id
from okc_k_party_roles_b
where okc_k_party_roles_b.cle_id = f_k_line_id
and okc_k_party_roles_b.dnz_chr_id = p_k_header_id
and okc_k_party_roles_b.chr_id is null;
SELECT ID
FROM OKC_K_ARTICLES_B
WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id
AND OKC_K_ARTICLES_B.CHR_ID is not null
AND OKC_K_ARTICLES_B.CLE_ID is null;
SELECT ID
FROM OKC_K_ARTICLES_B
WHERE OKC_K_ARTICLES_B.CLE_ID = f_k_line_id
AND OKC_K_ARTICLES_B.CHR_ID is null;
SELECT sav_sae_id
FROM okc_k_articles_b
WHERE id = p_cat_id;
SELECT sav_release
FROM okc_std_art_versions_v
WHERE sae_id = p_sae_id
AND date_active = (SELECT max(date_active)
FROM okc_std_art_versions_v
WHERE sae_id = p_sae_id);
SELECT 'x'
FROM okc_k_lines_v
WHERE CLE_ID = p_k_line_id;
SELECT
b.K_LINE_ID ,
b.PARENT_LINE_ID ,
b.PROJECT_ID ,
b.TASK_ID ,
b.BILLING_METHOD_CODE ,
b.INVENTORY_ITEM_ID ,
b.DELIVERY_ORDER_FLAG ,
b.SPLITED_FLAG ,
b.PRIORITY_CODE ,
b.CUSTOMER_ITEM_ID ,
b.CUSTOMER_ITEM_NUMBER ,
b.LINE_QUANTITY ,
b.DELIVERY_DATE ,
b.UNIT_PRICE ,
b.UOM_CODE ,
b.LINE_VALUE ,
-- b.LINE_VALUE_TOTAL ,
b.UNDEF_UNIT_PRICE ,
b.UNDEF_LINE_VALUE ,
-- b.UNDEF_LINE_VALUE_TOTAL ,
b.END_DATE ,
b.BILLABLE_FLAG ,
b.SHIPPABLE_FLAG ,
b.SUBCONTRACTED_FLAG ,
b.COMPLETED_FLAG ,
b.NSP_FLAG ,
b.APP_CODE ,
b.AS_OF_DATE ,
b.AUTHORITY ,
b.COUNTRY_OF_ORIGIN_CODE ,
b.DROP_SHIPPED_FLAG ,
b.CUSTOMER_APPROVAL_REQ_FLAG ,
b.DATE_MATERIAL_REQ ,
b.INSPECTION_REQ_FLAG ,
b.INTERIM_RPT_REQ_FLAG ,
b.SUBJ_A133_FLAG ,
b.EXPORT_FLAG ,
b.CFE_REQ_FLAG ,
b.COP_REQUIRED_FLAG ,
b.EXPORT_LICENSE_NUM ,
b.EXPORT_LICENSE_RES ,
b.COPIES_REQUIRED ,
b.CDRL_CATEGORY ,
b.DATA_ITEM_NAME ,
b.DATA_ITEM_SUBTITLE ,
b.DATE_OF_FIRST_SUBMISSION ,
b.FREQUENCY ,
b.REQUIRING_OFFICE ,
b.DCAA_AUDIT_REQ_FLAG ,
b.DEFINITIZED_FLAG ,
b.COST_OF_MONEY ,
b.BILL_UNDEFINITIZED_FLAG ,
b.NSN_NUMBER ,
b.NTE_WARNING_FLAG ,
b.DISCOUNT_FOR_PAYMENT ,
b.FINANCIAL_CTRL_FLAG ,
b.C_SCS_FLAG ,
b.C_SSR_FLAG ,
b.PREPAYMENT_AMOUNT ,
b.PREPAYMENT_PERCENTAGE ,
b.PROGRESS_PAYMENT_FLAG ,
b.PROGRESS_PAYMENT_LIQ_RATE ,
b.PROGRESS_PAYMENT_RATE ,
b.AWARD_FEE ,
b.AWARD_FEE_POOL_AMOUNT ,
b.BASE_FEE ,
b.CEILING_COST ,
b.CEILING_PRICE ,
b.COST_OVERRUN_SHARE_RATIO ,
b.COST_UNDERRUN_SHARE_RATIO ,
b.LABOR_COST_INDEX ,
b.MATERIAL_COST_INDEX ,
b.CUSTOMERS_PERCENT_IN_ORDER ,
b.DATE_OF_PRICE_REDETERMIN ,
b.ESTIMATED_TOTAL_QUANTITY ,
b.FEE_AJT_FORMULA ,
b.FINAL_FEE ,
b.FINAL_PFT_AJT_FORMULA ,
b.FIXED_FEE ,
b.FIXED_QUANTITY ,
b.INITIAL_FEE ,
b.INITIAL_PRICE ,
b.LEVEL_OF_EFFORT_HOURS ,
b.LINE_LIQUIDATION_RATE ,
b.MAXIMUM_FEE ,
b.MAXIMUM_QUANTITY ,
b.MINIMUM_FEE ,
b.MINIMUM_QUANTITY ,
b.NUMBER_OF_OPTIONS ,
b.REVISED_PRICE ,
b.TARGET_COST ,
b.TARGET_DATE_DEFINITIZE ,
b.TARGET_FEE ,
b.TARGET_PRICE ,
b.TOTAL_ESTIMATED_COST ,
b.PROPOSAL_DUE_DATE ,
b.COST_OF_SALE_RATE ,
b.CREATED_BY ,
b.CREATION_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.LAST_UPDATE_DATE ,
a.ID,
a.OBJECT_VERSION_NUMBER,
a.SFWT_FLAG,
a.CHR_ID,
a.CLE_ID,
a.LSE_ID,
a.LINE_NUMBER,
a.STS_CODE,
a.DISPLAY_SEQUENCE,
a.TRN_CODE,
a.DNZ_CHR_ID,
a.COMMENTS,
a.ITEM_DESCRIPTION,
a.HIDDEN_IND,
a.PRICE_UNIT,
a.PRICE_UNIT_PERCENT,
a.PRICE_NEGOTIATED,
a.PRICE_NEGOTIATED_RENEWED,
a.PRICE_LEVEL_IND,
a.INVOICE_LINE_LEVEL_IND,
a.DPAS_RATING,
a.BLOCK23TEXT,
a.EXCEPTION_YN,
a.TEMPLATE_USED,
a.DATE_TERMINATED,
a.NAME,
a.START_DATE,
a.END_DATE,
a.UPG_ORIG_SYSTEM_REF,
a.UPG_ORIG_SYSTEM_REF_ID,
a.ATTRIBUTE_CATEGORY,
a.ATTRIBUTE1,
a.ATTRIBUTE2,
a.ATTRIBUTE3,
a.ATTRIBUTE4,
a.ATTRIBUTE5,
a.ATTRIBUTE6,
a.ATTRIBUTE7,
a.ATTRIBUTE8,
a.ATTRIBUTE9,
a.ATTRIBUTE10,
a.ATTRIBUTE11,
a.ATTRIBUTE12,
a.ATTRIBUTE13,
a.ATTRIBUTE14,
a.ATTRIBUTE15,
a.CREATED_BY,
a.CREATION_DATE,
a.LAST_UPDATED_BY,
a.LAST_UPDATE_DATE,
a.PRICE_TYPE,
a.CURRENCY_CODE,
a.CURRENCY_CODE_RENEWED,
a.LAST_UPDATE_LOGIN
FROM okc_K_Lines_V a, oke_k_lines b
WHERE a.cle_id = f_k_line_id AND a.id=b.k_line_id;
l_cle_rec.LAST_UPDATED_BY ,
l_cle_rec.LAST_UPDATE_LOGIN ,
l_cle_rec.LAST_UPDATE_DATE ,
l_clev_rec.ID,
l_clev_rec.OBJECT_VERSION_NUMBER,
l_clev_rec.SFWT_FLAG,
l_clev_rec.CHR_ID,
l_clev_rec.CLE_ID,
l_clev_rec.LSE_ID,
l_clev_rec.LINE_NUMBER,
l_clev_rec.STS_CODE,
l_clev_rec.DISPLAY_SEQUENCE,
l_clev_rec.TRN_CODE,
l_clev_rec.DNZ_CHR_ID,
l_clev_rec.COMMENTS,
l_clev_rec.ITEM_DESCRIPTION,
l_clev_rec.HIDDEN_IND,
l_clev_rec.PRICE_UNIT,
l_clev_rec.PRICE_UNIT_PERCENT,
l_clev_rec.PRICE_NEGOTIATED,
l_clev_rec.PRICE_NEGOTIATED_RENEWED,
l_clev_rec.PRICE_LEVEL_IND,
l_clev_rec.INVOICE_LINE_LEVEL_IND,
l_clev_rec.DPAS_RATING,
l_clev_rec.BLOCK23TEXT,
l_clev_rec.EXCEPTION_YN,
l_clev_rec.TEMPLATE_USED,
l_clev_rec.DATE_TERMINATED,
l_clev_rec.NAME,
l_clev_rec.START_DATE,
l_clev_rec.END_DATE,
l_clev_rec.UPG_ORIG_SYSTEM_REF,
l_clev_rec.UPG_ORIG_SYSTEM_REF_ID,
l_clev_rec.ATTRIBUTE_CATEGORY,
l_clev_rec.ATTRIBUTE1,
l_clev_rec.ATTRIBUTE2,
l_clev_rec.ATTRIBUTE3,
l_clev_rec.ATTRIBUTE4,
l_clev_rec.ATTRIBUTE5,
l_clev_rec.ATTRIBUTE6,
l_clev_rec.ATTRIBUTE7,
l_clev_rec.ATTRIBUTE8,
l_clev_rec.ATTRIBUTE9,
l_clev_rec.ATTRIBUTE10,
l_clev_rec.ATTRIBUTE11,
l_clev_rec.ATTRIBUTE12,
l_clev_rec.ATTRIBUTE13,
l_clev_rec.ATTRIBUTE14,
l_clev_rec.ATTRIBUTE15,
l_clev_rec.CREATED_BY,
l_clev_rec.CREATION_DATE,
l_clev_rec.LAST_UPDATED_BY,
l_clev_rec.LAST_UPDATE_DATE,
l_clev_rec.PRICE_TYPE,
l_clev_rec.CURRENCY_CODE,
l_clev_rec.CURRENCY_CODE_RENEWED,
l_clev_rec.LAST_UPDATE_LOGIN;
SELECT
b.K_LINE_ID ,
b.PARENT_LINE_ID ,
b.PROJECT_ID ,
b.TASK_ID ,
b.BILLING_METHOD_CODE ,
b.INVENTORY_ITEM_ID ,
b.DELIVERY_ORDER_FLAG ,
b.SPLITED_FLAG ,
b.PRIORITY_CODE ,
b.CUSTOMER_ITEM_ID ,
b.CUSTOMER_ITEM_NUMBER ,
b.LINE_QUANTITY ,
b.DELIVERY_DATE ,
b.UNIT_PRICE ,
b.UOM_CODE ,
b.LINE_VALUE ,
-- b.LINE_VALUE_TOTAL ,
b.UNDEF_UNIT_PRICE ,
b.UNDEF_LINE_VALUE ,
-- b.UNDEF_LINE_VALUE_TOTAL ,
b.END_DATE ,
b.BILLABLE_FLAG ,
b.SHIPPABLE_FLAG ,
b.SUBCONTRACTED_FLAG ,
b.COMPLETED_FLAG ,
b.NSP_FLAG ,
b.APP_CODE ,
b.AS_OF_DATE ,
b.AUTHORITY ,
b.COUNTRY_OF_ORIGIN_CODE ,
b.DROP_SHIPPED_FLAG ,
b.CUSTOMER_APPROVAL_REQ_FLAG ,
b.DATE_MATERIAL_REQ ,
b.INSPECTION_REQ_FLAG ,
b.INTERIM_RPT_REQ_FLAG ,
b.SUBJ_A133_FLAG ,
b.EXPORT_FLAG ,
b.CFE_REQ_FLAG ,
b.COP_REQUIRED_FLAG ,
b.EXPORT_LICENSE_NUM ,
b.EXPORT_LICENSE_RES ,
b.COPIES_REQUIRED ,
b.CDRL_CATEGORY ,
b.DATA_ITEM_NAME ,
b.DATA_ITEM_SUBTITLE ,
b.DATE_OF_FIRST_SUBMISSION ,
b.FREQUENCY ,
b.REQUIRING_OFFICE ,
b.DCAA_AUDIT_REQ_FLAG ,
b.DEFINITIZED_FLAG ,
b.COST_OF_MONEY ,
b.BILL_UNDEFINITIZED_FLAG ,
b.NSN_NUMBER ,
b.NTE_WARNING_FLAG ,
b.DISCOUNT_FOR_PAYMENT ,
b.FINANCIAL_CTRL_FLAG ,
b.C_SCS_FLAG ,
b.C_SSR_FLAG ,
b.PREPAYMENT_AMOUNT ,
b.PREPAYMENT_PERCENTAGE ,
b.PROGRESS_PAYMENT_FLAG ,
b.PROGRESS_PAYMENT_LIQ_RATE ,
b.PROGRESS_PAYMENT_RATE ,
b.AWARD_FEE ,
b.AWARD_FEE_POOL_AMOUNT ,
b.BASE_FEE ,
b.CEILING_COST ,
b.CEILING_PRICE ,
b.COST_OVERRUN_SHARE_RATIO ,
b.COST_UNDERRUN_SHARE_RATIO ,
b.LABOR_COST_INDEX ,
b.MATERIAL_COST_INDEX ,
b.CUSTOMERS_PERCENT_IN_ORDER ,
b.DATE_OF_PRICE_REDETERMIN ,
b.ESTIMATED_TOTAL_QUANTITY ,
b.FEE_AJT_FORMULA ,
b.FINAL_FEE ,
b.FINAL_PFT_AJT_FORMULA ,
b.FIXED_FEE ,
b.FIXED_QUANTITY ,
b.INITIAL_FEE ,
b.INITIAL_PRICE ,
b.LEVEL_OF_EFFORT_HOURS ,
b.LINE_LIQUIDATION_RATE ,
b.MAXIMUM_FEE ,
b.MAXIMUM_QUANTITY ,
b.MINIMUM_FEE ,
b.MINIMUM_QUANTITY ,
b.NUMBER_OF_OPTIONS ,
b.REVISED_PRICE ,
b.TARGET_COST ,
b.TARGET_DATE_DEFINITIZE ,
b.TARGET_FEE ,
b.TARGET_PRICE ,
b.TOTAL_ESTIMATED_COST ,
b.PROPOSAL_DUE_DATE ,
b.COST_OF_SALE_RATE ,
b.CREATED_BY ,
b.CREATION_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.LAST_UPDATE_DATE ,
a.ID,
a.OBJECT_VERSION_NUMBER,
a.SFWT_FLAG,
a.CHR_ID,
a.CLE_ID,
a.LSE_ID,
a.LINE_NUMBER,
a.STS_CODE,
a.DISPLAY_SEQUENCE,
a.TRN_CODE,
a.DNZ_CHR_ID,
a.COMMENTS,
a.ITEM_DESCRIPTION,
a.HIDDEN_IND,
a.PRICE_UNIT,
a.PRICE_UNIT_PERCENT,
a.PRICE_NEGOTIATED,
a.PRICE_NEGOTIATED_RENEWED,
a.PRICE_LEVEL_IND,
a.INVOICE_LINE_LEVEL_IND,
a.DPAS_RATING,
a.BLOCK23TEXT,
a.EXCEPTION_YN,
a.TEMPLATE_USED,
a.DATE_TERMINATED,
a.NAME,
a.START_DATE,
a.END_DATE,
a.UPG_ORIG_SYSTEM_REF,
a.UPG_ORIG_SYSTEM_REF_ID,
a.ATTRIBUTE_CATEGORY,
a.ATTRIBUTE1,
a.ATTRIBUTE2,
a.ATTRIBUTE3,
a.ATTRIBUTE4,
a.ATTRIBUTE5,
a.ATTRIBUTE6,
a.ATTRIBUTE7,
a.ATTRIBUTE8,
a.ATTRIBUTE9,
a.ATTRIBUTE10,
a.ATTRIBUTE11,
a.ATTRIBUTE12,
a.ATTRIBUTE13,
a.ATTRIBUTE14,
a.ATTRIBUTE15,
a.CREATED_BY,
a.CREATION_DATE,
a.LAST_UPDATED_BY,
a.LAST_UPDATE_DATE,
a.PRICE_TYPE,
a.CURRENCY_CODE,
a.CURRENCY_CODE_RENEWED,
a.LAST_UPDATE_LOGIN
FROM okc_K_Lines_V a, oke_k_lines b
WHERE a.chr_id = f_k_header_id AND a.id=b.k_line_id;
l_cle_rec.LAST_UPDATED_BY ,
l_cle_rec.LAST_UPDATE_LOGIN ,
l_cle_rec.LAST_UPDATE_DATE ,
l_clev_rec.ID,
l_clev_rec.OBJECT_VERSION_NUMBER,
l_clev_rec.SFWT_FLAG,
l_clev_rec.CHR_ID,
l_clev_rec.CLE_ID,
l_clev_rec.LSE_ID,
l_clev_rec.LINE_NUMBER,
l_clev_rec.STS_CODE,
l_clev_rec.DISPLAY_SEQUENCE,
l_clev_rec.TRN_CODE,
l_clev_rec.DNZ_CHR_ID,
l_clev_rec.COMMENTS,
l_clev_rec.ITEM_DESCRIPTION,
l_clev_rec.HIDDEN_IND,
l_clev_rec.PRICE_UNIT,
l_clev_rec.PRICE_UNIT_PERCENT,
l_clev_rec.PRICE_NEGOTIATED,
l_clev_rec.PRICE_NEGOTIATED_RENEWED,
l_clev_rec.PRICE_LEVEL_IND,
l_clev_rec.INVOICE_LINE_LEVEL_IND,
l_clev_rec.DPAS_RATING,
l_clev_rec.BLOCK23TEXT,
l_clev_rec.EXCEPTION_YN,
l_clev_rec.TEMPLATE_USED,
l_clev_rec.DATE_TERMINATED,
l_clev_rec.NAME,
l_clev_rec.START_DATE,
l_clev_rec.END_DATE,
l_clev_rec.UPG_ORIG_SYSTEM_REF,
l_clev_rec.UPG_ORIG_SYSTEM_REF_ID,
l_clev_rec.ATTRIBUTE_CATEGORY,
l_clev_rec.ATTRIBUTE1,
l_clev_rec.ATTRIBUTE2,
l_clev_rec.ATTRIBUTE3,
l_clev_rec.ATTRIBUTE4,
l_clev_rec.ATTRIBUTE5,
l_clev_rec.ATTRIBUTE6,
l_clev_rec.ATTRIBUTE7,
l_clev_rec.ATTRIBUTE8,
l_clev_rec.ATTRIBUTE9,
l_clev_rec.ATTRIBUTE10,
l_clev_rec.ATTRIBUTE11,
l_clev_rec.ATTRIBUTE12,
l_clev_rec.ATTRIBUTE13,
l_clev_rec.ATTRIBUTE14,
l_clev_rec.ATTRIBUTE15,
l_clev_rec.CREATED_BY,
l_clev_rec.CREATION_DATE,
l_clev_rec.LAST_UPDATED_BY,
l_clev_rec.LAST_UPDATE_DATE,
l_clev_rec.PRICE_TYPE,
l_clev_rec.CURRENCY_CODE,
l_clev_rec.CURRENCY_CODE_RENEWED,
l_clev_rec.LAST_UPDATE_LOGIN;
SELECT id
FROM okc_k_lines_b
WHERE dnz_chr_id = p_chr_id
AND ( cle_id = p_cle_id AND p_cle_id IS NOT NULL
OR cle_id IS NULL AND p_cle_id IS NULL);
SELECT Nvl(line_value,0), Nvl(undef_line_value,0)
INTO l_amount, l_amount_u
FROM oke_k_lines
WHERE k_line_id = c.id;
UPDATE oke_k_lines
SET line_value_total = l_amount, undef_line_value_total = l_amount_u
WHERE k_line_id = c.id;
UPDATE oke_k_headers
SET line_value_total=l_total, undef_line_value_total=l_total_u
WHERE k_header_id = p_chr_id;
SELECT 'x'
FROM okc_k_headers_all_b a, okc_k_headers_all_b b
WHERE a.inv_organization_id=b.inv_organization_id
AND a.id = h1 AND b.id=h2;
select distinct role_id,person_id,
decode(sign(trunc(start_date_active)-trunc(sysdate)),1,trunc(start_date_active),trunc(sysdate)),
trunc(end_date_active)
from oke_k_access_v
where object_id=p_source_k_header_id
and (end_date_active is null OR trunc(end_date_active)> trunc(sysdate));
select pdf_id,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
from OKC_K_PROCESSES
where chr_id=p_source_k_header_id;
select type_class_code
from oke_k_headers chr,
OKE_K_TYPES_b ktype
where chr.k_type_code = ktype.k_type_code
and chr.k_header_id = p_source_k_header_id;
select type_class_code
from OKE_K_TYPES_b
where k_type_code = p_dest_doc_type;
insert into oke_k_billing_methods
(k_header_id,
billing_method_code,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
default_flag,
attribute_category,
attribute1,attribute2,
attribute3,attribute4,
attribute5,attribute6,
attribute7,attribute8,
attribute9,attribute10,
attribute11,attribute12,
attribute13,attribute14,
attribute15
)
select x_chr_rec.k_header_id,billing_method_code,sysdate,
fnd_global.user_id,sysdate,fnd_global.user_id,
fnd_global.login_id,
default_flag,attribute_category,attribute1,attribute2,
attribute3,attribute4,attribute5,attribute6,attribute7,
attribute8,attribute9,attribute10,attribute11,attribute12,
attribute13,attribute14,attribute15
from oke_k_billing_methods
where k_header_id = p_source_k_header_id;