APPS.AHL_MC_ITEM_COMP_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

     SELECT organization_id
     FROM mtl_parameters
     WHERE organization_code = p_org_code;

Line: 32

     SELECT inventory_item_id
     FROM  ahl_mtl_items_non_ou_v
     WHERE concatenated_segments = p_inventory_item_name
     AND   inventory_org_id = p_inv_organization_id;

Line: 39

     SELECT concatenated_segments
     FROM  ahl_mtl_items_non_ou_v
     WHERE inventory_item_id = p_inventory_item_id
     AND  inventory_org_id = p_inv_organization_id;

Line: 181

	 ahl_mc_item_comp_pvt.delete_item_composition(
		 p_api_version              => p_api_version,
		-- p_init_msg_list            =>
		-- p_commit                   =>
		-- p_validation_level         =>
		 x_return_status            => x_return_status,
		 x_msg_count                => x_msg_count,
		 x_msg_data                 => x_msg_data,
		 p_item_composition_id      => p_x_ic_header_rec.item_composition_id,
		 p_object_version_number    => p_x_ic_header_rec.object_version_number);

Line: 262

     SELECT item_group_id
     FROM ahl_item_groups_vl
     WHERE name = p_item_group_name
     AND status_code = 'COMPLETE'
     AND type_code = 'NON-TRACKED';

Line: 270

     SELECT organization_id
     FROM mtl_parameters
     WHERE organization_code = p_org_code;

Line: 277

     SELECT inventory_item_id
     FROM  ahl_mtl_items_non_ou_v
     WHERE concatenated_segments = p_inventory_item_name
     AND   inventory_org_id = p_inv_organization_id;

Line: 285

     SELECT concatenated_segments
     FROM  ahl_mtl_items_non_ou_v
     WHERE inventory_item_id = p_inventory_item_id
     AND  inventory_org_id = p_inv_organization_id;