The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT (1)
INTO l_found
FROM okc_price_adjustments
WHERE chr_id = p_chr_id;
l_in_tbl (1).update_allowed :=
p_modifier_details (i).override_flag;
l_in_tbl (1).updated_flag := p_modifier_details (i).updated_flag;
SELECT *
FROM okc_price_adjustments
WHERE cle_id = p_cle_id AND
list_line_id = p_list_line_id;
SELECT *
FROM okc_price_adjustments
WHERE cle_id = p_cle_id;
SELECT cle_id,
dnz_chr_id
FROM okc_k_lines_b
WHERE ID = cp_subline_id;
SELECT 1
FROM okc_price_adjustments
WHERE cle_id = cp_topline_id AND
list_line_id = p_list_line_id;
SELECT 1
FROM okc_price_adjustments
WHERE chr_id = cp_hdr_id AND
cle_id IS NULL AND
list_line_id = p_list_line_id;
UPDATE okc_price_adjustments
SET adjusted_amount =
p_modifier_details (i).adjustment_amount,
arithmetic_operator =
p_modifier_details (i).operand_calculation_code,
operand = p_modifier_details (i).operand_value,
update_allowed = p_modifier_details (i).override_flag
WHERE cle_id = p_cle_id AND
list_line_id =
p_modifier_details (i).list_line_id;
l_in_tbl (1).update_allowed :=
p_modifier_details (i).override_flag;
l_in_tbl (1).updated_flag :=
p_modifier_details (i).updated_flag;
DELETE FROM okc_price_adjustments
WHERE cle_id = p_cle_id AND
list_line_id = cur.list_line_id;
SELECT qualifier_context,
qualifier_attribute,
qualifier_attr_value,
comparison_operator_code
FROM oks_qualifiers
WHERE list_line_id = p_cle_id;
SELECT list_header_id,
list_line_id,
list_line_type_code,
modifier_mechanism_type_code,
automatic_flag,
arithmetic_operator,
operand
FROM okc_price_adjustments
WHERE chr_id = p_chr_id AND
cle_id IS NULL AND
NVL (automatic_flag, 'N') = 'N';
SELECT list_type_code
FROM qp_list_headers_vl
WHERE list_header_id = p_list_header_id;
SELECT list_line_no,
list_line_type_code,
modifier_level_code,
pricing_phase_id,
pricing_group_sequence,
automatic_flag,
override_flag,
arithmetic_operator,
charge_type_code,
charge_subtype_code,
include_on_returns_flag
FROM qp_list_lines
WHERE list_line_id = p_list_line_id;
l_req_line_detail_rec2.updated_flag := 'Y';
'312:************ p_req_line_detail_tbl(1).updated_flag **** ' ||
p_req_line_detail_tbl (1).updated_flag
);
SELECT list_header_id,
list_line_id,
list_line_type_code,
modifier_mechanism_type_code,
automatic_flag,
arithmetic_operator,
operand
FROM okc_price_adjustments
WHERE cle_id = p_cle_id AND
NVL (automatic_flag, 'N') = 'N';
SELECT list_type_code
FROM qp_list_headers_vl
WHERE list_header_id = p_list_header_id;
SELECT list_line_no,
list_line_type_code,
modifier_level_code,
pricing_phase_id,
pricing_group_sequence,
automatic_flag,
override_flag,
arithmetic_operator,
charge_type_code,
charge_subtype_code,
include_on_returns_flag
FROM qp_list_lines
WHERE list_line_id = p_list_line_id;
l_req_line_detail_rec2.updated_flag := 'Y';
SELECT inventory_item_id
INTO l_id
FROM csi_item_instances
WHERE instance_id = p_id;
SELECT pricing_context,
pricing_attribute1,
pricing_attribute2,
pricing_attribute3,
pricing_attribute4,
pricing_attribute5,
pricing_attribute6,
pricing_attribute7,
pricing_attribute8,
pricing_attribute9,
pricing_attribute10,
pricing_attribute11,
pricing_attribute12,
pricing_attribute13,
pricing_attribute14,
pricing_attribute15,
pricing_attribute16,
pricing_attribute17,
pricing_attribute18,
pricing_attribute19,
pricing_attribute20,
pricing_attribute21,
pricing_attribute22,
pricing_attribute23,
pricing_attribute24,
pricing_attribute25,
pricing_attribute26,
pricing_attribute27,
pricing_attribute28,
pricing_attribute29,
pricing_attribute30,
pricing_attribute31,
pricing_attribute32,
pricing_attribute33,
pricing_attribute34,
pricing_attribute35,
pricing_attribute36,
pricing_attribute37,
pricing_attribute38,
pricing_attribute39,
pricing_attribute40,
pricing_attribute41,
pricing_attribute42,
pricing_attribute43,
pricing_attribute44,
pricing_attribute45,
pricing_attribute46,
pricing_attribute47,
pricing_attribute48,
pricing_attribute49,
pricing_attribute50,
pricing_attribute51,
pricing_attribute52,
pricing_attribute53,
pricing_attribute54,
pricing_attribute55,
pricing_attribute56,
pricing_attribute57,
pricing_attribute58,
pricing_attribute59,
pricing_attribute60,
pricing_attribute61,
pricing_attribute62,
pricing_attribute63,
pricing_attribute64,
pricing_attribute65,
pricing_attribute66,
pricing_attribute67,
pricing_attribute68,
pricing_attribute69,
pricing_attribute70,
pricing_attribute71,
pricing_attribute72,
pricing_attribute73,
pricing_attribute74,
pricing_attribute75,
pricing_attribute76,
pricing_attribute77,
pricing_attribute78,
pricing_attribute79,
pricing_attribute80,
pricing_attribute81,
pricing_attribute82,
pricing_attribute83,
pricing_attribute84,
pricing_attribute85,
pricing_attribute86,
pricing_attribute87,
pricing_attribute88,
pricing_attribute89,
pricing_attribute90,
pricing_attribute91,
pricing_attribute92,
pricing_attribute93,
pricing_attribute94,
pricing_attribute95,
pricing_attribute96,
pricing_attribute97,
pricing_attribute98,
pricing_attribute99,
pricing_attribute100
FROM csi_i_pricing_attribs a
WHERE a.instance_id = p_inst_id;
SELECT pricing_context,
TRIM(pricing_attribute1) pricing_attribute1,
TRIM(pricing_attribute2) pricing_attribute2,
TRIM(pricing_attribute3) pricing_attribute3,
TRIM(pricing_attribute4) pricing_attribute4,
TRIM(pricing_attribute5) pricing_attribute5,
TRIM(pricing_attribute6) pricing_attribute6,
TRIM(pricing_attribute7) pricing_attribute7,
TRIM(pricing_attribute8) pricing_attribute8,
TRIM(pricing_attribute9) pricing_attribute9,
TRIM(pricing_attribute10) pricing_attribute10,
TRIM(pricing_attribute11) pricing_attribute11,
TRIM(pricing_attribute12) pricing_attribute12,
TRIM(pricing_attribute13) pricing_attribute13,
TRIM(pricing_attribute14) pricing_attribute14,
TRIM(pricing_attribute15) pricing_attribute15,
TRIM(pricing_attribute16) pricing_attribute16,
TRIM(pricing_attribute17) pricing_attribute17,
TRIM(pricing_attribute18) pricing_attribute18,
TRIM(pricing_attribute19) pricing_attribute19,
TRIM(pricing_attribute20) pricing_attribute20,
TRIM(pricing_attribute21) pricing_attribute21,
TRIM(pricing_attribute22) pricing_attribute22,
TRIM(pricing_attribute23) pricing_attribute23,
TRIM(pricing_attribute24) pricing_attribute24,
TRIM(pricing_attribute25) pricing_attribute25,
TRIM(pricing_attribute26) pricing_attribute26,
TRIM(pricing_attribute27) pricing_attribute27,
TRIM(pricing_attribute28) pricing_attribute28,
TRIM(pricing_attribute29) pricing_attribute29,
TRIM(pricing_attribute30) pricing_attribute30,
TRIM(pricing_attribute31) pricing_attribute31,
TRIM(pricing_attribute32) pricing_attribute32,
TRIM(pricing_attribute33) pricing_attribute33,
TRIM(pricing_attribute34) pricing_attribute34,
TRIM(pricing_attribute35) pricing_attribute35,
TRIM(pricing_attribute36) pricing_attribute36,
TRIM(pricing_attribute37) pricing_attribute37,
TRIM(pricing_attribute38) pricing_attribute38,
TRIM(pricing_attribute39) pricing_attribute39,
TRIM(pricing_attribute40) pricing_attribute40,
TRIM(pricing_attribute41) pricing_attribute41,
TRIM(pricing_attribute42) pricing_attribute42,
TRIM(pricing_attribute43) pricing_attribute43,
TRIM(pricing_attribute44) pricing_attribute44,
TRIM(pricing_attribute45) pricing_attribute45,
TRIM(pricing_attribute46) pricing_attribute46,
TRIM(pricing_attribute47) pricing_attribute47,
TRIM(pricing_attribute48) pricing_attribute48,
TRIM(pricing_attribute49) pricing_attribute49,
TRIM(pricing_attribute50) pricing_attribute50,
TRIM(pricing_attribute51) pricing_attribute51,
TRIM(pricing_attribute52) pricing_attribute52,
TRIM(pricing_attribute53) pricing_attribute53,
TRIM(pricing_attribute54) pricing_attribute54,
TRIM(pricing_attribute55) pricing_attribute55,
TRIM(pricing_attribute56) pricing_attribute56,
TRIM(pricing_attribute57) pricing_attribute57,
TRIM(pricing_attribute58) pricing_attribute58,
TRIM(pricing_attribute59) pricing_attribute59,
TRIM(pricing_attribute60) pricing_attribute60,
TRIM(pricing_attribute61) pricing_attribute61,
TRIM(pricing_attribute62) pricing_attribute62,
TRIM(pricing_attribute63) pricing_attribute63,
TRIM(pricing_attribute64) pricing_attribute64,
TRIM(pricing_attribute65) pricing_attribute65,
TRIM(pricing_attribute66) pricing_attribute66,
TRIM(pricing_attribute67) pricing_attribute67,
TRIM(pricing_attribute68) pricing_attribute68,
TRIM(pricing_attribute69) pricing_attribute69,
TRIM(pricing_attribute70) pricing_attribute70,
TRIM(pricing_attribute71) pricing_attribute71,
TRIM(pricing_attribute72) pricing_attribute72,
TRIM(pricing_attribute73) pricing_attribute73,
TRIM(pricing_attribute74) pricing_attribute74,
TRIM(pricing_attribute75) pricing_attribute75,
TRIM(pricing_attribute76) pricing_attribute76,
TRIM(pricing_attribute77) pricing_attribute77,
TRIM(pricing_attribute78) pricing_attribute78,
TRIM(pricing_attribute79) pricing_attribute79,
TRIM(pricing_attribute80) pricing_attribute80,
TRIM(pricing_attribute81) pricing_attribute81,
TRIM(pricing_attribute82) pricing_attribute82,
TRIM(pricing_attribute83) pricing_attribute83,
TRIM(pricing_attribute84) pricing_attribute84,
TRIM(pricing_attribute85) pricing_attribute85,
TRIM(pricing_attribute86) pricing_attribute86,
TRIM(pricing_attribute87) pricing_attribute87,
TRIM(pricing_attribute88) pricing_attribute88,
TRIM(pricing_attribute89) pricing_attribute89,
TRIM(pricing_attribute90) pricing_attribute90,
TRIM(pricing_attribute91) pricing_attribute91,
TRIM(pricing_attribute92) pricing_attribute92,
TRIM(pricing_attribute93) pricing_attribute93,
TRIM(pricing_attribute94) pricing_attribute94,
TRIM(pricing_attribute95) pricing_attribute95,
TRIM(pricing_attribute96) pricing_attribute96,
TRIM(pricing_attribute97) pricing_attribute97,
TRIM(pricing_attribute98) pricing_attribute98,
TRIM(pricing_attribute99) pricing_attribute99,
TRIM(pricing_attribute100) pricing_attribute100
FROM okc_price_att_values_v a
WHERE a.cle_id = p_cle_id;
SELECT DISTINCT primary_uom_code
INTO l_ret_value
FROM mtl_system_items
WHERE inventory_item_id = p_id AND
organization_id = p_inv_org;
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
kh.price_list_id price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id
FROM okc_k_headers_all_b kh
WHERE kh.ID = p_detail_rec.chr_id;
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.conversion_type kh_conversion_type, -- new
kh.conversion_rate kh_conversion_rate, -- new
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
NVL (kl.price_list_id, kh.price_list_id) price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id,
kl.ID tl_id,
kl.start_date tl_start_date,
kl.end_date tl_end_date,
kl.lse_id tl_line_style,
kl.bill_to_site_use_id tl_bill_to,
kl.ship_to_site_use_id tl_ship_to,
kl.payment_term_id tl_payment_term_id,
ki.object1_id1 tl_object_id,
ki.number_of_items tl_qty,
ki.uom_code tl_uom_code
FROM okc_k_headers_all_b kh,
okc_k_lines_b kl,
okc_k_items ki
WHERE kh.ID = kl.chr_id AND
kl.ID = p_detail_rec.line_id AND
ki.cle_id = kl.ID;
SELECT kl.ID sl_id,
kl.start_date sl_start_date,
kl.end_date sl_end_date,
kl.lse_id sl_line_style,
ki.object1_id1 sl_object_id,
ki.number_of_items sl_qty,
ki.uom_code sl_uom_code,
ks.price_uom sl_price_uom
FROM okc_k_lines_b kl,
okc_k_items ki,
oks_k_lines_b ks
WHERE kl.ID = p_detail_rec.subline_id AND
ks.cle_id = kl.ID AND
ki.cle_id = kl.ID;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
Select object1_id1 Into l_cust_id
From OKC_RULE_GROUPS_B rgp,
OKC_RULES_B rl
Where rgp.dnz_chr_id = p_chr_id and
rgp.cle_id = p_cle_id and
rgp.id = rl.rgp_id and
rl.rule_information_category = 'CAN';
SELECT cust_acct_id
INTO l_cust_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
SELECT cust_account_id
INTO l_cust_id
FROM hz_cust_site_uses_all cs,
hz_cust_acct_sites_all ca
WHERE site_use_id = p_site_use_id AND
ca.cust_acct_site_id = cs.cust_acct_site_id;
SELECT isa_agreement_id
INTO l_id
FROM okc_governances
WHERE chr_id = p_chr_id;
SELECT object1_id1
INTO l_id
FROM okc_k_party_roles_b
WHERE chr_id = p_chr_id AND
dnz_chr_id = p_chr_id AND
cle_id IS NULL AND
rle_code IN ('CUSTOMER', 'SUBSCRIBER');
SELECT party_id
INTO l_party_id
FROM hz_cust_accounts_all
WHERE cust_account_id = l_customer_id;
l_control_rec.temp_table_insert_flag := 'Y';
l_req_line_rec.updated_adjusted_unit_price :=
p_detail_rec.asking_unit_price;
l_req_line_rec.updated_adjusted_unit_price
);
l_req_line_rec.updated_adjusted_unit_price
);
l_req_line_rec2.updated_adjusted_unit_price :=
p_detail_rec.asking_unit_price;
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_control_rec.TEMP_TABLE_INSERT_FLAG : '|| l_control_rec.TEMP_TABLE_INSERT_FLAG
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_req_line_tbl('|| p ||').UPDATED_ADJUSTED_UNIT_PRICE : '|| l_req_line_tbl(p).UPDATED_ADJUSTED_UNIT_PRICE
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_req_line_detail_tbl('|| p ||').UPDATED_FLAG : '|| l_req_line_detail_tbl(p).UPDATED_FLAG
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: lx_req_line_tbl('|| p ||').UPDATED_ADJUSTED_UNIT_PRICE : '|| lx_req_line_tbl(p).UPDATED_ADJUSTED_UNIT_PRICE
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: lx_req_line_detail_tbl('|| p ||').UPDATED_FLAG : '|| lx_req_line_detail_tbl(p).UPDATED_FLAG
);
'20016:LIST/DISCOUNT Update Flag: ' ||
lx_req_line_detail_tbl (i).modifier_level_code
);
(qp_preq_grp.g_status_updated,
qp_preq_grp.g_status_system_generated,
qp_preq_grp.g_by_engine,
qp_preq_grp.g_status_unchanged,
qp_preq_grp.g_status_new
)
THEN
x_price_details.status_code := 'OKS_S';
l_price_break_tbl.DELETE (l_top_ctr);
l_price_break_tbl.DELETE (l_top_ctr);
PROCEDURE delete_locked_pricebreaks (
p_api_version IN NUMBER,
p_list_line_id IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status IN OUT NOCOPY VARCHAR2,
x_msg_count IN OUT NOCOPY NUMBER,
x_msg_data IN OUT NOCOPY VARCHAR2
)
IS
gpr_return_status VARCHAR2 (1) := NULL;
:= 'Delete_locked_pricebreaks';
is to be updated, the operation and the columns to be updated with the
new values. All other values are not required to be populated.*/
k := 1;
gpr_price_list_line_tbl (k).operation := qp_globals.g_opr_delete;
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
kh.price_list_id price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id
FROM okc_k_headers_all_b kh
WHERE kh.ID = p_detail_rec.chr_id;
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.conversion_type kh_conversion_type, -- new
kh.conversion_rate kh_conversion_rate, -- new
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
NVL (kl.price_list_id, kh.price_list_id) price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id,
kl.ID tl_id,
kl.start_date tl_start_date,
kl.end_date tl_end_date,
kl.lse_id tl_line_style,
kl.bill_to_site_use_id tl_bill_to,
kl.ship_to_site_use_id tl_ship_to,
kl.payment_term_id tl_payment_term_id,
ki.object1_id1 tl_object_id,
ki.number_of_items tl_qty,
ki.uom_code tl_uom_code
FROM okc_k_headers_all_b kh,
okc_k_lines_b kl,
okc_k_items ki
WHERE kh.ID = kl.chr_id AND
kl.ID = p_detail_rec.line_id AND
ki.cle_id = kl.ID;
SELECT kl.ID sl_id,
kl.start_date sl_start_date,
kl.end_date sl_end_date,
kl.lse_id sl_line_style,
ki.object1_id1 sl_object_id,
ki.number_of_items sl_qty,
ki.uom_code sl_uom_code,
ks.price_uom sl_price_uom
FROM okc_k_lines_b kl,
okc_k_items ki,
oks_k_lines_b ks
WHERE kl.ID = p_detail_rec.subline_id AND
ks.cle_id = kl.ID AND
ki.cle_id = kl.ID;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
Select object1_id1 Into l_cust_id
From OKC_RULE_GROUPS_B rgp,
OKC_RULES_B rl
Where rgp.dnz_chr_id = p_chr_id and
rgp.cle_id = p_cle_id and
rgp.id = rl.rgp_id and
rl.rule_information_category = 'CAN';
SELECT cust_acct_id
INTO l_cust_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
SELECT cust_account_id
INTO l_cust_id
FROM hz_cust_site_uses_all cs,
hz_cust_acct_sites_all ca
WHERE site_use_id = p_site_use_id AND
ca.cust_acct_site_id = cs.cust_acct_site_id;
SELECT isa_agreement_id
INTO l_id
FROM okc_governances
WHERE chr_id = p_chr_id;
SELECT object1_id1
INTO l_id
FROM okc_k_party_roles_b
WHERE chr_id = p_chr_id AND
dnz_chr_id = p_chr_id AND
cle_id IS NULL AND
rle_code IN ('CUSTOMER', 'SUBSCRIBER');
SELECT party_id
INTO l_party_id
FROM hz_cust_accounts_all
WHERE cust_account_id = l_customer_id;
l_control_rec.temp_table_insert_flag := 'Y';
l_req_line_rec.updated_adjusted_unit_price :=
p_detail_rec.asking_unit_price;
l_req_line_rec.updated_adjusted_unit_price
);
l_req_line_rec.updated_adjusted_unit_price
);
l_req_line_rec2.updated_adjusted_unit_price :=
p_detail_rec.asking_unit_price;
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_control_rec.TEMP_TABLE_INSERT_FLAG : '|| l_control_rec.TEMP_TABLE_INSERT_FLAG
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_req_line_tbl('|| p ||').UPDATED_ADJUSTED_UNIT_PRICE : '|| l_req_line_tbl(p).UPDATED_ADJUSTED_UNIT_PRICE
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: l_req_line_detail_tbl('|| p ||').UPDATED_FLAG : '|| l_req_line_detail_tbl(p).UPDATED_FLAG
);
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
kh.price_list_id price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id
FROM okc_k_headers_all_b kh
WHERE kh.ID = p_detail_rec.chr_id;
SELECT kh.ID kh_id,
kh.start_date kh_start_date,
kh.date_signed kh_signed_date,
kh.currency_code kh_currency_code,
kh.conversion_type kh_conversion_type, -- new
kh.conversion_rate kh_conversion_rate, -- new
kh.authoring_org_id kh_auth_org,
kh.inv_organization_id inv_org,
NVL (kl.price_list_id, kh.price_list_id) price_list_id,
kh.bill_to_site_use_id kh_bill_to,
kh.ship_to_site_use_id kh_ship_to,
kh.payment_term_id kh_payment_term_id,
kl.ID tl_id,
kl.start_date tl_start_date,
kl.end_date tl_end_date,
kl.lse_id tl_line_style,
kl.bill_to_site_use_id tl_bill_to,
kl.ship_to_site_use_id tl_ship_to,
kl.payment_term_id tl_payment_term_id,
ki.object1_id1 tl_object_id,
ki.number_of_items tl_qty,
ki.uom_code tl_uom_code
FROM okc_k_headers_all_b kh,
okc_k_lines_b kl,
okc_k_items ki
WHERE kh.ID = kl.chr_id AND
kl.ID = p_detail_rec.line_id AND
ki.cle_id = kl.ID;
SELECT kl.ID sl_id,
kl.start_date sl_start_date,
kl.end_date sl_end_date,
kl.lse_id sl_line_style,
ki.object1_id1 sl_object_id,
ki.number_of_items sl_qty,
ki.uom_code sl_uom_code,
ks.price_uom sl_price_uom
FROM okc_k_lines_b kl,
okc_k_items ki,
oks_k_lines_b ks
WHERE kl.ID = p_detail_rec.subline_id AND
ks.cle_id = kl.ID AND
ki.cle_id = kl.ID;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_cle_id;
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: lx_req_line_tbl('|| p ||').UPDATED_ADJUSTED_UNIT_PRICE : '|| lx_req_line_tbl(p).UPDATED_ADJUSTED_UNIT_PRICE
);
fnd_log.STRING (fnd_log.level_statement, g_module || l_api_name,'QP_CALL: lx_req_line_detail_tbl('|| p ||').UPDATED_FLAG : '|| lx_req_line_detail_tbl(p).UPDATED_FLAG
);
'20016:LIST/DISCOUNT Update Flag: ' ||
lx_req_line_detail_tbl (i).modifier_level_code
);
(qp_preq_grp.g_status_updated,
qp_preq_grp.g_status_system_generated,
qp_preq_grp.g_by_engine,
qp_preq_grp.g_status_unchanged,
qp_preq_grp.g_status_new
)
THEN
x_price_details.status_code := 'OKS_S';
l_price_break_tbl.DELETE (l_top_ctr);
l_price_break_tbl.DELETE (l_top_ctr);