The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select 0 depth ,
qte_lines.line_number line_num ,
qte_lines.quote_line_id quote_line_id ,
items.concatenated_segments inventory_item ,
-- items.segment1 inventory_item ,
items.description description,
qte_lines.uom_code uom_code ,
qte_lines.quantity quantity ,
(qte_lines.line_list_price * qte_lines.quantity) amount ,
(qte_lines.line_adjusted_amount * qte_lines.quantity) line_adjusted_amount
From ASO_QUOTE_LINES_ALL qte_lines ,
ASO_I_ITEMS_V items
Where qte_lines.quote_header_id = p_quote_header_id
AND qte_lines.inventory_item_id = items.inventory_item_id
AND qte_lines.organization_id = items.organization_id
ORDER BY line_num ; **/
Select 0 depth ,
qte_lines.line_number line_num ,
qte_lines.quote_line_id quote_line_id ,
items.inventory_item_id inventory_item_id ,
items.organization_id organization_id ,
items.concatenated_segments inventory_item ,
-- items.segment1 inventory_item ,
msit.description description,
qte_lines.uom_code uom_code ,
qte_lines.quantity quantity ,
(qte_lines.line_list_price * qte_lines.quantity) amount ,
(qte_lines.line_adjusted_amount * qte_lines.quantity) line_adjusted_amount
From ASO_QUOTE_LINES_ALL qte_lines ,
MTL_SYSTEM_ITEMS_B_KFV items,
MTL_SYSTEM_ITEMS_TL msit
Where qte_lines.quote_header_id = p_quote_header_id
AND qte_lines.inventory_item_id = items.inventory_item_id
AND qte_lines.organization_id = items.organization_id
AND items.inventory_item_id = msit.inventory_item_id
AND items.organization_id = msit.organization_id
AND msit.language = userenv('LANG')
ORDER BY line_num;
Select MAX(Revision)
From mtl_item_revisions
Where inventory_item_id = p_inventory_item_id
and organization_id = p_organization_id
and trunc(sysdate) >= trunc(effectivity_date);
(SELECT rel.quote_line_id ,
rel.related_quote_line_id
FROM ASO_LINE_RELATIONSHIPS rel,
ASO_QUOTE_LINES_ALL qte_line
WHERE qte_line.quote_header_id = p_quote_header_id
AND qte_line.quote_line_id = rel.quote_line_id );