The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(bill_sequence_id) INTO l_first_level_count
FROM bom_inventory_components
WHERE bill_sequence_id = p_cbill_sequence_id
AND implementation_date is NOT NULL;
SELECT count(distinct change_id) INTO l_change_order_count
FROM ENG_REVISED_ITEMS
WHERE bill_sequence_id = p_bill_sequence_id;
SELECT count(*) into l_component_count
FROM
BOM_INVENTORY_COMPONENTS bomc
WHERE
implementation_date is NOT NULL
AND bomc.bill_sequence_id IN -- For Bug Fix . 2832017
(SELECT common_bill_sequence_id
FROM
BOM_BILL_OF_MATERIALS bom
WHERE
bom.assembly_item_id = p_component_item_id
AND bom.organization_id = p_organization_id
-- Commented for Bug Fix 2832017
-- AND bom.alternate_bom_designator = p_alternate_bom_designator
);
SELECT count(*) into l_component_count
FROM bom_explosions_V
WHERE assembly_item_id = p_component_item_id
and top_bill_sequence_id = p_top_bill_sequence_id
--AND bill_sequence_id = p_bill_sequence_id
AND plan_level = p_plan_level + 1;
SELECT effective_date INTO l_effective_date
FROM bom_structure_types_b
WHERE structure_type_id = p_structure_type_id;
SELECT disable_date INTO l_disable_date
FROM bom_structure_types_b
WHERE structure_type_id = p_structure_type_id;
SELECT count(*) INTO l_structures_count
FROM bom_bill_of_materials
WHERE structure_type_id = p_structure_type_id;
SELECT count(*) INTO l_count
FROM bom_structure_types_b
WHERE structure_type_id = p_structure_type_id;
X_Delete CONSTANT NUMBER := 3;
SELECT brd.component_reference_designator
FROM bom_reference_designators brd
WHERE brd.component_sequence_id = p_old_component_sequence_id
AND NVL(brd.acd_type, X_Add) = X_Add
UNION
SELECT brd.component_reference_designator
FROM bom_reference_designators brd,
bom_inventory_components bic
WHERE DECODE(bic.old_component_sequence_id, NULL,
bic.component_sequence_id,
bic.old_component_sequence_id) = p_old_component_sequence_id
AND bic.component_sequence_id = brd.component_sequence_id
AND bic.implementation_date IS NULL
AND brd.acd_type = X_Add
MINUS
SELECT brd.component_reference_designator
FROM bom_reference_designators brd,
bom_inventory_components bic
WHERE DECODE(bic.old_component_sequence_id, NULL,
bic.component_sequence_id,
bic.old_component_sequence_id) = p_old_component_sequence_id
AND bic.component_sequence_id = brd.component_sequence_id
AND bic.implementation_date IS NULL
AND brd.acd_type = X_Delete;
SELECT acd_type, old_component_sequence_id
FROM bom_inventory_components bic
WHERE bic.component_sequence_id = p_component_seq_id;
SELECT component_quantity
FROM bom_inventory_components
WHERE component_sequence_id = p_component_seq_id
AND quantity_related = 1;
SELECT component_reference_designator INTO l_dummy
FROM bom_reference_designators brd,bom_inventory_components bic
WHERE bic.component_sequence_id = p_component_seq_id
AND brd.component_sequence_id = bic.old_component_sequence_id
AND brd.component_reference_designator = p_ref_desig_name;
SELECT 'Non-Standard Comp'
INTO l_dummy
FROM bom_inventory_Components bic
WHERE bic.component_sequence_id = p_component_seq_id
AND bic.bom_item_type IN (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
SELECT 'Planning Bill'
INTO l_dummy
FROM sys.dual
WHERE EXISTS (SELECT 'Planning Item'
FROM bom_bill_of_materials bom,
mtl_system_items msi,
bom_inventory_components bic
WHERE msi.bom_item_type = 3 /* PLANNING */
AND msi.inventory_item_id = bom.assembly_item_id
AND msi.organization_id = bom.organization_id
AND bom.bill_sequence_id = bic.bill_sequence_id
AND bic.component_sequence_id = p_component_seq_id
);
SELECT 'parent not disabled'
INTO l_dummy
FROM bom_inventory_components bic
WHERE bic.component_sequence_id = p_component_seq_id
AND NVL(bic.acd_type, 0) <> 3;
SELECT acd_type, old_component_sequence_id
FROM bom_inventory_components bic
WHERE bic.component_sequence_id = p_component_seq_id;
SELECT component_quantity
FROM bom_inventory_components
WHERE component_sequence_id = p_component_seq_id
AND quantity_related = 1;
SELECT eec.change_notice
FROM
eng_engineering_changes eec,
eng_revised_items eri--eng_change_lines ecl
WHERE eri.change_id/*cl.change_id*/ = eec.change_id
-- AND ecl.change_line_id = c_p_change_line_id;
SELECT person_first_name ||' '||person_last_name
FROM hz_parties
WHERE party_id = (SELECT customer_id FROM FND_USER
WHERE user_id = c_p_user_id);